Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Restoring a DB from a Backup causes server to freeze
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Copies de sauvegarde
Versions des environnements
SQL Server:
SQL Server 2005
Application:
Web
Divers
Thread ID:
01410428
Message ID:
01411560
Vues:
32
>Ric,
>
>Thanks for the suggestion butI am still having the problem after running chkdsk. I thought maybe the problem was due to space constraints so I truncated some tables with unnecessary data, shrunk the data and log files, etc. to no avail.
>
>
>
>>>I cannot remote login to the server once it freezes as the server does not respond to outside requests or internal ones. I have not tried pinging it after it freezes but I would not expect this to return a reply.
>>>
>>>>Have you tried to remote login into the frozen server (using RDP)? Does it respond to pings?
>>
>>Uhmm, a long shot, but I would run a chkdsk command with the /f switch on on the system drive.... Sometime that has unstuck similar situations for me. Apparently there might be a currupted but hopefully recoverable file.

Bob,
Can't say. I think it is an issue with the different SQL versions and OS.... Is this the only database in the Express edition?
-R!
Ricardo A. Parodi
eSolar, Inc.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform