Database - Create a Microsoft SQL® database for Watchdoc

Create a database

To create a database:

1. launch the Microsoft® SQL Server Management Studio tool;

2. from SQL Server Management, connect yourself to the Watchdoc SQL server;

3. in the menu, select the Database entry, then click-right to access the menu ;

4. select new database... :
   

5. in the New database interface, enter the Database Name in the dedicated field :
   

6. then click on the Options menu and choose the Simple recovery mode:

7. click on OK to validate the database creation.

Restore a backup

To restore the database backup :

1. launch the Microsoft® SQL Server Management Studio tool ;

2. from the SQL Server Management, connect yourself to the Watchdoc^® SQL server;

3. select the database to be restored, then click-right and access the menu;

4. in the menu, select Task>Restore>Database:
   
   

    

5. In the Restore database box, in the Restore source section, select From the unity, then click on the Browse button;

6. in the restoration specification box, click on the Add button;

7. browse your workspace to find the restored file .BAK;

8. click on Ok to validate you choice:
   

   
   

    

9. from the Restore options section, tick the Replace the existing database box;
   
   

10. in the restore the files as section, click on , then select the MDF file corresponding to the created database;
    
    

     

11. repeat the operation for the .LDF file;
    
    

     

12. click on OK to launch the database restore;

13. a cursor indicates the restoration progress: