Knowledgebase

How do I restore my database?

You will need to export your database using Generate Scripts with some advanced settings configured for the restore to complete successfully.

Alternatively you may find it easier to request us to restore your database using a bacpac file, or directly from your old SQL server.

Export database to *.sql script

  1. Right-click on the database that should be exported.
  2. "Tasks" -> "Generate Scripts..." - A Generate and Publish Scripts popup should appear

  3. On the "Introduction" screen click the "Next >" button - "Choose Objects" screen will appear;

  4. On the "Choose Objects" screen you select the "Select specific database objects" option, and then tick "Tables" and click "Next >" - "Set Scripting Options" screen should appear; 

  5. On the "Set Scripting Options" choose "Save to file" and then click "Advanced". 



    In the Advanced Scripting Options Window scroll down the list of options, you will need to set "Types of data to script" to "Schema and data".

    You will also need to enable the Index creation, the minimum required for Umbraco is "Script Full-Text Indexes" and "Script Indexes"



    Click the "Next >" button. 
  6. On the "Summary" screen the options you have previously selected and if you are satisfied with them, click the "Next >" button. 

Import database from *.sql script

  1. Open the *.sql script with Microsoft SQL Server Management Studio
    1. In the *.sql script, the first two rows should be something similar to

      USE [DatabaseName]
      GO

      Here in the brackets, you can use the name of the database you would like to populate.

      USE [YourDatabaseName]
      GO
    2. Click the "! Execute" button, or use the F5 shortcut for it.
    3. After a successful execution of the Query, you should find your newly populated database.

 

  • 1 Users Found This Useful
Was this answer helpful?

Related Articles

How do I connect to my database via .NET?

A website built using .NET can be connected to databases of different types: MSSQL, and Access...

How do I manage my Microsoft SQL database?

We recommend using SQL Server Management Studio (SSMS) for managing your Microsoft SQL databases....

What’s the MSSQL database size limit?

At UmbHost, each MSSQL database can store up to 5120 MB (5 GB) of data, and you can store up to...

Can I set my database hostname as ‘localhost’?

No, you would need to set the database hostname as the server that it's on at UmbHost. You can...

Can my database be restored from a bacpac file?

We will happily restore your database from a bacpac file. Please open a support ticket to...