Restore MSSQL Datbase from .BAK File - Godaddy, Powerdnn

[ShiftPoint]

I have a few websites that are hosted with Godaddy and Powerdnn and wanted to backup the production MSSQL database and load it into my local sql database for testing and development purposes.

You can log into your hosting provider and find your way through the menus to create a backup of your production MSSQL database. Once your able to do this download the file to the C:\ drive. Open up SSMS and run something like this:

Code: Select all

RESTORE DATABASE MyDataBase
FROM DISK = 'C:\MyDataBase.BAK'
WITH REPLACE, MOVE 'MyDataBase' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATAMyDataBase_Data.MDF',
MOVE 'MyDataBase_log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\MyDataBase_Log.LDF'

Keep in mind you can move the database files to any location you wish. The location above is the default location for MSSQL Server Express 2008 that is installed on Windows 2008 Web Server Edition.