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 |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2007-05-29 : 04:30:32
|
| A mainitenance plan is setup to create a daily backup od a database.It is set to overwrite.Backup type is set to full.Not sure why the size of the backup increases every day.Could this be to do with full/differential backup?Thanks |
|
|
Kristen
Test
22859 Posts |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2007-05-29 : 05:10:25
|
| Recovery model is set to simple |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-05-29 : 05:42:21
|
| How much is it increasing each day?Are you adding much data? Deleting much?Maybe the data is being added & deleted such that the indexes are getting fragmented. Reindex might solve that ...Kristen |
|
|
|
|
|
|
backup