Backup and Restore

User Generated

yrnaqb20

Programming

Description

  • 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.

This is a discussion post question and only requires 2-3 paragraphs

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Buddy here is the solution. Please reach me imediately if in need of any clarification or an adjustment. Thank you

Surname 1

Name:
Course:
Professor:
Date:

Backups
A full backup is an initial step in backing up data for restoration in the event there is need
for the same. It is the base for all other backups. After the full backup, periodic updates to the
data backed up to include the changes made after the full backup needs to be done, to avoid loss
of the same. This can be done by taking full backups every time the backup file needs to be
updated, but this would be costly in terms of time and resources. The option of differential
backup would come in handy here as it backs up the...


Anonymous
Goes above and beyond expectations!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags