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 |
|
sunilj20
Starting Member
1 Post |
 Posted - 2004-06-18 : 02:47:45
|
| Dear All,I am trying to restore a database backup file. The machine is Win 2000 Server, with SQL server 2000 installed.When i restore the database, i get the following error :"[ms sql dmo] [odbc] sql state: 42000 modify file encountered os error 112 (not enough space on the disk) while attempting the physical file could not adjust the page allocation for file 'totaldb_data' restoring db abnormally."I have ample space about 11 GB on both the drives, the data folder for the database is in D:\ which has space in it. I have also truncated the log files. The the actual database, is not more than 700KB to 750KB as the auto shrink option is set 'True'.still the restore results in this error.Please let me know, what could be causing the error.Thanx in advanceRegardsSunil J |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-18 : 12:35:46
|
| So which drive are you restoring it onto? You need to know what the source paths are, since you probably aren't using the WITH MOVE option. It is probably trying to restore it to a different drive that doesn't have sufficient free disk space. To see what it is using, do a RESTORE FILELISTONLY in Query Analyzer. You can change the paths with the RESTORE command using WITH MOVE.Tara |
 |
|
|
|
|
|
sql state: 42000 modify file encountered os error