Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Database in loading status

Status
Not open for further replies.

lory

MIS
Nov 20, 2001
35
US
I started to restore a database, something I've done hundreds of times, but in the middle of the restore I received an error that stated "ConnectionRead (recv()). General network error. Check your network documentation." The file I was restoring from was copied from a different server onto the same server as the SQL database performing the restore.

Anybody know how I can get the database accessible enough to delete or try to restore again? I've searched MS knowledgebase and came up with nothing.
 
I also checked the errorlog and I found "BackupFileDesc: VeryifyCreatability: Operating system error 32(The process cannot access the file because it is being used with another process.)during the creation/opening of physical device D:\HRSYS80A.MDF."
 
Nevermind this thread. After trying to delete the database it said that I couldn't, but when I got back from lunch it was gone. I think the Loading process took a very long time and it finally deleted.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top