Date,Source,Severity,Message 06/01/2014 22:23:49,spid58,Unknown,PostRestoreReplicationFixup for MYDATABASEDB starts 06/01/2014 22:23:49,spid58,Unknown,PostRestoreContainerFixups: fixups complete 06/01/2014 22:23:49,spid58,Unknown,PostRestoreContainerFixups: running fixups on MYDATABASEDB 06/01/2014 22:23:49,spid58,Unknown,FixupLogTail(progress) zeroing F:\MYDATABASEDB\MYDATABASEDB_log.ldf from 0x351e00 to 0x360000. 06/01/2014 22:23:49,spid58,Unknown,Starting up database 'MYDATABASEDB'. 06/01/2014 22:23:49,spid58,Unknown,Restore: Restarting database for ONLINE 06/01/2014 22:23:49,spid58,Unknown,Restore: Transitioning database to ONLINE 06/01/2014 22:23:49,spid58,Unknown,Restore: Done with fixups 06/01/2014 22:23:49,spid58,Unknown,Rollforward complete on database MYDATABASEDB 06/01/2014 22:23:48,spid58,Unknown,Restore-Redo begins on database MYDATABASEDB 06/01/2014 22:23:48,spid58,Unknown,The database 'MYDATABASEDB' is marked RESTORING and is in a state that does not allow recovery to be run. 06/01/2014 22:23:48,spid58,Unknown,Starting up database 'MYDATABASEDB'. 06/01/2014 22:23:48,spid58,Unknown,Restore: Backup set restored 06/01/2014 22:23:48,spid58,Unknown,Restore: Data transfer complete on MYDATABASEDB 06/01/2014 22:23:48,spid58,Unknown,FileHandleCache: 0 files opened. CacheSize: 12 06/01/2014 22:23:48,spid58,Unknown,Restore: LogZero complete 06/01/2014 22:23:48,spid58,Unknown,Restore: Waiting for log zero on MYDATABASEDB 06/01/2014 22:09:50,spid58,Unknown,Restore: Transferring data to MYDATABASEDB 06/01/2014 22:09:50,spid58,Unknown,Restore: Restoring backup set 06/01/2014 22:09:50,spid58,Unknown,Zeroing completed on F:\MYDATABASEDB\MYDATABASEDB_log.ldf 06/01/2014 22:09:50,spid58,Unknown,Restore: Containers are ready 06/01/2014 22:09:50,spid58,Unknown,Zeroing F:\MYDATABASEDB\MYDATABASEDB_log.ldf from page 1 to 2576 (0x2000 to 0x1420000) 06/01/2014 22:09:50,spid58,Unknown,Restore: PreparingContainers 06/01/2014 22:09:50,spid58,Unknown,Restore: Attached database MYDATABASEDB as DBID=7 06/01/2014 22:09:50,spid58,Unknown,Restore: dropping database 06/01/2014 22:09:50,spid58,Unknown,Restore: BeginRestore (offline) on MYDATABASEDB 06/01/2014 22:09:50,spid58,Unknown,Restore: Planning complete 06/01/2014 22:09:50,spid58,Unknown,X-locking database: MYDATABASEDB 06/01/2014 22:09:50,spid58,Unknown,Dismounting FullText catalogs 06/01/2014 22:09:50,spid58,Unknown,Halting FullText crawls on database MYDATABASEDB 06/01/2014 22:09:50,spid58,Unknown,Restore: Planning begins 06/01/2014 22:09:50,spid58,Unknown,Restore: Backup set is open 06/01/2014 22:09:50,spid58,Unknown,Restore: Configuration section loaded 06/01/2014 22:09:50,spid58,Unknown,Opening backup set 06/01/2014 22:09:50,spid58,Unknown,RestoreDatabase: Database MYDATABASEDB 06/01/2014 22:09:50,spid58,Unknown,DBCC TRACEON 3605 server process ID (SPID) 58. This is an informational message only; no user action is required. 06/01/2014 22:09:50,spid58,Unknown,DBCC TRACEON 3004 server process ID (SPID) 58. This is an informational message only; no user action is required. 06/01/2014 22:06:04,spid55,Unknown,Setting database option PAGE_VERIFY to CHECKSUM for database MYDATABASEDB. 06/01/2014 22:06:04,spid55,Unknown,Setting database option MULTI_USER to ON for database MYDATABASEDB. 06/01/2014 22:06:04,spid55,Unknown,Setting database option RECOVERY to FULL for database MYDATABASEDB. 06/01/2014 22:06:04,spid55,Unknown,Setting database option READ_WRITE to ON for database MYDATABASEDB. 06/01/2014 22:06:04,spid55,Unknown,Setting database option PARAMETERIZATION to SIMPLE for database MYDATABASEDB. 06/01/2014 22:06:04,spid55,Unknown,Setting database option DATE_CORRELATION_OPTIMIZATION to OFF for database MYDATABASEDB. 06/01/2014 22:06:04,spid55,Unknown,Setting database option AUTO_UPDATE_STATISTICS_ASYNC to OFF for database MYDATABASEDB. 06/01/2014 22:06:04,spid55,Unknown,Setting database option DISABLE_BROKER to ON for database MYDATABASEDB. 06/01/2014 22:06:04,spid55,Unknown,Setting database option RECURSIVE_TRIGGERS to OFF for database MYDATABASEDB. 06/01/2014 22:06:04,spid55,Unknown,Setting database option QUOTED_IDENTIFIER to OFF for database MYDATABASEDB. 06/01/2014 22:06:04,spid55,Unknown,Setting database option NUMERIC_ROUNDABORT to OFF for database MYDATABASEDB. 06/01/2014 22:06:04,spid55,Unknown,Setting database option CONCAT_NULL_YIELDS_NULL to OFF for database MYDATABASEDB. 06/01/2014 22:06:04,spid55,Unknown,Setting database option CURSOR_DEFAULT to GLOBAL for database MYDATABASEDB. 06/01/2014 22:06:04,spid55,Unknown,Setting database option CURSOR_CLOSE_ON_COMMIT to OFF for database MYDATABASEDB. 06/01/2014 22:06:04,spid55,Unknown,Setting database option AUTO_UPDATE_STATISTICS to ON for database MYDATABASEDB. 06/01/2014 22:06:04,spid55,Unknown,Setting database option AUTO_SHRINK to OFF for database MYDATABASEDB. 06/01/2014 22:06:04,spid55,Unknown,Setting database option AUTO_CREATE_STATISTICS to ON for database MYDATABASEDB. 06/01/2014 22:06:04,spid55,Unknown,Setting database option AUTO_CLOSE to OFF for database MYDATABASEDB. 06/01/2014 22:06:04,spid55,Unknown,Setting database option ARITHABORT to OFF for database MYDATABASEDB. 06/01/2014 22:06:04,spid55,Unknown,Setting database option ANSI_WARNINGS to OFF for database MYDATABASEDB. 06/01/2014 22:06:04,spid55,Unknown,Setting database option ANSI_PADDING to OFF for database MYDATABASEDB. 06/01/2014 22:06:04,spid55,Unknown,Setting database option ANSI_NULLS to OFF for database MYDATABASEDB. 06/01/2014 22:06:04,spid55,Unknown,Setting database option ANSI_NULL_DEFAULT to OFF for database MYDATABASEDB. 06/01/2014 22:06:04,spid55,Unknown,Setting database option COMPATIBILITY_LEVEL to 100 for database MYDATABASEDB. 06/01/2014 22:06:04,spid55,Unknown,Starting up database 'MYDATABASEDB'. 06/01/2014 22:04:45,spid55,Unknown,Using 'xpstar.dll' version '2009.100.1600' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required. 06/01/2014 22:04:45,spid55,Unknown,Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required. 06/01/2014 22:03:35,spid5s,Unknown,Recovery is complete. This is an informational message only. No user action is required. 06/01/2014 22:03:35,spid16s,Unknown,File activation failure. The physical file name "F:\MYDATABASEDB\MYDATABASEdb2_log.ldf" may be incorrect. 06/01/2014 22:03:35,spid16s,Unknown,FileMgr::StartLogFiles: Operating system error 2(Le fichier spécifié est introuvable.) occurred while creating or opening file 'F:\MYDATABASEDB\MYDATABASEdb2_log.ldf'. Diagnose and correct the operating system error and retry the operation. 06/01/2014 22:03:35,spid16s,Unknown,Error: 17207 Severity: 16 State: 1. 06/01/2014 22:03:35,Server,Unknown,SQL Server is now ready for client connections. This is an informational message; no user action is required. 06/01/2014 22:03:35,Server,Unknown,The SQL Server Network Interface library successfully registered the Service Principal Name (SPN) [ MSSQLSvc/POSTEPROD.disloggroup:1433 ] for the SQL Server service. 06/01/2014 22:03:35,Server,Unknown,The SQL Server Network Interface library successfully registered the Service Principal Name (SPN) [ MSSQLSvc/POSTEPROD.disloggroup:ARCHIV_SRV ] for the SQL Server service. 06/01/2014 22:03:35,spid18s,Unknown,Service Broker manager has started. 06/01/2014 22:03:35,spid18s,Unknown,The Database Mirroring protocol transport is disabled or not configured. 06/01/2014 22:03:35,spid18s,Unknown,The Service Broker protocol transport is disabled or not configured. 06/01/2014 22:03:35,spid16s,Unknown,Unable to open the physical file "F:\MYDATABASEDB\MYDATABASEdb.mdf". Operating system error 2: "2(Le fichier spécifié est introuvable.)". 06/01/2014 22:03:35,spid16s,Unknown,Error: 5120 Severity: 16 State: 101. 06/01/2014 22:03:35,spid16s,Unknown,FCB::Open failed: Could not open file F:\MYDATABASEDB\MYDATABASEdb.mdf for file number 1. OS error: 2(Le fichier spécifié est introuvable.). 06/01/2014 22:03:35,spid16s,Unknown,Error: 17204 Severity: 16 State: 1. 06/01/2014 22:03:35,spid16s,Unknown,Starting up database 'MYDATABASEDB'. 06/01/2014 22:03:35,spid11s,Unknown,Starting up database 'tempdb'. 06/01/2014 22:03:35,spid15s,Unknown,Starting up database 'ReportServer$ARCHIV_SRV'. 06/01/2014 22:03:35,spid10s,Unknown,Starting up database 'msdb'. 06/01/2014 22:03:35,spid17s,Unknown,Starting up database 'ScaSystemDB'. 06/01/2014 22:03:35,spid14s,Unknown,Starting up database 'ReportServer$ARCHIV_SRVTempDB'. 06/01/2014 22:03:35,Server,Unknown,Dedicated admin connection support was established for listening locally on port 62287. 06/01/2014 22:03:35,Server,Unknown,Server is listening on [ 127.0.0.1 62287]. 06/01/2014 22:03:35,spid10s,Unknown,A new instance of the full-text filter daemon host process has been successfully started. 06/01/2014 22:03:35,Server,Unknown,Server is listening on [ ::1 62287]. 06/01/2014 22:03:35,Server,Unknown,Server local connection provider is ready to accept connection on [ \\.\pipe\MSSQL$ARCHIV_SRV\sql\query ]. 06/01/2014 22:03:35,Server,Unknown,Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\ARCHIV_SRV ]. 06/01/2014 22:03:35,Server,Unknown,Server is listening on [ 'any' 57304]. 06/01/2014 22:03:35,Server,Unknown,Server is listening on [ 'any' 57304]. 06/01/2014 22:03:35,Server,Unknown,Server is listening on [ 'any' 1433]. 06/01/2014 22:03:35,Server,Unknown,Server is listening on [ 'any' 1433]. 06/01/2014 22:03:35,Server,Unknown,A self-generated certificate was successfully loaded for encryption. 06/01/2014 22:03:35,spid11s,Unknown,Clearing tempdb database. 06/01/2014 22:03:35,spid5s,Unknown,Server name is 'POSTEPROD\ARCHIV_SRV'. This is an informational message only. No user action is required. 06/01/2014 22:03:35,spid11s,Unknown,Starting up database 'model'. 06/01/2014 22:03:34,spid5s,Unknown,The resource database build version is 10.50.1600. This is an informational message only. No user action is required. 06/01/2014 22:03:34,spid5s,Unknown,Starting up database 'mssqlsystemresource'. 06/01/2014 22:03:34,spid5s,Unknown,SQL Trace ID 1 was started by login "sa". 06/01/2014 22:03:34,spid5s,Unknown,FILESTREAM: effective level = 0 configured level = 0 file system access share name = 'ARCHIV_SRV'. 06/01/2014 22:03:34,spid5s,Unknown,SQL Server Audit has started the audits. This is an informational message. No user action is required. 06/01/2014 22:03:34,spid5s,Unknown,SQL Server Audit is starting the audits. This is an informational message. No user action is required. 06/01/2014 22:03:34,spid5s,Unknown,Resource governor reconfiguration succeeded. 06/01/2014 22:03:34,spid5s,Unknown,Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required. 06/01/2014 22:03:34,spid5s,Unknown,0 transactions rolled back in database 'master' (1). This is an informational message only. No user action is required. 06/01/2014 22:03:34,spid5s,Unknown,8 transactions rolled forward in database 'master' (1). This is an informational message only. No user action is required. 06/01/2014 22:03:34,spid5s,Unknown,Starting up database 'master'. 06/01/2014 22:03:34,Server,Unknown,Node configuration: node 0: CPU mask: 0x00000000000000ff:0 Active CPU mask: 0x00000000000000ff:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required. 06/01/2014 22:03:34,Server,Unknown,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. 06/01/2014 22:03:34,Server,Unknown,Using locked pages for buffer pool. 06/01/2014 22:03:34,Server,Unknown,Detected 8 CPUs. This is an informational message; no user action is required. 06/01/2014 22:03:34,Server,Unknown,SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required. 06/01/2014 22:03:34,Server,Unknown,Registry startup parameters: -d C:\Program Files\Microsoft SQL Server\MSSQL10_50.ARCHIV_SRV\MSSQL\DATA\master.mdf -e C:\Program Files\Microsoft SQL Server\MSSQL10_50.ARCHIV_SRV\MSSQL\Log\ERRORLOG -l C:\Program Files\Microsoft SQL Server\MSSQL10_50.ARCHIV_SRV\MSSQL\DATA\mastlog.ldf 06/01/2014 22:03:34,Server,Unknown,This instance of SQL Server last reported using a process ID of 1332 at 31/05/2014 01:18:11 (local) 31/05/2014 00:18:11 (UTC). This is an informational message only; no user action is required. 06/01/2014 22:03:34,Server,Unknown,Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.ARCHIV_SRV\MSSQL\Log\ERRORLOG'. 06/01/2014 22:03:34,Server,Unknown,Authentication mode is MIXED. 06/01/2014 22:03:34,Server,Unknown,System Manufacturer: 'Dell Inc.' System Model: 'PowerEdge R710'. 06/01/2014 22:03:34,Server,Unknown,Server process ID is 7804. 06/01/2014 22:03:34,Server,Unknown,All rights reserved. 06/01/2014 22:03:34,Server,Unknown,(c) Microsoft Corporation. 06/01/2014 22:03:34,Server,Unknown,Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.0 (Build 6002: Service Pack 2)