{"id":3908,"date":"2018-12-20T08:40:02","date_gmt":"2018-12-20T04:40:02","guid":{"rendered":"http:\/\/www.msp360.com\/blog\/?p=3908"},"modified":"2024-02-14T15:51:55","modified_gmt":"2024-02-14T11:51:55","slug":"restore-database-sql-server","status":"publish","type":"post","link":"https:\/\/www.msp360.com\/resources\/blog\/restore-database-sql-server\/","title":{"rendered":"SQL Server Database Restore with MSP360"},"content":{"rendered":"

MSP360 Backup supports backup and restore of Microsoft SQL Server databases. The product integrates with Microsoft SQL Server's built-in backup and restore mechanisms, provides SQL Server compression, and offers flexible scheduling, among a range of other useful options.<\/p>\n

In this article, we\u2019ll discuss how to restore SQL Server databases using MSP360\u2019s solution. For instructions on the backup process, please refer to our article \u201cSQL Server Database Backup<\/a>.\u201d
\n<\/p>\n

We assume that you\u2019re already familiar with how SQL Server functions, as this article only covers the way in which MSP360\u2019s solution interacts with SQL Server.<\/p><\/blockquote>\n

You need MSP360 Backup for MS SQL Server<\/a> or MSP360 Backup Ultimate<\/a> editions to be able to perform SQL Server database restore.<\/p>\n

Ensure that your server is up and running and then proceed to MSP360 Backup.<\/p>\n

\n
\n
FREE WHITEPAPER<\/div>\n
SQL Server Backup and Recovery<\/div>\n
Check out the ultimate guide with best practices for MSPs:<\/div>\n\"CTA\"<\/a><\/span><\/span>\n<\/div>\n
\"WP<\/div>\n<\/div>\n

How to Restore a Database in Microsoft SQL Server<\/h2>\n

Run MSP360 Backup and launch the Restore Wizard.<\/p>\n

Select the cloud location or physical storage from which to restore your backup. Then select whether to Run restore just once or Save restore plan for further runs (and specify the plan name). Click Next.
\n\"Specify<\/p>\n

On the next wizard page, choose what kind of data you need to restore. To proceed with restoring SQL Server databases, select the corresponding option and click Next.
\n\"Selecting<\/p>\n

Select a version of the data you want to restore. You can choose to restore the Latest version or specify a Point in time. Click Next.
\n\"Select<\/p>\n

5<\/var>Select the SQL Server instance, preferred authentication method and login information. Click Next.
\n\"Selecting<\/p>\n

\u00a0<\/a>\"CTA\"<\/a><\/span><\/span><\/div>\n

Select the databases you'd like to restore and click Next.
\n\"Selecting<\/p>\n

Choose whether to overwrite the existing databases with their restored versions and specify the names for the restored databases. If on step 3 you\u2019ve chosen to Restore MS SQL Server Database, your databases will be restored to the destinations of their origin. If on step 3 you\u2019ve chosen to Restore MS SQL Server backup files, this step will be skipped.
\n\"Specify
\nThe wizard will not be able to overwrite an existing database unless you check the corresponding checkbox.<\/p>\n

If on step 3 you\u2019ve chosen to Restore MS SQL Server Database, configure the additional options for the restored database:
\nadditional options for the restored database:
\n- Data file folder - specifies the location for MDF files.
\n- Log file folder - specifies the location for LDF files containing logs.
\n- File name template - enables you to specify a custom template for naming the restored MDF and LDF files.
\nYou can also choose whether the backup service should close all existing connections to the destination database by enabling the corresponding option on this wizard page.
\n\"Configuring
\nIf on step 3 you\u2019ve chosen to Restore MS SQL Server backup files, you will have to specify a destination folder for your backups and a backup file template.
\n\"Specifying
\nWhen restoring backup files from multiple databases, you can make the wizard automatically create a separate directory in the destination folder for each of these databases by enabling the corresponding option on this wizard page.<\/p>\n

If your data was encrypted on the client side, check the Decrypt encrypted files with the following password box. Enter your password, re-enter it to confirm and click Next.
\n\"Specifying<\/p>\n

On the next few steps, configure the remaining options: create a schedule for your SQL Server database restore process if needed, customize email notifications, specify system log settings, and more.<\/p>\n

Review the details of your MS SQL Server database restore plan and click Next to create it.\"Reviewing<\/p>\n

On the last wizard page, specify whether you need to start the restore process after closing the wizard (this option is available if you chose to save the restore plan previously in this wizard), and click Finish.<\/p>\n

Your MS SQL Server database restore plan has now been created.<\/p>\n","protected":false},"excerpt":{"rendered":"

MSP360 Backup supports backup and restore of Microsoft SQL Server databases. The product integrates with Microsoft SQL Server’s built-in backup and restore mechanisms, provides SQL Server compression, and offers flexible scheduling, among a range of other useful options. In this article, we\u2019ll discuss how to restore SQL Server databases using MSP360\u2019s solution. For instructions on […]<\/p>\n","protected":false},"author":46,"featured_media":29121,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[877,894,882],"tags":[],"class_list":["post-3908","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog-articles","category-msp360-backup","category-msp360-news"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/posts\/3908","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/users\/46"}],"replies":[{"embeddable":true,"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/comments?post=3908"}],"version-history":[{"count":2,"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/posts\/3908\/revisions"}],"predecessor-version":[{"id":57619,"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/posts\/3908\/revisions\/57619"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/media\/29121"}],"wp:attachment":[{"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/media?parent=3908"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/categories?post=3908"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/tags?post=3908"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}