How to Restore a MSSQL Database from SolidCP?

Example: Restore a SQL server 2012 Database

> Please log in to solidcp

> Please Click the SQL Server 2012

> Please choose the Database and Click the Database

> Please click “Maintenance Tools” and click “Restore”

> Restore the SQL database, Please choose the database backup file from the correct path, the format of database backup can be .bak or .zip.

> Please click restore

>Restoration is completed. Please find that the database size is changed if it has been restored successfully.
If the database is larger than 200MB, it is highly suggested to restore the database by SSMS. Otherwise, the restoral process will halt or fail.

 

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to Create FTP account in SolidCP?

> Please Login to Control Panel  > Please Click "My Server" in Hosting Spaces >...

How to Enable Dedicated Application Pool and Write Permission for Website in SolidCP?

Issue If a website uses a shared application pool, and if other websites also use it in the...

How to Add Domain in SolidCP?

> Please Login to SolidCP and click "Domains" under the Hosting Spaces tab > Please...

How to Create Website in SolidCP?

> Please log in to the SolidCP Control Panel and click "Web Sites" under the Hosting Spaces...

How to Enable PHP for Websites in SolidCP?

Issue: We need to enable PHP for web site and the web application needs PHP support. > Please...