Backing up or Restoring an MSSQL database on cp.blacknight.com

This applies only to MSSQL databases on our post 2008 Windows hosting packages (set up through cp.blacknight.com)

For security reasons we don't allow remote access to our shared MSSQL servers so you will need to log in to the MyLittleAdmin interface to restore a backup (in .bak format) to your newly created database.

You can access the MyLittleAdmin interface by putting the "External Servername" in your browser.  e.g. http://mssql792.cp.blacknight.com , http://mssql792.cp.blacknight.com etc.


When you login to the mylittleadmin interface there will be a menu on the left hand side entitled:

Tools >> Restore Wizard

and you can use this to restore your MS SQL .bak file.

After you do a restore here please note that the database user you set up in cp.blacknight.com will become disconnected from the restored database (as the user would not be in your local backup) so you will need to delete the user, re-add it, and set it up as the default database user under:

Databases >> database name >> Users