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 |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2008-02-18 : 13:35:48
|
| my backups are huge.. my database is hugeis there anyway of saving each month and incremental backup - like only that months info and changes and not all the previous months?what do you normally do when the backup gets real large? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-18 : 13:48:24
|
| Use third party tools like SQL Litespeed which will compress the backup by 70-75% and you don't need much space. |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-02-18 : 14:18:27
|
| Save the old backups onto tape, and only keep recent backups on disk.CODO ERGO SUM |
|
|
|
CShaw
Yak Posting Veteran
65 Posts |
Posted - 2008-02-18 : 20:11:29
|
| LiteSpeed is a great tool, as well as SQL Backup by Red Gate and the idera tool as well. If your database is that large I would recommend getting some disk as well as tape. Some of the things that you may want to look at is who is responsible for the tape backups, and when they take them off-site if they do.If you back up your monthly to tape but it's taking off-site after a week, then you may have some time issues that you may have to contend with.Chris Shawwww.SQLonCall.com |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2008-02-20 : 09:07:31
|
| the issue is the the backup of today includes the backup of a month ago as i'm mainly adding data and not deleting - so it only gets bigger - anyway to backup only the new data? |
|
|
|
CShaw
Yak Posting Veteran
65 Posts |
Posted - 2008-02-21 : 01:12:31
|
| You can do a Diff. The Question is how long between Fulls do you want to go. Check out the Backup Database in Books on line.If I understand you correctly this is what you are saying.Monday Database is 100 Megs. Backup 90 megsTues Database is 110 Megs. Backup is 95 megs.You are asking if the Monday Backup as the 90 megs why back it up again when only 10 megs of data were added to the database. (Just an example).If this is correct I would look up The Diff Backup.Chris Shawwww.SQLonCall.com |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-21 : 15:29:03
|
| Backup db with maintenance plan, it can create new file for each backup. |
|
|
|
rajeshk
Starting Member
15 Posts |
Posted - 2008-02-23 : 03:20:10
|
| If you are only adding data and don't do any modification with the existing data why do you keep different backups. Overwrite the existing backup set with the new one. May be this can help you.. Differential backup is also a good option provided that you have to take a little pain during restoraion, if your full backup is not done at regular intervals. |
|
|
|
|
|
|
saving backups