My Sellerdeck Account | Free Trial

Sellerdeck Community & Knowledge Base

Old 11-Oct-2010, 01:16 PM
G.W.Green G.W.Green is offline
Join Date: Sep 2005
Full Name: G.W.Green
Posts: 485
Thanks: 0
Thanked 68 Times in 43 Posts
How to restore an SQL Database

Here are the steps to restore your SQL database.
  1. Close SellerDeck on all machines
  2. Open ‘Microsoft SQL Server Management Studio’

  3. Expand ‘Databases’
  4. Right click on the database and go to ‘Tasks | Restore | Database…’

  5. This will open the ‘Restore’ window. In the General tab, choose ‘From Device’ and click the browse button.

    For ‘Backup Media’ choose File.
    Then click ‘Add’ to choose the backup location

  6. Once you have chosen the backup location, check the ‘Restore’ option and then click ‘Options’ in the main backup window.

    Choose ‘Overwrite the existing database…’ and press OK

  7. You will then get a message saying the restore was successful

  8. Do the same for the shipping database

  9. Your Databases will now be restored to the previous backup.
Attached Images
File Type: jpg Screen1.jpg (18.1 KB, 735 views)
File Type: jpg Screen2.jpg (27.4 KB, 751 views)
File Type: jpg Screen3.jpg (32.4 KB, 732 views)
File Type: jpg Screen4.jpg (31.5 KB, 725 views)
File Type: jpg Screen5.jpg (38.7 KB, 735 views)
File Type: jpg Screen6.jpg (9.1 KB, 752 views)
File Type: jpg Screen7.jpg (20.4 KB, 697 views)
Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

All times are GMT. The time now is 10:44 AM.

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.