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 |
|
dewacorp.alliances
452 Posts |
 Posted - 2007-07-20 : 19:46:31
|
| Hi allWe normally do a full backup daily and no TLogs backup due to this particular database and this database is not critical and can be lost a day if necessary but the database is quite large (100GB).We're starting to look at differential backup cause we almost running backup window during weekdays night cause affecting other backup.This what we do:Full backup on Saturday @ 7AM:BACKUP DATABASE [XXXXX] TO DISK = N'\\YYYYY01\SQL_Backups\SQL\ZZZZZ01\XXXXX\XXXXX_FULL.BAK' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMATDifferential Backup on Sunday, Monday, Tueday, Wednesday, Thursday and Friday @ 00:15 AM.BACKUP DATABASE [XXXXX] TO DISK = N'\\YYYYY01\SQL_Backups\SQL\ZZZZZ01\XXXXX\XXXX_DIFF.BAK' WITH INIT, DIFFERENTIAL, NOUNLOAD , NOSKIP , STATS = 10, NOFORMATMy question is for the differential backup, do I need to do INIT everytime? What is the impact on this in term of restoring? Let say on Wednesday, the database is corrupt and I have to restore it and the let say the database backups are ok on Saturday (full), Sunday (diff), Monday (diff) and Tuesday (diff). Does this means that I can just restore from Saturday (full) and straight to Tuesday (diff) ?What happen if the Tuesday backup is corrupt for unknown reason, does this means I only get from Saturday (full) cause I owerwrite the other diffs?Also, is there any script and generate the datestamp at the end of the backup file? Thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-20 : 22:15:24
|
| 1. Restore from full backup plus most recent diff. backup.2.2. In your case, you have only full backup if diff. backup is bad. You can keep multiple diff.backups if have enough storage space.3. For backup file name, check this link: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=86547. |
 |
|
|
|
|
|
|
|
Differential Backup