WinSPC Knowledgebase Home | Glossary | Favorites | Contact | Login WinSPC Knowledgebase Home | Glossary | Favorites | Contact | Login
Search the WinSPC Knowledgebase Browse by Category
How do I restore my backed-up 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 restore a backup of a WinSPC database running on Microsoft SQL Server 2008 Express or SQL Server 2005 Express. (To create such a backup, reference the knowledge base artice titled How do I backup my 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.)
    • 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 instance name in the Object Explorer, double-click the 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 for your WinSPC database.

    03 - object explorer 02 small.jpg


  7. Right-click your WinSPC database folder and, in the submenu that appears, select Tasks > Restore > Database.


  8. tasks - restore submenu small.jpg

    This causes the Restore Database dialog box to be displayed.

    05 - restore database 01 small.jpg

  9. In this Restore Database dialog box, under Destination for restore:
    • At To database, if you want to overwrite your existing WinSPC database with the backup, specify the name of your WinSPC database. Otherwise, specify another database or enter a new database name.
    • At To a point in time, if you want the database restored to the date and time the backup was created, accept the Most recent possible default. In most cases, this will be the appropriate option. For an explanation of other options, consult your DBA or click Help at the top of the dialog box.
  10. Still in the Backup Database dialog box, under Source for restore, if the server on which the backed-up database resides is the server on which the new or exiting database specified in the preceding step resides, select From database and specify the name of the backed-up database. Otherwise, select From Device, click the ellipsis button and, in the Specify Backup dialog box that appears, specify the media and location of the backup.
  11. Under Select the backup sets to restore, select the specific backup sets within the backed-up database that you want restored.  
  12. In the top left of the dialog box, under Select a page, click Options. This causes the Options tab to appear.


  13. 06 - restore database - options small.jpg

  14. On this Options tab, under Restore options, if you would like to specify one or more additional options for the restore operation, do so by checking the appropriate check box(es). Often, users like to check the Overwrite the existing database check box. This option results in the files of the database named in the To database field (see step 7 above) being overwritten. (For an explanation of the available restore options, click Help at the top of the dialog box.)  
  15. Still on the Options tab, under Recovery state, select the desired option for the state of the recovered backup sets. In most cases, the first option, which is the one selected by default, is accepted. (For an explanation of the recovery state options, click Help at the top of the dialog box.)
  16. Click the dialog box's OK button.
  17. Allow the progress indicator in the dialog box's lower left corner to reach 100%.


  18. 07 - executing small.jpg
  19. When a message appears indicating the backup completed successfully, click its OK button.


  20. 08 - restore successful notification small.jpg

  21. 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 restore my backed-up 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.