February 13, 2012 at 12:47 pm
I have a database that I shrank. Looking in the properties of the database I see it has a size of 11.68 MB with space available of 1.13 MB. The file sizes add up to this pretty close to 13 MB. I then backed up the database and see the back up file has a size of 136,994 KB in Windows explorer. Seems like it should be around 13,312 KB. What am I missing here or what is going on?
February 13, 2012 at 12:56 pm
Did you backup to an existing backup set (so multiple backups in the same file)?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 13, 2012 at 2:35 pm
Not sure. I am showing my ignorance here but I ran the backup on the database. I assumed it would overwrite previous backups.
February 13, 2012 at 2:40 pm
Not unless you specified WITH INIT
Without that SQL will append backups to existing ones in the file.
Use RESTORE HEADERONLY to see what backups are within the file.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 13, 2012 at 2:43 pm
Thanks for that. Learned something. I was doing the backup from Management Studio.
February 15, 2012 at 9:23 pm
GilaMonster (2/13/2012)
Not unless you specified WITH INITWithout that SQL will append backups to existing ones in the file..
Gail I have a question. Why sqlsever default value is appending rather than a new backup media. Do we have advanatages on appending the backups to a single file.
---- Babu
February 16, 2012 at 1:48 am
It's just the default. No real advantage for files.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply