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 |
|
astoriavega
Starting Member
2 Posts |
 Posted - 2008-10-22 : 21:12:22
|
| the error sounds like this : Error 112(could not adjust the space allocating for bkp_accounting_log )i've try to change recovery model from full to simple, and after that i've shrink it, and when i'm check the log file size it's become 1 mb. but i still cannot restore database and still error 112.My server space :1. c:\ free space 6.63GB (NTFS)2. d:\ free space 22GB (NTFS)3. e:\ free space 70GB (NTFS)This my data :1.Size database 1947.81MB , space available = 942.92MB2.bkp_accounting_data = 985 MB3.bkp_accounting_log = 964 MB4.Databases automatically growth by percent (10%)before i restore a database :1.First i change/edit the path dataD:\SQL\Backup\Accounting ------> D:\DEV\BCK_SQL\200809\Accountingdatabase that i want to restore have a 0.97GB size.thanx for help.-astoriavegaforastoriavirgita- |
|
|
SimpleSQL
Yak Posting Veteran
85 Posts |
Posted - 2008-10-23 : 03:07:36
|
| I am not sure which file you did you shrink. Restore database will create database and log file of the same size as the database (at the time of backup) where the backup was taen from. It does not matter what is the size of the data and log file of the database you are restoring on top of.Hope this makes sense. |
 |
|
|
astoriavega
Starting Member
2 Posts |
Posted - 2008-10-23 : 05:14:21
|
quote:
Originally posted by SimpleSQL
I am not sure which file you did you shrink. Restore database will create database and log file of the same size as the database (at the time of backup) where the backup was taen from. It does not matter what is the size of the data and log file of the database you are restoring on top of.Hope this makes sense.
thanx for your information.my database..yes i know it'll create new data and log file as same as the database at time of backup. but from other forum they suggest me to try to shrink my database.i'm newbie in touch sql server. can any1 help me?,,,-astoriavegaforastoriavirgita- |
|
|
|
brianjensen
Starting Member
22 Posts |
Posted - 2008-12-09 : 09:26:07
|
| Well you'll have to shrink it before you back it up if you want to minimize the space used when restoring :)I don't think there is any way to solve it without doing the complete restore first. I think you will need to find a way to free up some space on your system first. |
|
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-12-10 : 11:18:05
|
| It may be limitations on the size of the file(s) that you are allowed to create on the drive, not necessarily disk space limitations. Check out the following:http://support.microsoft.com/kb/326678Terry |
|
|
|
|
|
|
Error While Restoring Database