February 9, 2005 at 7:55 am
hi there
here i am using sql 2000 , Service Pack is 4, i want to restore the database , size is 190MB. At least we need 4GB free space in the server . But i have only 3.5 GB. Then how i will restore. If there is any other possibility .i am new one to this sql server. please give me the points descriptive manner.
thanx in advance
yasin
February 9, 2005 at 11:24 am
If the database is only 190mb why do you need 4gb of free space on the server to do the restore?
Are you saying that there is only 190mb of data inside the database, but the file size allocation for the data and log files is 4gb?
Assuming this is not a disaster recovery situation, and the original db is still available, you need to shrink the data files and do another backup so that when you do the restore it will allocate smaller data and log files.
If you don't have the original database still online. I don't think you have an alternative except to make enough room for it. However, I could be wrong. Anyone know of a way to do this differently?
February 10, 2005 at 8:07 am
I'm just guessing, but try to create the database first, then restore on top of this existing database.
Francis
February 10, 2005 at 3:45 pm
Looks like you need to manage your trans log first, truncate the log and shrink it - then do the full db backup and then restore that backup.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply