February 12, 2008 at 10:33 am
Anyone come across this?
I backed up a 3gb database on Server 1. Zipped up. Transferred to Server 2 (a virtual server). Unzipped. When trying to restore it says "You need 180gb of space but you only have 19gb".
What gives? This is through the GUI, I will try again through the Restore command.
Cheers
February 12, 2008 at 10:47 am
You need the same space volume as the original MDF, ndf and LDF files !
If they were allocated e.g. mdf 50Gb and ldf 10G , even if you only have 10 mb in them, you must have the originals space (50Gb + 10 Gb) available for the restore.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 12, 2008 at 12:22 pm
Shark Energy (2/12/2008)
Anyone come across this?I backed up a 3gb database on Server 1. Zipped up. Transferred to Server 2 (a virtual server). Unzipped. When trying to restore it says "You need 180gb of space but you only have 19gb".
What gives? This is through the GUI, I will try again through the Restore command.
Cheers
When you stated a 3 gb database, did you mean the size of the backup file? If so, it is not surprising. You may need to backup/truncate the log file before having the full backup of this database.
February 12, 2008 at 4:05 pm
The database files are currently only 6gb including MDF and LDF. Do you mean they were ORIGINALLY set up as xgb? That's new to me! They have been shrunk down from whatever they were originally.
February 12, 2008 at 8:32 pm
If the total space of data and log files is 6 GB, I cannot see any reason why the size of the restored database is 180 GB.
February 13, 2008 at 3:39 am
can you post the results of :
restore filelistonly
FROM DISK = 'yourbackuppath and file'
?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 13, 2008 at 6:08 am
Ok folks nothing to see here. Move along....
(I'm a fool)
Basically I misread the sizes. I'm a fool! Ignore me and this. I'm not normally an idiot.
February 13, 2008 at 6:28 am
Shark,
Don't feel bad. I'm sure most of us have done something similar. Just be happy that it wasn't really a 180GB database you're looking for space for now!
February 13, 2008 at 6:31 am
join the club :w00t::alien:
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 13, 2008 at 3:00 pm
Shark Energy (2/13/2008)
Ok folks nothing to see here. Move along....(I'm a fool)
Basically I misread the sizes. I'm a fool! Ignore me and this. I'm not normally an idiot.
It happens sometimes. We just overlook things. Once my manager told me to restore a database from production on another server and I bluntly told him its not possible as prod. database files resides on G:\ and H:\ drives and on new server we don't have these drives. It had C:, D:, E: and F: only.
This was more than nine years back on SQL version 7, when I started doing DBA stuff and I still laugh at my self remembering this event. :w00t:;)
SQL DBA.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply