Discussion :

[agdid04]

Bonjour,

J'ai essayé de restauré une instance 2008R2 sur un server sur lequel tourne 3 instance:

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.

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
C:\>sqlcmd -S .\INSTANCE3
1>	RESTORE DATABASE master FROM DISK ='G:\BACKUP\Backup_Master_BASE_3_03032015' WITH REPLACE;
2>

Merci.

@+

[Invité]

La procédure est détaillée sur MSDN : https://msdn.microsoft.com/en-us/library/ms190679.aspx

[agdid04]

La procédure est détaillée sur MSDN : https://msdn.microsoft.com/en-us/library/ms190679.aspx

Bonjour,

Je reprends:

1- J'arrête mon instance.
2- Je démarre en mode appli:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

C:\Program Files\Microsoft SQL Server\MSSQL10_50.INSTANCE3\MSSQL\Binn>sqlservr.exe -c -m -s INSTANCE3

3- Se connecter avec SQLCMD:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
C:\Users\>sqlcmd  -S MONSERVER\INSTANCE3 -E -d master
Msg 18461, Level 14, State 1, ServerMonServer\INSTANCE3, Line 1
Login failed for user 'DOMAIN\administrator. 
Reason: Server is in single user mode. Only one administrator can connect at this time.
 
C:\Users\administrator>sqlcmd -S MonServer\INSTANCE3 -E -d master -U sa
Sqlcmd: The -E and the -U/-P options are mutually exclusive.
 
C:\Users\>sqlcmd  -S MONSERVER\INSTANCE3  -d master -U sa -P ********
Msg 18456, Level 14, State 1, Server MONSERVER\INSTANCE3, Line 1
Login failed for user 'sa'.

Je ne passe pas !!!

Merci.