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 |
|
rudba
Constraint Violating Yak Guru
415 Posts |
 Posted - 2009-01-14 : 10:30:54
|
| Hi guys,I have a SQL Server 2005 with multiple database.I have to backup all used database 2 in a week. Each database size is more than 200G. Some of the database does not change, i mean there is no transaction. So i do not want to backup thoes db which are not record effect. I tried to check db size using this sp_helpdb but i am not getting any effect if i insert/edit/delete only one record in a table. Need help how to do...Note: I have to backup full database. |
|
|
PingTheServer
Starting Member
28 Posts |
Posted - 2009-01-14 : 10:48:45
|
| Do a differential backup - that should only get the changes made since your last full. Remember you cant do a differential if you dont have a full.*edit, you could also read about database snapshots and see if that would help you. |
 |
|
|
rudba
Constraint Violating Yak Guru
415 Posts |
Posted - 2009-01-14 : 10:55:49
|
| yes i know that.I removed the 7 days old all backup...before db backup.some db doenot use for 2-3 month.....thats way i have to keep thoes backup db until new backup db... |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-14 : 20:26:56
|
quote:
Originally posted by rudba
yes i know that.I removed the 7 days old all backup...before db backup.Do this after you have done backupsome db doenot use for 2-3 month.....thats way i have to keep thoes backup db until new backup db...Put that backup files in secure place so you restore when you need it.
|
|
|
|
rudba
Constraint Violating Yak Guru
415 Posts |
Posted - 2009-01-15 : 09:17:23
|
Thnks,I am doing same like as you said.But, i don't want to full backup...which database are not any changes.Every weeks, we backup the databases.quote:
Originally posted by sodeep
quote:
Originally posted by rudba
yes i know that.I removed the 7 days old all backup...before db backup.Do this after you have done backupsome db doenot use for 2-3 month.....thats way i have to keep thoes backup db until new backup db...Put that backup files in secure place so you restore when you need it.
|
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-15 : 22:39:15
|
quote:
Originally posted by rudba
Thnks,I am doing same like as you said.But, i don't want to full backup...which database are not any changes. If it's not changing,then secure old backup incase you need itEvery weeks, we backup the databases.quote:
Originally posted by sodeep
quote:
Originally posted by rudba
yes i know that.I removed the 7 days old all backup...before db backup.Do this after you have done backupsome db doenot use for 2-3 month.....thats way i have to keep thoes backup db until new backup db...Put that backup files in secure place so you restore when you need it.
|
|
|
|
|
|
|
Full Database Backup