huge .BAK FILE - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

huge .BAK FILE

Author

Topic

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2008-01-28 : 09:26:03

I have a .bak file of 72gb. But my database size is only 32gb, I got this value from sp_spaceused?
Anyone know why the .bak file is so big?. Is it possible to reduce the size? How could i reduce it?

http://www.sqlserverstudy.com

X002548
Not Just a Number

15586 Posts

Posted - 2008-01-28 : 09:31:28

Understand that the volume of data does not equal the size of the backup

At some point the files grew...now the data has been reduced

Ask yourself why the data grew in the first place

Is this a common occurance or a one time thing (it never is)

You need to look at DBBC SHRINKFILE/SHRINKDB

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2008-01-28 : 09:46:39

Not sure why the file grew.
will the size reduce if i back it up again?

http://www.sqlserverstudy.com

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2008-01-28 : 10:50:59

X002548,
I just bakcup the database and the bak file size is 32gb now. I think you are wrong cause the database and .bak file size is almost the same now.

http://www.sqlserverstudy.com

blindman
Master Smack Fu Yak Hacker

2365 Posts

Posted - 2008-01-28 : 12:28:02

Perhaps you previous backup file contained two backups, one appended to the other.

e4 d5 xd5 Nf6

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-01-28 : 12:34:23

or you had some very large transactions running at the time of the backup...

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-01-28 : 19:57:11

Did you use 'with init' option when backup db?

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2008-01-29 : 00:14:55

Damn, the .bak files are huge again this morning.
what is going on?
anyone knows?

http://www.sqlserverstudy.com

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2008-01-29 : 02:16:44

You must have more than one backup in the set. List the file headers and you will see.