Backup and Restore (THIS IS A DISCUSSION QUESTION)

profilelilb05
  • Suppose you are a DBA for WonderWorks, a large-sized company with 30 SQL server. Two (2) of the servers are considered critical, and the remaining are considered non-critical. You have been tasked to create a backup strategy for your database servers. Outline the benefits of using a backup model that uses full backups, differential backups, and transactional log backups. Justify the use of such a model to a CIO who is reluctant to spend budget on backups.
  • Imagine you are a DBA researching an easier solution to back up your database. Review the article titled “Copy Databases with Backup and Restore” located at http://technet.microsoft.com/en-us/library/ms190436%28v=sql.110%29.aspx. Then, briefly explain the benefits of copying databases with backup and restore. Determine whether or not you would use this method, and explain the reasons why or why not.
    • 10 years ago
    • 5
    Answer(0)
    Bids(0)