Bonjour,
J'ai essayé de restauré une instance 2008R2 sur un server sur lequel tourne 3 instance:
J'ai essayé la commande restore qui me rend la main de suite
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83 C:\Program Files\Microsoft SQL Server\MSSQL10_50.INSTANCE3\MSSQL\Binn>sqlservr.exe -c -m -s INSTANCE3 2015-03-03 14:47:08.71 Server Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64) Jun 17 2011 00:54:03 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor) 2015-03-03 14:47:08.71 Server (c) Microsoft Corporation. 2015-03-03 14:47:08.71 Server All rights reserved. 2015-03-03 14:47:08.71 Server Server process ID is 4480. 2015-03-03 14:47:08.71 Server System Manufacturer: 'VMware, Inc.', System Model: 'VMware Virtual Platform'. 2015-03-03 14:47:08.72 Server Authentication mode is MIXED. 2015-03-03 14:47:08.72 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.INST ANCE3\MSSQL\Log\ERRORLOG'. 2015-03-03 14:47:08.72 Server This instance of SQL Server last reported using a process ID of 6316 at 03/03/2015 14:36:1 6 (local) 03/03/2015 13:36:16 (UTC). This is an informational message only; no user action is required. 2015-03-03 14:47:08.72 Server Registry startup parameters: -d C:\Program Files\Microsoft SQL Server\MSSQL10_50.INSTANCE3\MSSQL\DATA\master.mdf -e C:\Program Files\Microsoft SQL Server\MSSQL10_50.INSTANCE3\MSSQL\Log\ERRORLOG -l C:\Program Files\Microsoft SQL Server\MSSQL10_50.INSTANCE3\MSSQL\DATA\mastlog.ldf 2015-03-03 14:47:08.72 Server Command Line Startup Parameters: -c -m -s INSTANCE3 INSTANCE3 2015-03-03 14:47:08.73 Server SQL Server is starting at normal priority base (=7). This is an informational message only . No user action is required. 2015-03-03 14:47:08.73 Server Detected 2 CPUs. This is an informational message; no user action is required. 2015-03-03 14:47:08.76 Server Perfmon counters for resource governor pools and groups failed to initialize and are disab led. 2015-03-03 14:47:08.77 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required. 2015-03-03 14:47:08.80 Server Node configuration: node 0: CPU mask: 0x0000000000000003:0 Active CPU mask: 0x000000000000 0003:0. This message provides a description of the NUMA configuration for this computer. This is an informational message onl y. No user action is required. 2015-03-03 14:47:08.81 Server Database Mirroring Transport is disabled in the endpoint configuration. 2015-03-03 14:47:08.82 spid7s Warning ****************** 2015-03-03 14:47:08.82 spid7s SQL Server started in single-user mode. This an informational message only. No user action is required. 2015-03-03 14:47:08.82 spid7s Starting up database 'master'. 2015-03-03 14:47:08.86 spid7s The tail of the log for database master is being rewritten to match the new sector size of 4096 bytes. 2048 bytes at offset 30720 in file C:\Program Files\Microsoft SQL Server\MSSQL10_50.INSTANCE3\MSSQL\DATA\mastlo g.ldf will be written. 2015-03-03 14:47:08.87 spid7s Recovery is writing a checkpoint in database 'master' (1). This is an informational messag e only. No user action is required. 2015-03-03 14:47:08.89 spid7s SQL Server Audit is starting the audits. This is an informational message. No user action is required. 2015-03-03 14:47:08.89 spid7s SQL Server Audit has started the audits. This is an informational message. No user action is required. 2015-03-03 14:47:08.90 spid7s FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'IN STANCE3'. 2015-03-03 14:47:08.91 spid7s SQL Trace ID 1 was started by login "sa". 2015-03-03 14:47:08.91 spid7s Starting up database 'mssqlsystemresource'. 2015-03-03 14:47:08.92 spid7s The resource database build version is 10.50.2500. This is an informational message only. No user action is required. 2015-03-03 14:47:09.31 spid9s Starting up database 'model'. 2015-03-03 14:47:09.32 spid7s Server name is 'MONSERVER\INSTANCE3'. This is an informational message only. No user act ion is required. 2015-03-03 14:47:09.45 spid9s Clearing tempdb database. 2015-03-03 14:47:09.55 spid11s A new instance of the full-text filter daemon host process has been successfully started. 2015-03-03 14:47:09.58 spid11s Starting up database 'msdb'. 2015-03-03 14:47:09.58 spid12s Starting up database 'AT1'. 2015-03-03 14:47:09.58 spid13s Starting up database 'AT3'. 2015-03-03 14:47:09.58 spid14s Starting up database 'COD1'. 2015-03-03 14:47:09.59 spid15s Starting up database 'COD2'. 2015-03-03 14:47:09.59 spid16s Starting up database 'OPERATION'. 2015-03-03 14:47:09.67 Server A self-generated certificate was successfully loaded for encryption. 2015-03-03 14:47:09.67 Server Server is listening on [ 'any' <ipv6> 54514]. 2015-03-03 14:47:09.68 Server Server is listening on [ 'any' <ipv4> 54514]. 2015-03-03 14:47:09.68 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\INSTANCE3 ]. 2015-03-03 14:47:09.68 Server Server local connection provider is ready to accept connection on [ \\.\pipe\MSSQL$INSTANCE3\sql\query ]. 2015-03-03 14:47:09.68 Server Server is listening on [ ::1 <ipv6> 54515]. 2015-03-03 14:47:09.68 Server Server is listening on [ 127.0.0.1 <ipv4> 54515]. 2015-03-03 14:47:09.68 Server Dedicated admin connection support was established for listening locally on port 54515. 2015-03-03 14:47:09.82 spid13s Starting up database 'TSTLOAD'. 2015-03-03 14:47:09.83 Server The SQL Server Network Interface library could not register the Service Principal Name (SP N) for the SQL Server service. Error: 0x5, state: 4. Failure to register an SPN may cause integrated authentication to fall b ack to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies. 2015-03-03 14:47:09.84 Server SQL Server is now ready for client connections. This is an informational message; no user action is required. 2015-03-03 14:47:09.84 spid14s Starting up database 'OPERAVTEMP'. 2015-03-03 14:47:09.91 spid9s Starting up database 'tempdb'. 2015-03-03 14:47:09.96 spid7s Recovery is complete. This is an informational message only. No user action is required.
Merci.
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3 C:\>sqlcmd -S .\INSTANCE3 1> RESTORE DATABASE master FROM DISK ='G:\BACKUP\Backup_Master_BASE_3_03032015' WITH REPLACE; 2>
@+
Partager