Restoring a MS SQL Database

Version 11 by Nata Ramanenka
on Feb 21, 2012 02:06.

<< Changes from 10 to 11

compared with

Current by Nata Ramanenka
on Feb 27, 2012 03:51.

Key

This line was removed.

This word was removed. This word was added.

This line was added.

Changes (1)

View Page History

h2. Restoring a MS SQL Database

R1Soft CDP provides the ability to take a snapshot of the Microsoft SQL server databases. Since CDP is using the VSS SQL writers, it ensures data integrity and consistency during the backup operation.

...

Follow the instructions below to restore a MS SQL database previously backed up by R1Soft CDP.

----
{toc:location=top|maxLevel=3|minLevel=3|type=flat|separator=pipe|style=border:1}

----
h3. Step 1: Restoring Database Data and Log Files

To restore a database, follow the instructions below in your CDP.

1. Click on "Recovery Points" in the Main Menu to open the "Recovery Points" screen.
|| Standard Edition || Enterprise Edition || Advanced Edition ||
| !menu-recp-st.png! | !recovery-points-menu.png! | !menurecoverypointadva.png!\\ |
2. Select a Recovery Point you want to restore from. You can restore the files from any available Recovery Point. Click on the "Browse" icon in the "Actions" column for this Recovery Point.

!sql-restore1.png!
{info:title=Tip}To find a Recovery Point, you can use the Basic and Advanced List Filters. See [CDP3:Customizing the Recovery Points List].
{info}
3. The "Browse Recovery Point" window opens. Browse to locate the location of the SQL data and log files ({color:blue}.mdf {color} and {color:blue}.ldf{color}).  See also: [Browsing Recovery Points].

!sql-restore2.png!

4. Check off the database {color:blue}.mdf{color} data files and {color:blue}.ldf{color} log files you want to restore.

!sql-restore3.png!

5. When you are finished selecting the files and directories, click the "Restore Selected" button.

!sql-restore4.png!

6. In the "Restore Files" window, define the restore options.

First, select an existing Agent to restore to or define a new Host name/IP and its port number.

!sql-restore5.png!

Second, if the database already exists and you want to restore the {color:blue}.mdf{color} and {color:blue}.ldf{color} files to an alternate location, check the option and specify the path where the files will be restored. Optionally, check the "Overwrite Existing Files" option.

!sql-restore6.png!

Third, define the Advanced options if needed:
* *Estimate Restore Size*
* *Restore Discretionary ACLs (File Permissions)*
* *Restore System ACLs (Audit Rules)*

!sql-restore7.png!

7. Click on "Restore."

!sql-restore9.png!

8. A notification window will inform you that the Restore task has been scheduled. This means the Task has started. The "Reporting" screen displays the progress of the Task. Click "OK" in the displayed window.

!sql-restore8.png!

----
h3. Step 2: Attaching the Database Data and Log Files

Follow the instructions below to attach the database data and log file.

1. From the SQL Server Management Studio, right-click the "Databases" item and select the "Attach..." command in the menu.

!sql-restore10.png!

2. Browse to the restore location.
{info:title=Note}If you restored it to an alternate location, the path will include the new location as well as the old hierarchy of the file location.
{info}
!sql-restore11.png!

3. In the "Attach As" column, change the database name if the original database is still online.

!sql-restore12.png!

4. Click "OK." The database is now attached.

!sql-restore13.png!

{excerpt:hidden=true}Instructions on how to restore MS SQL database previously backed up by CDP.{excerpt}