April 7, 2008 at 3:43 am
i have seent that sometimes the database size will be say XGB....but the backup will be much smaller comapred to the d/b size.
eg d/b size = 65 gb...full d/b backup size = 34 gb
sql server 2000
windows 2003 server
backup is tkaen using the maintnance plan on the disk
...what happens when we take a backup does it compress the file or something? thanks for the help.
April 7, 2008 at 4:04 am
How much of the database size is actually taken up with data? The database size could be 100 GB but maybe only 50 GB of that is used, in which case the backup size will be closer to 50 GB.
Typically, I have found my backup sizes to be roughly the same as the used database size.
April 7, 2008 at 4:13 am
You could have lots of free space in the database files. Think of them like a hard disk partition - you have a 50GB drive C with 20GB of files on it leaving 30GB as free space. If you back up your drive you want a 20GB backup file not a 50GB one. Same with SQL (although I'm making some assumptions about your case).
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply