Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ostinoh
Yak Posting Veteran
66 Posts |
 Posted - 2012-04-19 : 11:02:19
|
| 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 2A nonrecoverable I/O error occurred on file "???:" 170(The requested resource is in use.).Msg 3013, Level 16, State 1, Line 2RESTORE DATABASE is terminating abnormally.This is on SQL 2005 SP2 on a Windows 2003 Server Enterprise x64 SP2 VMCan someone please advise???Regards,David |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-04-19 : 12:18:32
|
| VM is trying to dynamically move files? Make sure that's disabled.Do you have enough room to restore the database? |
 |
|
|
ostinoh
Yak Posting Veteran
66 Posts |
Posted - 2012-04-19 : 12:43:24
|
| I confirmed with our VM admin that it was disabled and it was. I have 80GB free to restore too. I am at such a lost on why this is happening.Thanks |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-04-20 : 11:25:15
|
| Run RESTORE FILELISTONLY and look at the size column. Make sure there's enough disk space. A 40GB backup doesn't mean 40GB database. |
|
|
|
boybawang
Starting Member
15 Posts |
Posted - 2012-04-25 : 22:43:21
|
| Basically that's the scene every time you restore the database. The capacity of the database stands on 40GB input and it can be solved when you comply more information to experts. |
|
|
|
|
|
|
Error Restoring database larger then 40 GB