SQL Server Performance Forum – Threads Archive
Database backup sizeI 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?.
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
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
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
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.