Restoring MSSQL via MS SQL Studio - VPS/Cloud/Dedicated only

Restoring MSSQL via MS SQL Studio - VPS/Cloud/Dedicated only

To restore a MSSQL database to your VPS or dedicated server, you would do the following steps:



1) Login to MS SQL Studio via remote desktop -- you will want to use an
admin login and if you do not have this please contact us.



2) Right click the database that you already created in the control panel and go to Tasks --> Restore --> Database



3) Click "from device" and then click the add button (it is a button with an ellipse -- "..." )



4) Navigate to the bak file that you have and select it and hit OK



5) Check the checkbox under "restore" column on the file list



6) Go to the options section of the restore window



7) Check "Overwrite database"



8) Click the button with the ellipse ("...") for the MDF file (usually top)



9) Navigate to the MDF file that is already created for the database
you are overwriting. It is usually in c:program filesMS SQL
ServerMSSQL1data and will be named "database_name.mdf".



10) Click the button with the ellipse ("...") for the LDF file (usually bottom)



11) Navigate to the LDF file that is already created for the database
you are overwriting. It is usually in c:program filesMS SQL
ServerMSSQL1data and will be named "database_name.ldf".



12) Click OK and wait for it to restore -- big databases will take
longer. If you receive an error that says that it does not have
exclusive rights, disconnect all connections to the database except the
one you're using to restore.



13) Expand the newly restored database --> security and right click "Users" and go to New user



14) Put in the user you have made in the control panel for Login and user and dbo for the default schema.



15) Put in roles that you want this user to have, db_owner is usually good enough.



If you have any problems with the above, please let us know.

    • Related Articles

    • Restoring a MSSQL database from a .sql file using EMS Sql Manager Lite

      How do I restore an MSSQL database from a .sql file? If you don't have a SQL management program, go to http://sqlmanager.net/en/products/studio/mssql to download the freeware version and install to your local computer.   Start EMS Sql Manager. If ...

    • MSSQL Admin Tools

      I would like to manage my MSSQL database. How can I do this? On some of our MSSQL servers we have installed a tool called MyLittleAdmin. This web application allows you to edit your database, back it up and restore it from a backup (MSSQL 2005 & 2008 ...

    • MSSQL Redirect Module

      Cartika has introduced an MSSQL redirect module available for all Reseller customers (including UR customers, VDC, VPS and Cloud customers with MSSQL enabled) This module can be found under E.Manager > 3rd party Tools > CPDevel in your reseller ...

    • Extract or backup a MSSQL database to a .sql file using EMS Sql Manager Lite

      How do I extract or restore an MSSQL database to a .sql file? If you don't have a SQL management program, go to http://sqlmanager.net/en/products/studio/mssql to download the freeware version and install to your local computer.   Start EMS Sql ...

    • MSAccess to MSSQL

      I would recommend that you import your MS-Access database into a sole MSSQL database (as MS-Access is now considered obsolete anyway) you can use any of the following ways; ...