SQL Server Performance Forum – Threads Archive

Database backup size

I backup my databases everyday. For one of the database, the backup file size increased from 15MB to 50MB in one day. When I looked at the data itself, there is not a big increase in the amount of data. Will there be something wrong with my database?

What about the transaction log?.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Have you set SQL backup job to append backup in previous backup file..? Also you need to look on transaction log size.. if you have database in full recovery and not setup transaction log backup job..then TL size will keep on increasing.
Deepak Kumar –An eye for an eye and everyone shall be blind

the other thing taken care if you have schedule re index / reorganize INDEXs , it will increase the size of Transaction log file and will added to your back up file next day. Regards. hsGoswami
[email protected]

You should know about the data growth and if you’ve not seen any errors/issues noted from SQL server error log or event viewer log then assume nothing wrong with the database.
For a test you can run a server side trace to know the flow of database access. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>