June 22, 2007 at 11:51 pm
Hi,
I take everyday Full and differential online database Backup file on sql server 2000 sp3. I saw the size of one database backup file is not increasing from last kindly suggest my whats the reason behind it your suggestion would be appereciated.
regards
Syed Abu Amir
June 24, 2007 at 7:14 am
You mean that the full backup file is smaller than the previous day from time to time?
One likely cause is that you have less data than the previous day or that you are somehow using less datapages than the previous days (db reindex can do this).
June 24, 2007 at 11:01 pm
The full backup will be backup of all the pages in the database and it need not be necessarily as the same size of the database it may be slightly smaller than size of the database.
Differential backup consists of pages that have changed after the full backup. and will be smaller in size than the full backup. If you say that its of same size then yor changes to database are similar and not too many changes.
You can read about Differential Change Map and Bulk Change Map in BOL to know more about how backups work.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
June 26, 2007 at 12:26 am
Dear Sugesh,
Let me know what i will do after the DBRINDEX Production full database Backup File size increase but after 2 days size is not increasing.its urgent.
Regards
Syed Abu Amir
June 26, 2007 at 3:23 am
Syed, You mean to say that you do a reindex and then backup the file and the size increases after that i does not. OK can you check if the backup that you have has been backing up corretly by doing a mock restoration and checking for changes.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
June 26, 2007 at 4:29 am
Yes I am taking Backup correctly please suggest me what i will do.
Regards
Syed Abu Amir
June 26, 2007 at 4:47 am
Did you do a mock restoartion and check if the backup file is correct. If so why do you worry about the size of the database backup file.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
June 27, 2007 at 2:27 am
Dear Sugesh,
Very very thanks for advice. I am new in DBA kindly advice me what i will do for become a Dynamic DBA. I am waiting for your reply as soon as possible with SQL Server 2000 Topics.
Regards
Syed Abu amir
June 29, 2007 at 6:32 am
Syed,
Your backup size will not increase if the overall data remains more or less the same. Can you throw some light on your backups, their sizes, schedules of full and diffs?
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply