April 19, 2012 at 9:01 am
Hello -
Everytime I try and restore a database that is over 40GB if get the following error message.
Msg 3271, Level 16, State 1, Line 2
A nonrecoverable I/O error occurred on file "???:" 170(The requested resource is in use.).
Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.
This is on SQL 2005 SP2 on a Windows 2003 Server Enterprise x64 SP2 VM
Can someone please advise???
Regards,
David
April 20, 2012 at 7:57 am
Lets start with the basics... is there enough space to accomodate the restore?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.April 20, 2012 at 8:11 am
Assuming there's enough space, is there an anti-virus on the machine? If so, does it have the correct exclusions for all SQL files? (mdf, ldf, ndf, bak, trn)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply