WinSPC Knowledgebase Home | Glossary | Favorites | Contact | Login WinSPC Knowledgebase Home | Glossary | Favorites | Contact | Login
Search the WinSPC Knowledgebase Browse by Category
How do I backup my WinSPC database if I'm running Microsoft SQL Server Express?
Article Details

Last Updated
11th of May, 2017

Applies to
WinSPC 7.2, WinSPC 8.0, WinSPC 8.1, WinSPC 8.2, WinSPC 8.3, WinSPC 9.0

This procedure is not meant to supplant or supersede documentation or best practices from Microsoft. If you find a discrepancy between this procedure and documentation or best practices from Microsoft, follow the documentation or best practices from Microsoft.

This procedure guides you through one way to backup a WinSPC database running on Microsoft SQL Server 2008 Express or SQL Server 2005 Express. The screen shots you will see are from SQL Server 2008 Express but they differ little from what you would see in SQL Server 2005 Express. (If and when you want to restore the backup, reference the knowledge base artice titled How do I restore my backed-up WinSPC database if I'm running Microsoft SQL Server Express?)

  1. Launch Microsoft SQL Server Management Studio.
  2. In the Connect to Server prompt that appears:
    • At Server Type, select Database Engine.
    • At Server Name, specify the computer name on which your WinSPC database resides and the name of the instance which is used by WinSPC, separating these two names by a backslash (\). (The default instance name for both SQL Server 2008 Express and SQL Server 2005 Express is SQLEXPRESS.)  
    • At Authentication, select SQL Server Authentication.
    • At Login, specify sa.
    • At Password, enter the password for sa that was supplied when SQL Server Express was installed.
    • Click Connect.

    01 - connect to server small.jpg


  3. If the Object Explorer is not displayed, select Object Explorer from the View menu.
  4. If the Databases folder is not visible beneath the server\instance name in the Object Explorer, double-click the server\instance name.


  5. 02 - object explorer 01 small.jpg

  6. Double-click the Databases folder and as many of its subfolders as necessary to expose the folder in which your WinSPC database resides.


  7. 03 - object explorer 02 small.jpg

  8. Right-click your WinSPC database folder and, in the submenu that appears, select Tasks > Backup.


  9. 04 - tasks - backup submenu small.jpg

    This causes the Back Up Database dialog box to appear.

    05 - backup database small.jpg

  10. In the Back Up Database dialog box, under Source:
    • At Database, select your WinSPC database.
    • At Backup Type, if you are backing up your WinSPC database so you can send the backup to DataNet's help desk, select Full. This results in the full database being backed up, which is what the help desk will need. Otherwise, if you prefer, select Differential. Selecting differential backs up only that data which has changed since the last full backup.
    • Ensure the Copy Only Backup check box is unchecked.
    • At Backup Component, ensure Database is selected.
  11. Still in the Backup Database dialog box, under Backup set:
    • At Name, if the default name for the backup file is unacceptable to you, provide an alternative name.
    • At Description, if desired, enter a note that describes the backup.
    • At Backup set will expire, accept the After: 0 days default, which means that the backup set will never automatically expire, or specify when you want the backup set to expire. (Expire, in this case, means allowing the database set to be overwritten.)    
  12. Still in the Backup Database dialog box, under Destination, if the default destination for the backup file is unacceptable to you, provide an alternative destination.
  13. In the top left of the dialog box, under Select a page, click Options. This causes the Options tab to be displayed.


  14. 06 - backup database - options small.jpg

  15. On this Options tab, under Overwrite media, select one of the following two options:
    • Back up to the existing media set: This option results in the backup being made to whatever media set is currently in use. (A media set is simply the set of storage media used for a backup.)
    • Back up to a new media set, and erase all existing backup sets: This option results in the backup being made to a media set other than the one currently in use and the erasure of any backup sets currently on that new media set.
  16. If, in the preceding step, you selected Back up to the existing media set:
    • Select Append to the existing backup set if you want the new backup set to be added onto the end of the existing backup set. This option results in no overwriting. 
    • Select Overwrite all existing backup sets if you want any backup sets currently on the existing media set to be deleted and replaced by the new backup set.
    • If you want to have the backup operation check and verify the name of the media set and the specified expiration date for the backup sets before beginning the backup, check the Check media set name and backup set expiration check box and then, in the Media set name text box that becomes enabled, enter the name of the existing media set. 
  17. If, in step 11, you selected Back up to a new media set, and erase all existing backup sets:
    • At New media set name, enter the name of the new media set to be used.
    • At New media set description, if desired, enter a description of the new media set.
  18. Under Reliability, if you want to specify additional options, check the appropriate check boxes. For an explanation of the available options, click Help at the top of the dialog box.
  19. Click the dialog box's OK button.
  20. Allow the progress indicator in the dialog box's lower left corner to reach 100%.


  21. 07 - executing small.jpg

  22. When a message appears indicating the backup completed successfully, click its OK button.


  23. 08 - success notification small.jpg

  24. Exit Microsoft SQL Server Management Studio.
Attachments
No attachments were found.
Related Articles
Visitor Comments
No visitor comments posted. Post a comment
Post Comment for "How do I backup my WinSPC database if I'm running Microsoft SQL Server Express?"
To post a comment for this article, simply complete the form below. Fields marked with an asterisk are required.
   Your Name:
   Email Address:
* Your Comment:
* Enter the code below:
 

All Content 2012 DataNet Quality Systems. All Rights Reserved.