| Author |
Topic |
|
jayaravichandran
Starting Member
5 Posts |
 Posted - 2008-02-06 : 07:11:51
|
| While restoring database the following error is displayed.Modify file encountered operating system error 112(there is not enough space on the disk) while attempting to expand the physical file. Could not adjust the space allocation for file 'xyz_LOG'. restore database is terminating abnormally.In connection with this, I gone through the the FAQ. There it has mentioned that to take backup again after shrinking the log file and etc. But here after taking the backup of the said database, the database was deleted. Kindly give solution. |
|
|
SusanthaB
Starting Member
14 Posts |
Posted - 2008-02-06 : 07:41:19
|
| It seems you have ran out of hard disk space of your server. Now the database also deleted. Am I right?If that is the case, since you have the latest backup, still you have a chance to recover your database. If the hard disk space is not enough your current server to restore this backup, you can use a different machine, even your local one to restore the database. After restoring your database, you should shrink the database and take a full backup again. Now your full backup should be very much less than the previous one and now it should be able to restore into original location.If that did not work, after restoring it to your local machine, take a log backup of the database with TRANCATE option. Then take a full backup and restore it in original location.Either of above two methods should work for you. |
 |
|
|
jayaravichandran
Starting Member
5 Posts |
Posted - 2008-02-07 : 00:24:57
|
| The space available in the HDD is more than 10 GB. And also I checked in the other machine, the same error 112 is coming. Kindly cause solution. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-07 : 00:27:05
|
| Use can use 'restore filelistonly' to find out how much space needed. |
|
|
|
jayaravichandran
Starting Member
5 Posts |
Posted - 2008-02-07 : 00:52:02
|
| I cant understand 'restore filelistonly' Kindly explain about it. The size of the backup db is 800 MB. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-02-07 : 00:55:02
|
quote:
Originally posted by jayaravichandran
But here after taking the backup of the said database, the database was deleted. Kindly give solution.
SQL Server didn't delete the database after a backup was performed. You must have dropped the database accidentally. There is no magic here.What are the sizes of the original MDF and LDF files?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-07 : 00:56:20
|
| It lists source db's data file, log file and their size. That's disk space you need on target server, books online has details. |
|
|
|
jayaravichandran
Starting Member
5 Posts |
Posted - 2008-02-07 : 02:43:23
|
| I don't remember the sizes of the original MDF and LDF files.However, the size of the new MDF and LDF files are 100 and 50 MB respectively. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-02-07 : 12:31:51
|
| The size of the new files doesn't help you with this problem. You have to have enough free disk space for the original MDF and LDF files as that is what will get restored. Run RESTORE FILELISTONLY to get the information as rmiao mentioned.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
jayaravichandran
Starting Member
5 Posts |
Posted - 2008-02-08 : 01:09:47
|
| How to run RESTORE FILELISTONLY. Kindly guide me |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-08 : 01:37:41
|
| RESTORE FILELISTONLY from disk = 'your db backup file'Books online has details. |
|
|
|
|
error 112