Results 1 to 3 of 3

Thread: backups

  1. #1
    Join Date
    Apr 2003
    Posts
    176

    Unanswered: backups

    I have some backups scheduled on my sqlserver.most of them are differentail backups.But among them some have options 'Append to media' and some of them are 'Overwrite existing media '. But i dont know which of them falls into which category.How can i find that and can i cahnge 'Append to media' to 'Overwrite existing media '?If yes how can i do that?Does it effect my db if i change it?
    INfact which one is the best option ('Append to media','Overwrite existing media ') among these two?
    Thanks.

  2. #2
    Join Date
    Sep 2003
    Posts
    522
    you need to identify your app requirements, retention resources availabilities, disaster recovery processes (if exist, else - develop them based on business needs), and then tailor your backup strategy to the above. looks like you inherited the box(-s) from someone else and nothing is documented.

  3. #3
    Join Date
    Apr 2003
    Posts
    176
    yep, nothing is documented abt the existing backups,
    How do i know the info?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •