January 29, 2007 at 2:53 am
Dear All,
I am facing problem of restoring a db of size 3.97GB. there is enough space in the drive around 8 GB but i am getting a message of not enough space.
Please Help me
January 30, 2007 at 5:29 am
Maybe the trans.log file (the original one) is to big?
January 30, 2007 at 7:25 am
If you post the exact error maybe we can help.
January 30, 2007 at 10:58 am
Run this and see what the file sizes are.
RESTORE FILELISTONLY
FROM DISK = 'backupFilePathAndName'
If the combined file size of all the files in the backup exceed the amount of free space, you won't be able to restore. Note that the size of the backup file is totally irrelevant here.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
February 20, 2007 at 1:10 pm
backup log file shrink log and do a backup your restore should work just
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply