My Sellerdeck Account | Free Trial

Sellerdeck Community & Knowledge Base

Go Back   Sellerdeck Community > Knowledge Base > Sellerdeck Enterprise

Search powered by Google
Register FAQ Members List Search Today's Posts Mark Forums Read

Thread Tools Search this Thread Useful Thread? Display Modes
Old 09-May-2013, 09:13 AM
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 back up an SQL Database in SQL Server 2012

Here are the steps to backup your SQL database in SQL Server 2012.
  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 | Back Up'

  5. This will open the 'Back Up' window. In the General tab, choose 'Backup Type' as Full.
    For 'Destination' choose Disk.
    If you see anything in the list, highlight it and click ‘Remove’
    Then click ‘Add’ to choose the backup location, and choose a unique name

  6. Once you have chosen the backup destination, highlight it and then click 'Options' in the main backup window.

    Choose ‘Overwrite all existing backup sets’ and press OK

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

  8. Do the same for the shipping database

  9. You will now have two .bak files in the destination you specified
Attached Images
File Type: png SQL2012Backup.PNG (37.3 KB, 279 views)
File Type: png SQL2012Backup2.PNG (51.3 KB, 288 views)
File Type: png SQL2012Backup3.PNG (35.9 KB, 286 views)
File Type: png SQL2012Backup4.PNG (74.0 KB, 273 views)
File Type: png SQL2012Backup5.PNG (40.5 KB, 265 views)
File Type: png SQL2012Backup6.PNG (7.5 KB, 291 views)
File Type: png SQL2012Backup7.PNG (39.5 KB, 285 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 07:41 PM.

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