April 24, 2003 at 9:20 am
1.Append to media
2.Overwrite existing media
which is the best option while taking the backup of a database.
April 24, 2003 at 9:30 am
For the backup process it should not matter what you are doing.
This is part of your backup strategy.
I do the first method, until media 1 is full, delete content of media 2, change to media 2 and so on...
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
April 24, 2003 at 10:31 am
I do both depending on how long I need to keep my backup. I append my Full Backups; since one might be bad I want more options.
I overwrite my differentials, since I only need the latest AND if my latest FULL BACKUP is bad, then the differentials won't work anyways.
I do a mixed version with my transaction log backups. I append them between differential backups, but after a differential is done, I overwrite the transaction log backups.
-SQLBill
April 24, 2003 at 11:03 am
For me is impossible to append the full backups because of their size. I have one backup device for the full backups. And another backup device for diff and tlog backups. The logs backups are appended, until another differential backup is executed, wich overwrites all the backups.
April 24, 2003 at 12:15 pm
Both the options have their own pros and cons. It all depends on what you recovery plan is and how much of hard drive space you have.
1. Append to media:
- When you need to retain more then 1 copy.
- Space is not an issue.
- For archive purpose.
2. Overwrite :
- Major reason space crunch.
- Don't require old backup sets.
- To have the latest backup set to restore.
To answer bad copies. You can choose to verify you backup for consistence once the backup is done. So it all upto the person who manages the server and what the client requires. My 2 cents.
April 24, 2003 at 12:30 pm
Absolutely based on the SPACING and the client requirements.
I normally keep full backups for 1 week for moderate databases (in size), 3 days for huge databases. Anyway these backups would be copied to TAPE everynight after the backups complete.
.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply