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 |
|
mikenason
Starting Member
13 Posts |
 Posted - 2005-03-30 : 16:47:18
|
| I am doing a Differential backup at 5:15pm and a full backup at 6:00pm and a Transaction log backup at 7:00pm with the intent that the 5:15 Diff backup will contain all activity that occured since the 6:00pm backup the previous day.The backups are working correctly but the size of the Differential file is roughly 8meg, about 1/3 the size of the Full backup wich is 26meg. This seems way large given the very little activity we have in the database. The Transaction log backup is less then 2meg in size. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-03-30 : 18:41:14
|
| That's a very odd thing to do - the diff doesn't give you much and why backup the tr log just once.The diff will include all the parts of the database that have changed - just looked to see what the usit is but I guess it's extents.The tr log will just include data updates.If you have statistics recalculated or or few updates distributed over many pages then that will give large diffs.Try 4 hourly diffs and hourly tr logs instead - that would be a more reasonable plan - but with that size database why bother with diffs.Oops - just noticed the size - the diffs are probably mostly housekeeping info and the tr log the min file size maybe.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
mikenason
Starting Member
13 Posts |
Posted - 2005-03-31 : 11:04:06
|
| Thanks NR..the stratagy makes perfect sense to me..:-) What I am rying to do is get the last 24 hours of changes in a small enough file that I can move over the internet to a remote location every night and keep the full backup locally off site on tape. As our database is only operational from 7:00am to 5:00pm daily this should allow me to restore the tape backup and then the differential backup and in effect get current. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-03-31 : 12:43:03
|
| Try taking a full backup and then zipping it. It should then be small enough to email off site.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Differential Vs Full backup - file size.