April 24, 2003 at 9:19 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:29 am
Append to media option allows you to keep multiple backups on the same media.
For example, if you back up every day in a week with append to media option, the system allows you to restore back to any day.
On the other hand if you use choose overwrite, the existing backup is erased. Only the last backup can be restored.
April 24, 2003 at 9:31 am
Could it be the same qusetion on two threads?
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:28 am
This is a "double" posting and is also in the section for BACKUPs. Since that's the more appropriate area, let's allow this one to cease and respond to the other one.
Thanks,
-SQLBill
April 25, 2003 at 4:48 am
Can moderator lock this thread. Please post/see comments in thread http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=11654&FORUM_ID=24&CAT_ID=1&Topic_Title=Backup+Tips&Forum_Title=Backups
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply