Restoring the Umbraco database

This is a step-for-step tutorial on how to restore a backup script into a SQL Server 2008 instance. To generate a backup script, please see the article on Backing up the Umbraco database.

1. Open SQL-Server Management Studio 2008 and connect to desired database server.
2. Menu: File > Open > File... > select your backup script (*.sql)
3. In the opened window, check to see if your script is running as the desired database. The script should begin with:

   USE
   [MySqlDatabase]
   GO
   

4. If this is not the case, edit the script.
5. Run script with F5 > check to see if the script was run successfully > Finish.