How to restore an MSSQL .bak database using Microsoft SQL Server 2008 Management Studio Express

Customers can enjoy the ability of remote management of their MSSQL databases using the free software from Microsoft calledMicrosoft SQL Server 2008 Management Studio Express.

 This post will explain how a customer can restore a database to the hosting space from a previously downloaded backup.
Note:Per WHP’sTOSandAUP, keeping a backup on your hosting space is not allowed. Please make sure that after you uploaded a backup, you remove it after the restore from the hosting space.

Note:As of writing of this post, for security purposes, the ability to restore this backup is UNAVAILABLE due to security measures. To be able to do this backup, first contact WHP’s 24/7/365 email support.

  • First, install MSSQL Server 2008 Management Studio Express and connect to your database[1]
  • Now you can use your File Manager or FTP software (FileZilla?) to upload the backup file to the hosting space, under thedatadirectory of your website.
  • Find your database, right click it and click onTasks->Restore->Database…(picture 1)

How to restore an MSSQL .bak database using Microsoft SQL Server 2008 Management Studio Express

 

 

 

 







 

 

On the next screen, Make sure theTo databaseshows the name of your database to be restored into. Under theSource for restoresection, click on theFrom devicebullet and then the … button (picture 2)


How to restore an MSSQL .bak database using Microsoft SQL Server 2008 Management Studio Express

 

 

 

 

 

 







 

In theSpecify Backup window click on theAdd button (picture 3)


How to restore an MSSQL .bak database using Microsoft SQL Server 2008 Management Studio Express

 


































 Ignore the Locat Backup Fileerror dialog box and click on OK (picture 4)

How to restore an MSSQL .bak database using Microsoft SQL Server 2008 Management Studio Express

 

















Now, your hosting space, at WebHostingPeople, exists in C:\HostingSpaces\

Where is your control panel username you use to login to it.
In that hosting space, are then your website’s domains as directories: C:\HostingSpaces\\domain.com
Under each website’s directory, exists a directory calleddata. This is where you’ll put your backup file (picture 5)

  • shai.webhostingpeople= account username
  • shai-webhostingpeople.net= website’s directory in the hosting space
  • data= a directory just under the website’s directory where the backup file will be created
  • shai.webhostingpeople.bak= the backup file to create of the database

How to restore an MSSQL .bak database using Microsoft SQL Server 2008 Management Studio Express



















Confirm in the next window by clicking theOKbutton (picture 6)

How to restore an MSSQL .bak database using Microsoft SQL Server 2008 Management Studio Express

 

 

Tick the check box to the left of the database name row and then click theOptionsmenu on the top-left (picture 7)

 

How to restore an MSSQL .bak database using Microsoft SQL Server 2008 Management Studio Express

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

In theOptionswindow, tick theOverwrite the existing database(picture 8)

How to restore an MSSQL .bak database using Microsoft SQL Server 2008 Management Studio Express

 

 

 

 

 

 

 

 

 

 

 

 

Back in theBack Up Databasewindow, clickOK(picture 9)

 

How to restore an MSSQL .bak database using Microsoft SQL Server 2008 Management Studio Express

 

 

 

 

 

 

 

 

 

 

 

 

When the backup is complete, a success confirmation popup should appear (picture 10)

 

How to restore an MSSQL .bak database using Microsoft SQL Server 2008 Management Studio Express

 

 

 

 

 

 

 

 

Now you can use your File Manager or FTP software (FileZilla?) to download the backup file and remove it from the hosting space.


  • 761 Benutzer fanden dies hilfreich
War diese Antwort hilfreich?

Verwandte Artikel

How to create my MySQL database?

After you are done with the database creation you can use the phpMyAdmin tool to manipulate the...

MySQL Database info: username, password, hostname, database name

Your MySQL database username - is the same as your Control Panel username. our MySQL database...

MySQL administration with phpMyAdmin

MySQL administration with phpMyAdmin NOTE: If You Have Purchased Hosting From Us  Your...

MS Access

MS Access is typically used in conjunction with Windows servers running a MSSQL database. We do...

Maximum number of databases per hosting account

By default our hosting accounts come with a maximum of 50 databases per account. If for any...