SQL SERVER 2005 BDD en recuperation

Version imprimable

13/12/2010, 16h47
yaloum59

SQL SERVER 2005 BDD en recuperation

Bonjour à tous,
J'ai une BDD qui est en récuparation depuis plus de 72 heures, je n'arrive pas à la détacher, ni à la mettre hors ligne.
J'ai vraiment besoin d'aide
Merci
13/12/2010, 17h13
SQLpro

Avez-vous passer la dernière sauvegarde en restauration avec le mode RECOVERY ? Si ce n'est pas le cas, il faut recommencer depuis le début !

A +
13/12/2010, 17h50
yaloum59

Merci pour la réponse,
Non, je n'ai pas effectué de restauration, en fait, le vendredi j'ai vue que la bdd était en récuperation, et je me suis dis, qu'elle a tout le week-end pour faire ça, mais aujourd'hui, elle est tout le temps en récuperation, et je n'arrive pas à faire quoi que ce soit.
Le dernier fichier log est sur la piece jointe
13/12/2010, 17h53
yaloum59

piece jointe

Citation:

2010-12-13 16:58:56.85 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

2010-12-13 16:58:56.85 Server (c) 2005 Microsoft Corporation.
2010-12-13 16:58:56.85 Server All rights reserved.
2010-12-13 16:58:56.85 Server Server process ID is 4104.
2010-12-13 16:58:56.85 Server Logging SQL Server messages in file 'E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2010-12-13 16:58:56.85 Server This instance of SQL Server last reported using a process ID of 4564 at 13/12/2010 16:21:13 (local) 13/12/2010 15:21:13 (UTC). This is an informational message only; no user action is required.
2010-12-13 16:58:56.85 Server Registry startup parameters:
2010-12-13 16:58:56.85 Server -d E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2010-12-13 16:58:56.85 Server -e E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2010-12-13 16:58:56.85 Server -l E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2010-12-13 16:58:56.89 Serveur SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2010-12-13 16:58:56.89 Serveur Detected 2 CPUs. This is an informational message; no user action is required.
2010-12-13 16:58:56.95 Serveur Set AWE Enabled to 1 in the configuration parameters to allow use of more memory.
2010-12-13 16:58:57.15 Serveur 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.
2010-12-13 16:58:57.20 Serveur Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2010-12-13 16:58:59.25 Serveur Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2010-12-13 16:58:59.25 Serveur Database Mirroring Transport is disabled in the endpoint configuration.
2010-12-13 16:58:59.26 spid5s Starting up database 'master'.
2010-12-13 16:58:59.87 spid5s 18 transactions rolled forward in database 'master' (1). This is an informational message only. No user action is required.
2010-12-13 16:58:59.90 spid5s 0 transactions rolled back in database 'master' (1). This is an informational message only. No user action is required.
2010-12-13 16:58:59.90 spid5s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2010-12-13 16:59:00.03 spid5s SQL Trace ID 1 was started by login "sa".
2010-12-13 16:59:00.04 spid5s Starting up database 'mssqlsystemresource'.
2010-12-13 16:59:00.20 spid5s Server name is 'SRV-STATS2'. This is an informational message only. No user action is required.
2010-12-13 16:59:00.20 spid9s Starting up database 'model'.
2010-12-13 16:59:00.53 Serveur A self-generated certificate was successfully loaded for encryption.
2010-12-13 16:59:00.54 Serveur Server is listening on [ 'any' <ipv4> 1433].
2010-12-13 16:59:00.54 Serveur Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
2010-12-13 16:59:00.54 Serveur Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].
2010-12-13 16:59:00.54 Serveur Server is listening on [ 127.0.0.1 <ipv4> 1434].
2010-12-13 16:59:00.54 Serveur Dedicated admin connection support was established for listening locally on port 1434.
2010-12-13 16:59:00.57 Serveur SQL Server is now ready for client connections. This is an informational message; no user action is required.
2010-12-13 16:59:00.60 spid9s Clearing tempdb database.
2010-12-13 16:59:00.62 spid13s Starting up database 'ReportServer'.
2010-12-13 16:59:00.62 spid14s Starting up database 'ReportServerTempDB'.
2010-12-13 16:59:00.62 spid15s Starting up database 'AdventureWorksDW'.
2010-12-13 16:59:00.62 spid12s Starting up database 'msdb'.
2010-12-13 16:59:00.64 spid16s Starting up database 'AdventureWorks'.
2010-12-13 16:59:00.64 spid17s Starting up database 'CMSMENO'.
2010-12-13 16:59:00.64 spid19s Starting up database 'Finance_Direct'.
2010-12-13 16:59:00.64 spid18s Starting up database 'Smeno_Comptage'.
2010-12-13 16:59:02.15 spid13s Starting up database 'Mutation'.
2010-12-13 16:59:02.20 spid16s Starting up database 'Smeno'.
2010-12-13 16:59:02.23 spid15s Starting up database 'SMINO'.
2010-12-13 16:59:02.32 spid14s Starting up database 'Smeno_Pro'.
2010-12-13 16:59:02.45 spid12s Starting up database 'KPMG'.
2010-12-13 16:59:07.57 Erreur*: 18456, Gravité*: 14, État*: 16.
2010-12-13 16:59:07.57 Login failed for user 'INTRA\Administrateur'. [CLIENT*: <local machine>]
2010-12-13 16:59:07.68 spid9s Starting up database 'tempdb'.
2010-12-13 16:59:10.71 spid20s The Service Broker protocol transport is disabled or not configured.
2010-12-13 16:59:10.71 spid20s The Database Mirroring protocol transport is disabled or not configured.
2010-12-13 16:59:12.37 spid12s Starting up database 'Controle'.
2010-12-13 16:59:12.56 spid20s Service Broker manager has started.
2010-12-13 16:59:17.98 spid16s Starting up database 'Forfait'.
2010-12-13 16:59:19.07 Erreur*: 18456, Gravité*: 14, État*: 16.
2010-12-13 16:59:19.07 Login failed for user 'AUTORITE NT\SYSTEM'. [CLIENT*: 127.0.0.1]
2010-12-13 16:59:21.34 spid16s Starting up database 'Marketing'.
2010-12-13 16:59:21.68 Erreur*: 18456, Gravité*: 14, État*: 16.
2010-12-13 16:59:21.68 Login failed for user 'AUTORITE NT\SYSTEM'. [CLIENT*: 127.0.0.1]
2010-12-13 16:59:22.23 spid17s 43 transactions rolled forward in database 'CMSMENO' (9). This is an informational message only. No user action is required.
2010-12-13 16:59:23.57 spid17s 0 transactions rolled back in database 'CMSMENO' (9). This is an informational message only. No user action is required.
2010-12-13 16:59:23.57 spid17s Recovery is writing a checkpoint in database 'CMSMENO' (9). This is an informational message only. No user action is required.
2010-12-13 16:59:24.20 Erreur*: 18456, Gravité*: 14, État*: 16.
2010-12-13 16:59:24.20 Login failed for user 'AUTORITE NT\SYSTEM'. [CLIENT*: 127.0.0.1]
2010-12-13 16:59:24.68 spid17s Starting up database 'ID_MUT'.
2010-12-13 16:59:31.29 spid14s Starting up database 'Pour_COGNOS'.
2010-12-13 16:59:33.84 spid15s Analysis of database 'SMINO' (14) is 100% complete (approximately 0 seconds remain). This is an informational message only. No user action is required.
2010-12-13 16:59:34.89 spid17s Starting up database 'Quotidien'.
2010-12-13 16:59:34.96 spid15s Starting up database 'Synthése'.
2010-12-13 16:59:37.57 spid18s Analysis of database 'Smeno_Comptage' (10) is 1% complete (approximately 343 seconds remain). This is an informational message only. No user action is required.
2010-12-13 16:59:39.95 spid18s Analysis of database 'Smeno_Comptage' (10) is 2% complete (approximately 251 seconds remain). This is an informational message only. No user action is required.
2010-12-13 16:59:41.70 spid18s Analysis of database 'Smeno_Comptage' (10) is 4% complete (approximately 182 seconds remain). This is an informational message only. No user action is required.
2010-12-13 16:59:43.10 spid18s Analysis of database 'Smeno_Comptage' (10) is 7% complete (approximately 133 seconds remain). This is an informational message only. No user action is required.
2010-12-13 16:59:44.79 spid18s Analysis of database 'Smeno_Comptage' (10) is 10% complete (approximately 101 seconds remain). This is an informational message only. No user action is required.
2010-12-13 16:59:47.17 spid18s Analysis of database 'Smeno_Comptage' (10) is 13% complete (approximately 95 seconds remain). This is an informational message only. No user action is required.
2010-12-13 16:59:48.46 spid18s Analysis of database 'Smeno_Comptage' (10) is 17% complete (approximately 73 seconds remain). This is an informational message only. No user action is required.
2010-12-13 16:59:49.70 spid18s Analysis of database 'Smeno_Comptage' (10) is 23% complete (approximately 56 seconds remain). This is an informational message only. No user action is required.
2010-12-13 16:59:51.32 spid18s Analysis of database 'Smeno_Comptage' (10) is 30% complete (approximately 43 seconds remain). This is an informational message only. No user action is required.
2010-12-13 16:59:53.04 spid18s Analysis of database 'Smeno_Comptage' (10) is 38% complete (approximately 33 seconds remain). This is an informational message only. No user action is required.
2010-12-13 16:59:55.09 spid18s Analysis of database 'Smeno_Comptage' (10) is 47% complete (approximately 25 seconds remain). This is an informational message only. No user action is required.
2010-12-13 16:59:57.57 spid18s Analysis of database 'Smeno_Comptage' (10) is 57% complete (approximately 18 seconds remain). This is an informational message only. No user action is required.
2010-12-13 17:00:00.10 spid18s Analysis of database 'Smeno_Comptage' (10) is 69% complete (approximately 12 seconds remain). This is an informational message only. No user action is required.
2010-12-13 17:00:03.31 spid18s Analysis of database 'Smeno_Comptage' (10) is 81% complete (approximately 6 seconds remain). This is an informational message only. No user action is required.
2010-12-13 17:00:06.87 spid18s Analysis of database 'Smeno_Comptage' (10) is 95% complete (approximately 1 seconds remain). This is an informational message only. No user action is required.
2010-12-13 17:00:08.45 spid18s Analysis of database 'Smeno_Comptage' (10) is 100% complete (approximately 0 seconds remain). This is an informational message only. No user action is required.
2010-12-13 17:00:08.48 spid18s Recovery of database 'Smeno_Comptage' (10) is 0% complete (approximately 6914 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:00:28.48 spid18s Recovery of database 'Smeno_Comptage' (10) is 0% complete (approximately 4123 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:00:50.04 spid18s Recovery of database 'Smeno_Comptage' (10) is 0% complete (approximately 4115 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:06:30.34 spid66 Using 'xpstar90.dll' version '2005.90.1399' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
2010-12-13 17:32:35.26 spid18s Recovery of database 'Smeno_Comptage' (10) is 28% complete (approximately 4821 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:32:40.09 spid18s Recovery of database 'Smeno_Comptage' (10) is 29% complete (approximately 4777 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:33:00.12 spid18s Recovery of database 'Smeno_Comptage' (10) is 29% complete (approximately 4770 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:33:20.12 spid18s Recovery of database 'Smeno_Comptage' (10) is 29% complete (approximately 4722 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:33:31.90 spid18s Recovery of database 'Smeno_Comptage' (10) is 30% complete (approximately 4673 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:33:51.93 spid18s Recovery of database 'Smeno_Comptage' (10) is 30% complete (approximately 4579 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:34:00.87 spid18s Recovery of database 'Smeno_Comptage' (10) is 31% complete (approximately 4522 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:34:20.87 spid18s Recovery of database 'Smeno_Comptage' (10) is 31% complete (approximately 4421 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:34:34.07 spid18s Recovery of database 'Smeno_Comptage' (10) is 32% complete (approximately 4388 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:34:54.12 spid18s Recovery of database 'Smeno_Comptage' (10) is 32% complete (approximately 4360 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:35:14.12 spid18s Recovery of database 'Smeno_Comptage' (10) is 32% complete (approximately 4343 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:35:34.39 spid18s Recovery of database 'Smeno_Comptage' (10) is 32% complete (approximately 4327 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:35:40.53 spid18s Recovery of database 'Smeno_Comptage' (10) is 33% complete (approximately 4322 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:36:00.62 spid18s Recovery of database 'Smeno_Comptage' (10) is 33% complete (approximately 4309 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:36:20.95 spid18s Recovery of database 'Smeno_Comptage' (10) is 33% complete (approximately 4298 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:36:41.12 spid18s Recovery of database 'Smeno_Comptage' (10) is 33% complete (approximately 4291 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:36:56.96 spid18s Recovery of database 'Smeno_Comptage' (10) is 34% complete (approximately 4285 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:37:17.07 spid18s Recovery of database 'Smeno_Comptage' (10) is 34% complete (approximately 4280 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:37:37.09 spid18s Recovery of database 'Smeno_Comptage' (10) is 34% complete (approximately 4275 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:37:57.25 spid18s Recovery of database 'Smeno_Comptage' (10) is 34% complete (approximately 4266 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:38:17.34 spid18s Recovery of database 'Smeno_Comptage' (10) is 34% complete (approximately 4259 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:38:29.78 spid18s Recovery of database 'Smeno_Comptage' (10) is 35% complete (approximately 4254 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:38:49.84 spid18s Recovery of database 'Smeno_Comptage' (10) is 35% complete (approximately 4248 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:39:09.90 spid18s Recovery of database 'Smeno_Comptage' (10) is 35% complete (approximately 4241 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:39:30.21 spid18s Recovery of database 'Smeno_Comptage' (10) is 35% complete (approximately 4235 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:39:48.29 spid18s Recovery of database 'Smeno_Comptage' (10) is 36% complete (approximately 4229 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:40:08.54 spid18s Recovery of database 'Smeno_Comptage' (10) is 36% complete (approximately 4223 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:40:28.56 spid18s Recovery of database 'Smeno_Comptage' (10) is 36% complete (approximately 4214 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:40:48.68 spid18s Recovery of database 'Smeno_Comptage' (10) is 36% complete (approximately 4206 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:41:08.90 spid18s Recovery of database 'Smeno_Comptage' (10) is 36% complete (approximately 4200 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:41:24.29 spid18s Recovery of database 'Smeno_Comptage' (10) is 37% complete (approximately 4195 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:41:44.43 spid18s Recovery of database 'Smeno_Comptage' (10) is 37% complete (approximately 4189 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:42:04.56 spid18s Recovery of database 'Smeno_Comptage' (10) is 37% complete (approximately 4185 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:42:24.64 spid18s Recovery of database 'Smeno_Comptage' (10) is 37% complete (approximately 4180 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:42:44.75 spid18s Recovery of database 'Smeno_Comptage' (10) is 37% complete (approximately 4175 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:43:07.87 spid18s Recovery of database 'Smeno_Comptage' (10) is 38% complete (approximately 4171 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:43:37.03 spid18s Recovery of database 'Smeno_Comptage' (10) is 38% complete (approximately 4166 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:44:03.12 spid18s Recovery of database 'Smeno_Comptage' (10) is 38% complete (approximately 4162 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:44:36.54 spid18s Recovery of database 'Smeno_Comptage' (10) is 39% complete (approximately 4157 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:45:08.56 spid18s Recovery of database 'Smeno_Comptage' (10) is 39% complete (approximately 4153 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:45:38.23 spid18s Recovery of database 'Smeno_Comptage' (10) is 39% complete (approximately 4148 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:46:10.32 spid18s Recovery of database 'Smeno_Comptage' (10) is 39% complete (approximately 4144 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:46:44.50 spid18s Recovery of database 'Smeno_Comptage' (10) is 40% complete (approximately 4139 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:47:06.73 spid18s Recovery of database 'Smeno_Comptage' (10) is 40% complete (approximately 4135 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:47:27.34 spid18s Recovery of database 'Smeno_Comptage' (10) is 40% complete (approximately 4130 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:47:52.12 spid18s Recovery of database 'Smeno_Comptage' (10) is 40% complete (approximately 4125 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:48:14.70 spid18s Recovery of database 'Smeno_Comptage' (10) is 41% complete (approximately 4120 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:48:35.07 spid18s Recovery of database 'Smeno_Comptage' (10) is 41% complete (approximately 4114 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:48:56.07 spid18s Recovery of database 'Smeno_Comptage' (10) is 41% complete (approximately 4110 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:49:16.14 spid18s Recovery of database 'Smeno_Comptage' (10) is 41% complete (approximately 4105 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:49:45.76 spid18s Recovery of database 'Smeno_Comptage' (10) is 42% complete (approximately 4100 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:50:47.51 spid18s Recovery of database 'Smeno_Comptage' (10) is 42% complete (approximately 4095 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:51:56.17 spid18s Recovery of database 'Smeno_Comptage' (10) is 42% complete (approximately 4093 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:52:03.92 spid18s Recovery of database 'Smeno_Comptage' (10) is 42% complete (approximately 4093 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 17:52:21.34 spid18s Recovery of database 'Smeno_Comptage' (10) is 17% complete (approximately 14247 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 17:52:41.39 spid18s Recovery of database 'Smeno_Comptage' (10) is 17% complete (approximately 14327 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 17:53:01.39 spid18s Recovery of database 'Smeno_Comptage' (10) is 17% complete (approximately 14323 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 17:53:05.42 spid18s Recovery of database 'Smeno_Comptage' (10) is 18% complete (approximately 14104 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 17:53:25.42 spid18s Recovery of database 'Smeno_Comptage' (10) is 18% complete (approximately 13702 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 17:53:45.43 spid18s Recovery of database 'Smeno_Comptage' (10) is 18% complete (approximately 13918 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 17:54:05.43 spid18s Recovery of database 'Smeno_Comptage' (10) is 18% complete (approximately 13662 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 17:54:13.15 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 13502 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 17:54:33.15 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 13302 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 17:54:53.20 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 13253 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 17:55:13.20 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 13321 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 17:55:33.21 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 13391 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
13/12/2010, 21h18
SQLpro

détachez la et rattachez la sur un autre serveur après avoir copié les fichiers.

Mais il faudrait avoir toute votre config serveur matérielle, ainsi que les éléments de volumétrie sur les disques.....

A +
14/12/2010, 08h47
mikedavem

Bonjour,

Et un RESTORE DATABASE ... WITH RECOVERYdonne quoi chez vous ?

++
14/12/2010, 09h36
SQLpro

je pense à des disques saturés......

A +
15/12/2010, 11h08
yaloum59

Bonjour à tous,
1. pour detacher et ratacher, ceci a été fait mais ceci n'aboutit pas dans le sens où la réponse est que la BDD est en cours d'utilisation.
2. Restaurer la BDD avec Recovry, a réponse est que la BDD est en cours d'utilisation.
3. Pas de place dans le disque dur, là, je suis sur un environnement VMware, avec 600 Go pour le serveur concerné, et j'ai encore 250Go de libre, cependant le dataStore 106Go de libre sur 1T6
15/12/2010, 11h36
mikedavem

Que dit le journal des evenements et le journal d'erreur SQL Server ?

Que donne la commande DBCC SQLPERF(LOGSPACE) ?

++
15/12/2010, 14h05
yaloum59

Pour information, la bdd Smenocomptage n'est plus en récuperation.
Je peux travailler normalement.
Cependant, je n'ai pas compris, et j'aimerai bien comprendre ce qui s'est passé, et est-ce que je ne vais pas revivre la même chose à un autre moment.

Citation:

Le fichier log: à partir du 13/12 18h
2010-12-13 18:10:35.56 spid18s Recovery of database 'Smeno_Comptage' (10) is 20% complete (approximately 16610 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:10:55.56 spid18s Recovery of database 'Smeno_Comptage' (10) is 20% complete (approximately 16667 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:11:15.71 spid18s Recovery of database 'Smeno_Comptage' (10) is 20% complete (approximately 16672 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:11:35.79 spid18s Recovery of database 'Smeno_Comptage' (10) is 20% complete (approximately 16679 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:11:56.00 spid18s Recovery of database 'Smeno_Comptage' (10) is 20% complete (approximately 16710 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:12:16.20 spid18s Recovery of database 'Smeno_Comptage' (10) is 20% complete (approximately 16743 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:12:36.21 spid18s Recovery of database 'Smeno_Comptage' (10) is 20% complete (approximately 16828 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:12:56.37 spid18s Recovery of database 'Smeno_Comptage' (10) is 20% complete (approximately 16862 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:12:57.03 spid18s Recovery of database 'Smeno_Comptage' (10) is 100% complete (approximately 0 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:12:57.04 spid18s 1 transactions rolled back in database 'Smeno_Comptage' (10). This is an informational message only. No user action is required.
2010-12-13 18:12:57.04 spid18s Recovery is writing a checkpoint in database 'Smeno_Comptage' (10). This is an informational message only. No user action is required.
2010-12-13 18:20:55.78 spid5s Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) has completed. This is an informational message only. No user action is required.
2010-12-13 18:20:55.78 spid5s Recovery is complete. This is an informational message only. No user action is required.
2010-12-14 00:00:35.96 spid12s This instance of SQL Server has been using a process ID of 4104 since 13/12/2010 18:20:55 (local) 13/12/2010 17:20:55 (UTC). This is an informational message only; no user action is required.
2010-12-15 00:00:08.02 spid16s This instance of SQL Server has been using a process ID of 4104 since 13/12/2010 18:20:55 (local) 13/12/2010 17:20:55 (UTC). This is an informational message only; no user action is required.
2010-12-15 08:34:33.88 spid66 Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.
2010-12-15 08:34:35.01 spid66 Configuration option 'Agent XPs' changed from 1 to 1. Run the RECONFIGURE statement to install.
2010-12-15 08:34:55.24 spid67 Using 'xpsqlbot.dll' version '2005.90.1399' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
2010-12-15 08:34:55.57 spid67 Using 'xplog70.dll' version '2005.90.1399' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.

La commande DBCC SQLPERF(LOGSPACE)

master 8,992188 25,89053 0
tempdb 2,742188 44,58689 0
model 0,9921875 46,06299 0
msdb 1,992188 40,19608 0
ReportServer 0,8046875 45,93447 0
ReportServerTempDB 0,8046875 38,47087 0
AdventureWorksDW 1,992188 39,41177 0
AdventureWorks 1,992188 33,13726 0
CMSMENO 2110,305 97,52021 0
Smeno_Comptage 9697,867 0,8633301 0
Finance_Direct 373,9922 26,61214 0
Mutation 112,9922 26,63132 0
Smeno 417,3672 3,061064 0
SMINO 8014,742 1,178438 0
Smeno_Pro 3738,805 0,7978768 0
KPMG 82,42969 10,17676 0
Controle 1585,43 2,224819 0
Forfait 4,554688 27,16552 0
Marketing 109,9922 26,65184 0
ID_MUT 61,92969 12,70973 0
Pour_COGNOS 132,8672 91,94192 0
Quotidien 0,9921875 48,47441 0
Synthése 555,5547 2,69684 0
15/12/2010, 14h28
mikedavem

Je ne vois pas de probleme en particulier la (vu de loin).

Visiblement la base de donnes 'Smeno_Comptage' a pris un peu de temps dans la phase recovery. (visiblement pour la phase 2 = phase redo)

Vous parlez de 72 heures mais la je vois :

Debut d'analyse de la base : 2010-12-13 16:59:37.57
Fin recovery : 2010-12-13 18:12:57.03

Ca fait une bonne heure ca mais pas 72 ??? Pouvez vous nous en dire plus ?

++
15/12/2010, 15h17
yaloum59

Non, c'est bien plus que 72 heures
ça a commencé le vendredi 10/12 à 16h
La bdd est en Récuperation
Je reviens le Lundi, elle est tjs en Récuperation, et vers 16h j'ai pris la décision de demande de l'aide.
Le mardi 14, je n'étais pas au bureau
Le mercredi à 09h le BDD est en ligne.

Voici le dernier Log au complet

Citation:

2010-12-13 16:58:56.85 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

2010-12-13 16:58:56.85 Server (c) 2005 Microsoft Corporation.
2010-12-13 16:58:56.85 Server All rights reserved.
2010-12-13 16:58:56.85 Server Server process ID is 4104.
2010-12-13 16:58:56.85 Server Logging SQL Server messages in file 'E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2010-12-13 16:58:56.85 Server This instance of SQL Server last reported using a process ID of 4564 at 13/12/2010 16:21:13 (local) 13/12/2010 15:21:13 (UTC). This is an informational message only; no user action is required.
2010-12-13 16:58:56.85 Server Registry startup parameters:
2010-12-13 16:58:56.85 Server -d E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2010-12-13 16:58:56.85 Server -e E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2010-12-13 16:58:56.85 Server -l E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2010-12-13 16:58:56.89 Serveur SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2010-12-13 16:58:56.89 Serveur Detected 2 CPUs. This is an informational message; no user action is required.
2010-12-13 16:58:56.95 Serveur Set AWE Enabled to 1 in the configuration parameters to allow use of more memory.
2010-12-13 16:58:57.15 Serveur 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.
2010-12-13 16:58:57.20 Serveur Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2010-12-13 16:58:59.25 Serveur Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2010-12-13 16:58:59.25 Serveur Database Mirroring Transport is disabled in the endpoint configuration.
2010-12-13 16:58:59.26 spid5s Starting up database 'master'.
2010-12-13 16:58:59.87 spid5s 18 transactions rolled forward in database 'master' (1). This is an informational message only. No user action is required.
2010-12-13 16:58:59.90 spid5s 0 transactions rolled back in database 'master' (1). This is an informational message only. No user action is required.
2010-12-13 16:58:59.90 spid5s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2010-12-13 16:59:00.03 spid5s SQL Trace ID 1 was started by login "sa".
2010-12-13 16:59:00.04 spid5s Starting up database 'mssqlsystemresource'.
2010-12-13 16:59:00.20 spid5s Server name is 'SRV-STATS2'. This is an informational message only. No user action is required.
2010-12-13 16:59:00.20 spid9s Starting up database 'model'.
2010-12-13 16:59:00.53 Serveur A self-generated certificate was successfully loaded for encryption.
2010-12-13 16:59:00.54 Serveur Server is listening on [ 'any' <ipv4> 1433].
2010-12-13 16:59:00.54 Serveur Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
2010-12-13 16:59:00.54 Serveur Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].
2010-12-13 16:59:00.54 Serveur Server is listening on [ 127.0.0.1 <ipv4> 1434].
2010-12-13 16:59:00.54 Serveur Dedicated admin connection support was established for listening locally on port 1434.
2010-12-13 16:59:00.57 Serveur SQL Server is now ready for client connections. This is an informational message; no user action is required.
2010-12-13 16:59:00.60 spid9s Clearing tempdb database.
2010-12-13 16:59:00.62 spid13s Starting up database 'ReportServer'.
2010-12-13 16:59:00.62 spid14s Starting up database 'ReportServerTempDB'.
2010-12-13 16:59:00.62 spid15s Starting up database 'AdventureWorksDW'.
2010-12-13 16:59:00.62 spid12s Starting up database 'msdb'.
2010-12-13 16:59:00.64 spid16s Starting up database 'AdventureWorks'.
2010-12-13 16:59:00.64 spid17s Starting up database 'CMSMENO'.
2010-12-13 16:59:00.64 spid19s Starting up database 'Finance_Direct'.
2010-12-13 16:59:00.64 spid18s Starting up database 'Smeno_Comptage'.
2010-12-13 16:59:02.15 spid13s Starting up database 'Mutation'.
2010-12-13 16:59:02.20 spid16s Starting up database 'Smeno'.
2010-12-13 16:59:02.23 spid15s Starting up database 'SMINO'.
2010-12-13 16:59:02.32 spid14s Starting up database 'Smeno_Pro'.
2010-12-13 16:59:02.45 spid12s Starting up database 'KPMG'.
2010-12-13 16:59:07.57 Erreur*: 18456, Gravité*: 14, État*: 16.
2010-12-13 16:59:07.57 Login failed for user 'INTRA\Administrateur'. [CLIENT*: <local machine>]
2010-12-13 16:59:07.68 spid9s Starting up database 'tempdb'.
2010-12-13 16:59:10.71 spid20s The Service Broker protocol transport is disabled or not configured.
2010-12-13 16:59:10.71 spid20s The Database Mirroring protocol transport is disabled or not configured.
2010-12-13 16:59:12.37 spid12s Starting up database 'Controle'.
2010-12-13 16:59:12.56 spid20s Service Broker manager has started.
2010-12-13 16:59:17.98 spid16s Starting up database 'Forfait'.
2010-12-13 16:59:19.07 Erreur*: 18456, Gravité*: 14, État*: 16.
2010-12-13 16:59:19.07 Login failed for user 'AUTORITE NT\SYSTEM'. [CLIENT*: 127.0.0.1]
2010-12-13 16:59:21.34 spid16s Starting up database 'Marketing'.
2010-12-13 16:59:21.68 Erreur*: 18456, Gravité*: 14, État*: 16.
2010-12-13 16:59:21.68 Login failed for user 'AUTORITE NT\SYSTEM'. [CLIENT*: 127.0.0.1]
2010-12-13 16:59:22.23 spid17s 43 transactions rolled forward in database 'CMSMENO' (9). This is an informational message only. No user action is required.
2010-12-13 16:59:23.57 spid17s 0 transactions rolled back in database 'CMSMENO' (9). This is an informational message only. No user action is required.
2010-12-13 16:59:23.57 spid17s Recovery is writing a checkpoint in database 'CMSMENO' (9). This is an informational message only. No user action is required.
2010-12-13 16:59:24.20 Erreur*: 18456, Gravité*: 14, État*: 16.
2010-12-13 16:59:24.20 Login failed for user 'AUTORITE NT\SYSTEM'. [CLIENT*: 127.0.0.1]
2010-12-13 16:59:24.68 spid17s Starting up database 'ID_MUT'.
2010-12-13 16:59:31.29 spid14s Starting up database 'Pour_COGNOS'.
2010-12-13 16:59:33.84 spid15s Analysis of database 'SMINO' (14) is 100% complete (approximately 0 seconds remain). This is an informational message only. No user action is required.
2010-12-13 16:59:34.89 spid17s Starting up database 'Quotidien'.
2010-12-13 16:59:34.96 spid15s Starting up database 'Synthése'.
2010-12-13 16:59:37.57 spid18s Analysis of database 'Smeno_Comptage' (10) is 1% complete (approximately 343 seconds remain). This is an informational message only. No user action is required.
2010-12-13 16:59:39.95 spid18s Analysis of database 'Smeno_Comptage' (10) is 2% complete (approximately 251 seconds remain). This is an informational message only. No user action is required.
2010-12-13 16:59:41.70 spid18s Analysis of database 'Smeno_Comptage' (10) is 4% complete (approximately 182 seconds remain). This is an informational message only. No user action is required.
2010-12-13 16:59:43.10 spid18s Analysis of database 'Smeno_Comptage' (10) is 7% complete (approximately 133 seconds remain). This is an informational message only. No user action is required.
2010-12-13 16:59:44.79 spid18s Analysis of database 'Smeno_Comptage' (10) is 10% complete (approximately 101 seconds remain). This is an informational message only. No user action is required.
2010-12-13 16:59:47.17 spid18s Analysis of database 'Smeno_Comptage' (10) is 13% complete (approximately 95 seconds remain). This is an informational message only. No user action is required.
2010-12-13 16:59:48.46 spid18s Analysis of database 'Smeno_Comptage' (10) is 17% complete (approximately 73 seconds remain). This is an informational message only. No user action is required.
2010-12-13 16:59:49.70 spid18s Analysis of database 'Smeno_Comptage' (10) is 23% complete (approximately 56 seconds remain). This is an informational message only. No user action is required.
2010-12-13 16:59:51.32 spid18s Analysis of database 'Smeno_Comptage' (10) is 30% complete (approximately 43 seconds remain). This is an informational message only. No user action is required.
2010-12-13 16:59:53.04 spid18s Analysis of database 'Smeno_Comptage' (10) is 38% complete (approximately 33 seconds remain). This is an informational message only. No user action is required.
2010-12-13 16:59:55.09 spid18s Analysis of database 'Smeno_Comptage' (10) is 47% complete (approximately 25 seconds remain). This is an informational message only. No user action is required.
2010-12-13 16:59:57.57 spid18s Analysis of database 'Smeno_Comptage' (10) is 57% complete (approximately 18 seconds remain). This is an informational message only. No user action is required.
2010-12-13 17:00:00.10 spid18s Analysis of database 'Smeno_Comptage' (10) is 69% complete (approximately 12 seconds remain). This is an informational message only. No user action is required.
2010-12-13 17:00:03.31 spid18s Analysis of database 'Smeno_Comptage' (10) is 81% complete (approximately 6 seconds remain). This is an informational message only. No user action is required.
2010-12-13 17:00:06.87 spid18s Analysis of database 'Smeno_Comptage' (10) is 95% complete (approximately 1 seconds remain). This is an informational message only. No user action is required.
2010-12-13 17:00:08.45 spid18s Analysis of database 'Smeno_Comptage' (10) is 100% complete (approximately 0 seconds remain). This is an informational message only. No user action is required.
2010-12-13 17:00:08.48 spid18s Recovery of database 'Smeno_Comptage' (10) is 0% complete (approximately 6914 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:00:28.48 spid18s Recovery of database 'Smeno_Comptage' (10) is 0% complete (approximately 4123 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:00:50.04 spid18s Recovery of database 'Smeno_Comptage' (10) is 0% complete (approximately 4115 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:06:30.34 spid66 Using 'xpstar90.dll' version '2005.90.1399' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
2010-12-13 17:32:35.26 spid18s Recovery of database 'Smeno_Comptage' (10) is 28% complete (approximately 4821 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:32:40.09 spid18s Recovery of database 'Smeno_Comptage' (10) is 29% complete (approximately 4777 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:33:00.12 spid18s Recovery of database 'Smeno_Comptage' (10) is 29% complete (approximately 4770 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:33:20.12 spid18s Recovery of database 'Smeno_Comptage' (10) is 29% complete (approximately 4722 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:33:31.90 spid18s Recovery of database 'Smeno_Comptage' (10) is 30% complete (approximately 4673 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:33:51.93 spid18s Recovery of database 'Smeno_Comptage' (10) is 30% complete (approximately 4579 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:34:00.87 spid18s Recovery of database 'Smeno_Comptage' (10) is 31% complete (approximately 4522 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:34:20.87 spid18s Recovery of database 'Smeno_Comptage' (10) is 31% complete (approximately 4421 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:34:34.07 spid18s Recovery of database 'Smeno_Comptage' (10) is 32% complete (approximately 4388 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:34:54.12 spid18s Recovery of database 'Smeno_Comptage' (10) is 32% complete (approximately 4360 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:35:14.12 spid18s Recovery of database 'Smeno_Comptage' (10) is 32% complete (approximately 4343 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:35:34.39 spid18s Recovery of database 'Smeno_Comptage' (10) is 32% complete (approximately 4327 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:35:40.53 spid18s Recovery of database 'Smeno_Comptage' (10) is 33% complete (approximately 4322 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:36:00.62 spid18s Recovery of database 'Smeno_Comptage' (10) is 33% complete (approximately 4309 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:36:20.95 spid18s Recovery of database 'Smeno_Comptage' (10) is 33% complete (approximately 4298 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:36:41.12 spid18s Recovery of database 'Smeno_Comptage' (10) is 33% complete (approximately 4291 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:36:56.96 spid18s Recovery of database 'Smeno_Comptage' (10) is 34% complete (approximately 4285 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:37:17.07 spid18s Recovery of database 'Smeno_Comptage' (10) is 34% complete (approximately 4280 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:37:37.09 spid18s Recovery of database 'Smeno_Comptage' (10) is 34% complete (approximately 4275 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:37:57.25 spid18s Recovery of database 'Smeno_Comptage' (10) is 34% complete (approximately 4266 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:38:17.34 spid18s Recovery of database 'Smeno_Comptage' (10) is 34% complete (approximately 4259 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:38:29.78 spid18s Recovery of database 'Smeno_Comptage' (10) is 35% complete (approximately 4254 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:38:49.84 spid18s Recovery of database 'Smeno_Comptage' (10) is 35% complete (approximately 4248 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:39:09.90 spid18s Recovery of database 'Smeno_Comptage' (10) is 35% complete (approximately 4241 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:39:30.21 spid18s Recovery of database 'Smeno_Comptage' (10) is 35% complete (approximately 4235 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:39:48.29 spid18s Recovery of database 'Smeno_Comptage' (10) is 36% complete (approximately 4229 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:40:08.54 spid18s Recovery of database 'Smeno_Comptage' (10) is 36% complete (approximately 4223 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:40:28.56 spid18s Recovery of database 'Smeno_Comptage' (10) is 36% complete (approximately 4214 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:40:48.68 spid18s Recovery of database 'Smeno_Comptage' (10) is 36% complete (approximately 4206 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:41:08.90 spid18s Recovery of database 'Smeno_Comptage' (10) is 36% complete (approximately 4200 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:41:24.29 spid18s Recovery of database 'Smeno_Comptage' (10) is 37% complete (approximately 4195 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:41:44.43 spid18s Recovery of database 'Smeno_Comptage' (10) is 37% complete (approximately 4189 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:42:04.56 spid18s Recovery of database 'Smeno_Comptage' (10) is 37% complete (approximately 4185 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:42:24.64 spid18s Recovery of database 'Smeno_Comptage' (10) is 37% complete (approximately 4180 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:42:44.75 spid18s Recovery of database 'Smeno_Comptage' (10) is 37% complete (approximately 4175 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:43:07.87 spid18s Recovery of database 'Smeno_Comptage' (10) is 38% complete (approximately 4171 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:43:37.03 spid18s Recovery of database 'Smeno_Comptage' (10) is 38% complete (approximately 4166 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:44:03.12 spid18s Recovery of database 'Smeno_Comptage' (10) is 38% complete (approximately 4162 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:44:36.54 spid18s Recovery of database 'Smeno_Comptage' (10) is 39% complete (approximately 4157 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:45:08.56 spid18s Recovery of database 'Smeno_Comptage' (10) is 39% complete (approximately 4153 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:45:38.23 spid18s Recovery of database 'Smeno_Comptage' (10) is 39% complete (approximately 4148 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:46:10.32 spid18s Recovery of database 'Smeno_Comptage' (10) is 39% complete (approximately 4144 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:46:44.50 spid18s Recovery of database 'Smeno_Comptage' (10) is 40% complete (approximately 4139 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:47:06.73 spid18s Recovery of database 'Smeno_Comptage' (10) is 40% complete (approximately 4135 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:47:27.34 spid18s Recovery of database 'Smeno_Comptage' (10) is 40% complete (approximately 4130 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:47:52.12 spid18s Recovery of database 'Smeno_Comptage' (10) is 40% complete (approximately 4125 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:48:14.70 spid18s Recovery of database 'Smeno_Comptage' (10) is 41% complete (approximately 4120 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:48:35.07 spid18s Recovery of database 'Smeno_Comptage' (10) is 41% complete (approximately 4114 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:48:56.07 spid18s Recovery of database 'Smeno_Comptage' (10) is 41% complete (approximately 4110 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:49:16.14 spid18s Recovery of database 'Smeno_Comptage' (10) is 41% complete (approximately 4105 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:49:45.76 spid18s Recovery of database 'Smeno_Comptage' (10) is 42% complete (approximately 4100 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:50:47.51 spid18s Recovery of database 'Smeno_Comptage' (10) is 42% complete (approximately 4095 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:51:56.17 spid18s Recovery of database 'Smeno_Comptage' (10) is 42% complete (approximately 4093 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2010-12-13 17:52:03.92 spid18s Recovery of database 'Smeno_Comptage' (10) is 42% complete (approximately 4093 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 17:52:21.34 spid18s Recovery of database 'Smeno_Comptage' (10) is 17% complete (approximately 14247 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 17:52:41.39 spid18s Recovery of database 'Smeno_Comptage' (10) is 17% complete (approximately 14327 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 17:53:01.39 spid18s Recovery of database 'Smeno_Comptage' (10) is 17% complete (approximately 14323 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 17:53:05.42 spid18s Recovery of database 'Smeno_Comptage' (10) is 18% complete (approximately 14104 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 17:53:25.42 spid18s Recovery of database 'Smeno_Comptage' (10) is 18% complete (approximately 13702 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 17:53:45.43 spid18s Recovery of database 'Smeno_Comptage' (10) is 18% complete (approximately 13918 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 17:54:05.43 spid18s Recovery of database 'Smeno_Comptage' (10) is 18% complete (approximately 13662 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 17:54:13.15 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 13502 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 17:54:33.15 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 13302 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 17:54:53.20 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 13253 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 17:55:13.20 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 13321 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 17:55:33.21 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 13391 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 17:55:53.21 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 13326 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 17:56:13.21 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 13396 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 17:56:33.25 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 13437 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 17:56:53.45 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 13556 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 17:57:13.71 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 13662 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 17:57:33.75 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 13738 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 17:57:53.90 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 13831 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 17:58:13.90 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 13811 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 17:58:33.90 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 13759 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 17:58:38.68 spid18s Recovery of database 'Smeno_Comptage' (10) is 20% complete (approximately 13738 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 17:58:58.73 spid18s Recovery of database 'Smeno_Comptage' (10) is 20% complete (approximately 13717 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 17:59:18.78 spid18s Recovery of database 'Smeno_Comptage' (10) is 20% complete (approximately 13730 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 17:59:39.09 spid18s Recovery of database 'Smeno_Comptage' (10) is 20% complete (approximately 13825 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 17:59:59.40 spid18s Recovery of database 'Smeno_Comptage' (10) is 20% complete (approximately 13973 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:00:09.45 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 14117 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:00:29.46 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 14202 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:00:36.26 spid18s Recovery of database 'Smeno_Comptage' (10) is 20% complete (approximately 14213 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:00:41.98 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 14243 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:01:02.26 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 14384 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:01:22.37 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 14510 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:01:42.37 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 14583 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:02:02.39 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 14620 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:02:22.84 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 14771 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:02:42.89 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 14907 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:03:02.89 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 15066 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:03:22.95 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 15208 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:03:43.03 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 15418 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:04:03.07 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 15462 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:04:23.14 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 15571 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:04:43.14 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 15594 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:05:03.42 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 15661 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:05:23.79 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 15773 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:05:43.79 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 15866 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:06:03.82 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 15961 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:06:23.82 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 16010 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:06:43.84 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 16082 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:07:03.84 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 16157 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:07:23.84 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 16256 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:07:43.92 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 16309 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:08:04.03 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 16338 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:08:24.12 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 16416 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:08:44.12 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 16445 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:09:04.21 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 16524 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:09:24.26 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 16530 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:09:44.43 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 16534 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:10:04.48 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 16614 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:10:24.62 spid18s Recovery of database 'Smeno_Comptage' (10) is 19% complete (approximately 16620 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:10:35.56 spid18s Recovery of database 'Smeno_Comptage' (10) is 20% complete (approximately 16610 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:10:55.56 spid18s Recovery of database 'Smeno_Comptage' (10) is 20% complete (approximately 16667 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:11:15.71 spid18s Recovery of database 'Smeno_Comptage' (10) is 20% complete (approximately 16672 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:11:35.79 spid18s Recovery of database 'Smeno_Comptage' (10) is 20% complete (approximately 16679 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:11:56.00 spid18s Recovery of database 'Smeno_Comptage' (10) is 20% complete (approximately 16710 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:12:16.20 spid18s Recovery of database 'Smeno_Comptage' (10) is 20% complete (approximately 16743 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:12:36.21 spid18s Recovery of database 'Smeno_Comptage' (10) is 20% complete (approximately 16828 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:12:56.37 spid18s Recovery of database 'Smeno_Comptage' (10) is 20% complete (approximately 16862 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:12:57.03 spid18s Recovery of database 'Smeno_Comptage' (10) is 100% complete (approximately 0 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2010-12-13 18:12:57.04 spid18s 1 transactions rolled back in database 'Smeno_Comptage' (10). This is an informational message only. No user action is required.
2010-12-13 18:12:57.04 spid18s Recovery is writing a checkpoint in database 'Smeno_Comptage' (10). This is an informational message only. No user action is required.
2010-12-13 18:20:55.78 spid5s Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) has completed. This is an informational message only. No user action is required.
2010-12-13 18:20:55.78 spid5s Recovery is complete. This is an informational message only. No user action is required.
2010-12-14 00:00:35.96 spid12s This instance of SQL Server has been using a process ID of 4104 since 13/12/2010 18:20:55 (local) 13/12/2010 17:20:55 (UTC). This is an informational message only; no user action is required.
2010-12-15 00:00:08.02 spid16s This instance of SQL Server has been using a process ID of 4104 since 13/12/2010 18:20:55 (local) 13/12/2010 17:20:55 (UTC). This is an informational message only; no user action is required.
2010-12-15 08:34:33.88 spid66 Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.
2010-12-15 08:34:35.01 spid66 Configuration option 'Agent XPs' changed from 1 to 1. Run the RECONFIGURE statement to install.
2010-12-15 08:34:55.24 spid67 Using 'xpsqlbot.dll' version '2005.90.1399' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
2010-12-15 08:34:55.57 spid67 Using 'xplog70.dll' version '2005.90.1399' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
2010-12-15 14:32:36.90 spid2s SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\CMSMENO_log.ldf] in database [CMSMENO] (9). The OS file handle is 0x000007C4. The offset of the latest long I/O is: 0x000000809f1600
2010-12-15 14:39:19.88 spid66 DBCC CHECKDB (Smeno_Comptage) executed by INTRA\Administrateur found 0 errors and repaired 0 errors. Elapsed time: 0 hours 18 minutes 38 seconds.
2010-12-15 14:47:16.49 spid67 DBCC CHECKTABLE (Smeno_Comptage.dbo.S1) executed by INTRA\Administrateur found 0 errors and repaired 0 errors. Elapsed time: 0 hours 0 minutes 6 seconds.
15/12/2010, 15h32
mikedavem

Citation:

SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\CMSMENO_log.ldf] in database [CMSMENO] (9).

Je pense que votre souci vient de la .... du moins de votre sous systeme disque qui heberge vos journaux de transaction. Avez vous regarde de ce cote ? Est ce du RAID, du SAN ?

++
16/12/2010, 09h35
yaloum59

1 pièce(s) jointe(s)

C'est du SAN, avec 2 ESX
[IMG]C:\Documents and Settings\maahid\Mes documents\Mes images\wm_esx.jpg[/IMG]

Quand vous parlez de "sous systeme disque qui heberge vos journaux de transaction", comment peut-on y acceder
Je sais que c'est du linux qui est dérriere....
16/12/2010, 10h38
mikedavem

Pour dejà eu avoir quelques problèmes avec un SAN, il faudrait demander de l'admin SAN qui pourra faire les diagnostics nécessaires pour voir si le sous système disque (donc ici une LUN) n'est pas en cause.

Pour ma part je peux dire qu'il faudra faire une vérification des disques jusqu'à la carte HBA si nécessaire ... J'ai dejà vu des pb IO dû à un problème sur la fibre optique elle même entre la carte HBA et le stockage ....

En tout cas vous pouvez regarder dans le journal d'événement si vous n'avez pas d'autres erreurs concernant des problèmes avec les disques.

++
16/12/2010, 14h01
yaloum59

Je tiens à vous remercier pour tous ce que vous avez pu nous apporter comme réponses à notre problématique.
Je vais rendre compte à notre SSII, qui nous a implémenter la solution.

Merci encore à tous
16/12/2010, 14h59
mikedavem

Tenez nous au courant histoire de savoir ce que vous avez fait.

++
16/12/2010, 16h00
yaloum59

OK
Je n'y manquerai pas