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.
| Author |
Topic |
|
iminore
Posting Yak Master
141 Posts |
 Posted - 2009-01-17 : 04:54:09
|
| I do a nightly backup on a SQL 2005 database. For the last seven nights the size of the backup file has remained exactly the same even though new data is going in the database (though admittedly not lots and there could be deletions). The size is 349,832,704 bytes.I've restored last nights backup to a different database and checked a few tables. Recent additions are there. Is it coincidence? Should I drink more beer?My word is my code. |
|
|
cshah1
Constraint Violating Yak Guru
347 Posts |
Posted - 2009-01-17 : 08:27:32
|
| Run DBCC checkDB and if there are no errors. You should be fine. |
 |
|
|
iminore
Posting Yak Master
141 Posts |
Posted - 2009-01-17 : 10:43:57
|
| Ran that and no errors. Thanks for the suggestion.My word is my code. |
|
|
|
|
|
|
Backup size