IdentifiantMot de passe
Loading...
Mot de passe oublié ?Je m'inscris ! (gratuit)
Navigation

Inscrivez-vous gratuitement
pour pouvoir participer, suivre les réponses en temps réel, voter pour les messages, poser vos propres questions et recevoir la newsletter

Administration SQL Server Discussion :

SQL SERVER 2005 BDD en recuperation


Sujet :

Administration SQL Server

Vue hybride

Message précédent Message précédent   Message suivant Message suivant
  1. #1
    Membre averti
    Inscrit en
    Septembre 2010
    Messages
    18
    Détails du profil
    Informations forums :
    Inscription : Septembre 2010
    Messages : 18
    Par défaut 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

  2. #2
    Rédacteur

    Avatar de SQLpro
    Homme Profil pro
    Expert bases de données / SQL / MS SQL Server / Postgresql
    Inscrit en
    Mai 2002
    Messages
    22 010
    Détails du profil
    Informations personnelles :
    Sexe : Homme
    Localisation : France, Var (Provence Alpes Côte d'Azur)

    Informations professionnelles :
    Activité : Expert bases de données / SQL / MS SQL Server / Postgresql
    Secteur : Conseil

    Informations forums :
    Inscription : Mai 2002
    Messages : 22 010
    Billets dans le blog
    6
    Par défaut
    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 +
    Frédéric Brouard - SQLpro - ARCHITECTE DE DONNÉES - expert SGBDR et langage SQL
    Le site sur les SGBD relationnels et le langage SQL: http://sqlpro.developpez.com/
    Blog SQL, SQL Server, SGBDR : http://blog.developpez.com/sqlpro
    Expert Microsoft SQL Server - M.V.P. (Most valuable Professional) MS Corp.
    Entreprise SQL SPOT : modélisation, conseils, audit, optimisation, formation...
    * * * * * Expertise SQL Server : http://mssqlserver.fr/ * * * * *

  3. #3
    Membre averti
    Inscrit en
    Septembre 2010
    Messages
    18
    Détails du profil
    Informations forums :
    Inscription : Septembre 2010
    Messages : 18
    Par défaut
    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

  4. #4
    Membre averti
    Inscrit en
    Septembre 2010
    Messages
    18
    Détails du profil
    Informations forums :
    Inscription : Septembre 2010
    Messages : 18
    Par défaut piece jointe
    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.

  5. #5
    Rédacteur

    Avatar de SQLpro
    Homme Profil pro
    Expert bases de données / SQL / MS SQL Server / Postgresql
    Inscrit en
    Mai 2002
    Messages
    22 010
    Détails du profil
    Informations personnelles :
    Sexe : Homme
    Localisation : France, Var (Provence Alpes Côte d'Azur)

    Informations professionnelles :
    Activité : Expert bases de données / SQL / MS SQL Server / Postgresql
    Secteur : Conseil

    Informations forums :
    Inscription : Mai 2002
    Messages : 22 010
    Billets dans le blog
    6
    Par défaut
    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 +
    Frédéric Brouard - SQLpro - ARCHITECTE DE DONNÉES - expert SGBDR et langage SQL
    Le site sur les SGBD relationnels et le langage SQL: http://sqlpro.developpez.com/
    Blog SQL, SQL Server, SGBDR : http://blog.developpez.com/sqlpro
    Expert Microsoft SQL Server - M.V.P. (Most valuable Professional) MS Corp.
    Entreprise SQL SPOT : modélisation, conseils, audit, optimisation, formation...
    * * * * * Expertise SQL Server : http://mssqlserver.fr/ * * * * *

  6. #6
    Expert confirmé
    Avatar de mikedavem
    Homme Profil pro
    Administrateur de base de données
    Inscrit en
    Août 2005
    Messages
    5 450
    Détails du profil
    Informations personnelles :
    Sexe : Homme
    Âge : 46
    Localisation : France, Ain (Rhône Alpes)

    Informations professionnelles :
    Activité : Administrateur de base de données
    Secteur : Distribution

    Informations forums :
    Inscription : Août 2005
    Messages : 5 450
    Par défaut
    Bonjour,

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

    ++

Discussions similaires

  1. [SQL server 2005]importer une BDD de Mysql vers SQL server
    Par Fadaflux dans le forum MS SQL Server
    Réponses: 9
    Dernier message: 28/06/2007, 11h56
  2. Faire appel à une BDD sql server 2005 express
    Par mrjay42 dans le forum Services Web
    Réponses: 2
    Dernier message: 04/02/2007, 15h53
  3. Réponses: 1
    Dernier message: 09/09/2006, 21h52
  4. PB Accès schémas BDD dans sql server 2005
    Par tikam dans le forum MS SQL Server
    Réponses: 10
    Dernier message: 16/06/2006, 08h42
  5. [VB.NET 2005][SQL SERVER 2005] Pb d'insertion en BdD
    Par jhary07 dans le forum Windows Forms
    Réponses: 5
    Dernier message: 02/01/2006, 08h53

Partager

Partager
  • Envoyer la discussion sur Viadeo
  • Envoyer la discussion sur Twitter
  • Envoyer la discussion sur Google
  • Envoyer la discussion sur Facebook
  • Envoyer la discussion sur Digg
  • Envoyer la discussion sur Delicious
  • Envoyer la discussion sur MySpace
  • Envoyer la discussion sur Yahoo