View Full Version : Steps to take before restoring an MS SQL database through MyLittleBackup

October 29th, 2011, 01:38 PM
Before you restore a Microsoft SQL Server (MS SQL) database through MyLittleBackup there are a few precautions to take.

Make sure you set your tables and stored procedures to be owned by DBO as described in this forum post (http://forum.hostek.com/showthread.php?106-MSSQL-Server-Error-invalid-object-name). (Pay attention to the second post in that thread for instructions on modifying your stored procedures)
Because MS SQL Server includes a database's users in the backup it creates, you'll want to temporarily remove the database user from your local database. This will prevent issues when restoring the database to our environment.
Once you've created a backup of your database, you'll want to log into your Hostek.com control panel. Once in the control panel, click the MS SQL icon and edit your database. Here you will set the Database Owner to 'none' and save.
Now you can click the SQL Tools icon in your control panel to log into MyLittleBackup and restore your database backup.
Once the restoration has completed, edit your database via the control panel and set the Database Owner back to your database's username.

If you have any specific questions about restoring your database via MyLittleBackup, post them here and we'll be glad to help.