Bonjour,

J'ai eu ce message lors de la migration d'une instance nommée de 2008 vers 2008R2

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
Script level upgrade for database 'master' failed because upgrade step 'sqlagent100_msdb_upgrade.sql' encountered error 598, state 1, severity 25. 
This is a serious error condition which might interfere with regular operation and the database will be taken offline. If the error happened during upgrade of the 'master' database, 
it will prevent the entire SQL Server instance from starting. Examine the previous errorlog entries for errors, 
take the appropriate corrective actions and re-start the database so that the script upgrade steps run to completion.
J'ai déjà migrée une première instance sans problème sur le même serevr.



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
2014-10-14 12:31:22.07 spid9s      Signing sps ...
2014-10-14 12:31:22.09 spid9s      Dropping existing Agent certificate ...
2014-10-14 12:31:22.09 spid9s      DBCC TRACEON 4606, server process ID (SPID) 9. This is an informational message only; no user action is required.
2014-10-14 12:31:22.09 spid9s      DBCC execution completed. If DBCC printed error messages, contact your system administrator.
2014-10-14 12:31:22.26 spid9s      DBCC TRACEOFF 4606, server process ID (SPID) 9. This is an informational message only; no user action is required.
2014-10-14 12:31:22.26 spid9s      DBCC execution completed. If DBCC printed error messages, contact your system administrator.
2014-10-14 12:31:22.26 spid9s      Error: 5133, Severity: 16, State: 1.
2014-10-14 12:31:22.26 spid9s      Directory lookup for the file "F:\MSSQL_INSTANCE2\temp_MS_AgentSigningCertificate_database.mdf" failed with the 
operating system error 3(failed to retrieve text for this error. Reason: 15105).
2014-10-14 12:31:22.26 spid9s      Error: 1802, Severity: 16, State: 1.
2014-10-14 12:31:22.26 spid9s      CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
2014-10-14 12:31:22.26 spid9s      Error: 912, Severity: 21, State: 2.
2014-10-14 12:31:22.26 spid9s      Script level upgrade for database 'master' failed because upgrade step 'sqlagent100_msdb_upgrade.sql' encountered error 598, 
state 1, severity 25. This is a serious error condition which might interfere with regular operation and the database will be taken offline. 
If the error happened during upgrade of the 'master' database, it will prevent the entire SQL Server instance from starting. Examine the previous errorlog entries for errors, 
take the appropriate corrective actions and re-start the database so that the script upgrade steps run to completion.
2014-10-14 12:31:22.27 spid9s      Error: 3417, Severity: 21, State: 3.
2014-10-14 12:31:22.27 spid9s      Cannot recover the master database. SQL Server is unable to run. Restore master from a full backup, repair it, or rebuild it. For more information about how to rebuild the master database, see SQL Server Books Online.
2014-10-14 12:31:22.27 spid9s      SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
2014-10-14 12:31:22.28 Server      The SQL Server Network Interface library successfully deregistered the Service Principal Name (SPN) [ MSSQLSvc/monserver.COMMUN.AD.SNCF.FR:INSTANCE2 ] for the SQL Server service. 
2014-10-14 12:31:22.28 Server      The SQL Server Network Interface library successfully deregistered the Service Principal Name (SPN) [ MSSQLSvc/monserver.COMMUN.AD.SNCF.FR:50763 ] for the SQL Server service.
Ce dossier n'existe plus: F:\MSSQL_INSTANCE2

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
Directory lookup for the file "F:\MSSQL_INSTANCE2\temp_MS_AgentSigningCertificate_database.mdf" failed with the 
operating system error 3(failed to retrieve text for this error. Reason: 15105).
Comment faire pour le modifier avant de lancer l'Upgrade ?

Merci.

@+