MSSQL DB restore step by step

Customer Support Database Support
1

Could some one show me how restore MSSQL DB step by step by using jodohost’s system?
It is fine to show the steps by using SQL script example.
Thank you.?( :slight_smile:

2

Hi Abe,

I use these 3 steps.

  1. Create the database and user login information in the cp.
  2. upload the *.bak file above the webroot, in a new named folder.
  3. submit a support ticket to have the db restored and inform them of the new db name and server, and location of the .bak file, like /restore_database/.bak.
3

One more thing, make sure tables are owned by dbo, not by the user.