Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Restoring a DB from a Backup causes server to freeze
Message
General information
Forum:
Microsoft SQL Server
Category:
Backups
Environment versions
SQL Server:
SQL Server 2005
Application:
Web
Miscellaneous
Thread ID:
01410428
Message ID:
01411560
Views:
33
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform