In order to create a training database from the Divers form you need to have a database called SBTraining restored in SQL server. This is a step by step guide to how to create and update your SBTraining database. These steps are the same whether you are using SQL Server Management Studio version 2005 or 2008, the illustrations here are from 2008.

First open SQL Server Management Studio. This is probably on your server and you may need to make a remote connection to your server to access it.

Your login will probably be furlong with the password you have been given for this login (call helpdesk if you need a reminder).

When you have logged in, you will see the object explorer on the left hand side of the screen. This will have the name of the server at the top, and in the list underneath, right click Databases and choose Restore database from the list. This will bring up the restore database dialog shown below.

 In the 'To database' box type SBTraining (if you are updating an old version of SBTraining you can choose this from the lookup, if it's the first time you've created SBTraining you'll have to type it), then choose 'From device' from the radio buttons below.

Press the '...' browse button which will get you to 'Specify Backup' dialog box. 

Click the Add button and navigate to your most recent schoolbase backup (.bak file) using the navigation dialog below. It will automatically open in a default path deep in the SQL server program files, which is probably not where your backup files are held. If you don't know where your backup files are stored, you can find out by looking at your maintenance plan also in SQL server management studio.

Once you have found your backup file, click OK, which will return you to the previous dialog. Click OK o that to return to the main Restore Database window.

You will need to tick the Restore tickbox to the left of the line detailing the database. If you get more than one line at this stage, there is more than one database backup in the backup set you have selected. Check along the detail which is the most up-to-date full backup and choose this to restore.

Having ticked Restore, it is essential that you go to the options screen before restoring the database. Click Options (under General at the top left of the screen) to do this.

You need to change the locations for the database files, because by default they will probably restore to the same place as your SchoolBase database, and you will not want to replace your SchoolBase database with the backup!

You probably want to keep the path the same, so your SBTraining databases are in the folder with your SchoolBase database files, but the filenames at the end will want to be SBTraining.mdf and SBTraining_log.ldf or similar. Make sure you are certain that you will not be overwriting your SchoolBase database files before you press OK.

The only other setting you may need to change is the 'Overwrite the existing database' tickbox at the top. If this is a new SBTraining leave this unticked, but if you are refreshing an old version of SBTraining please tick this option.

Click OK to actually restore the SBTraining database. The Progress wheel at the bottom left will turn green and spin, and you'll see percentages of completion.