Cartika

Welcome, Guest Login

Support Center

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

Last Updated: Jun 09, 2014 06:15PM EDT
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.

Contact Us

sales@cartika.com
https://cdn.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete