Backup Wizard

If the StarShip database is installed on a full version of SQL Server, we recommend using the backup functionality built into SQL Server Management Studio. If the StarShip database is installed on SQL Server Express, you can perform manual backups or schedule automatic backups of the StarShip database in StarShip Server Manager. Note that when the StarShip database is set to Full Recovery Mode on the SQL Server, you may receive a prompt to switch the database to Simple Mode. Simple Mode is needed to run automatic backups. Full vs Simple Recovery Models

The Simple Recovery Model does not maintain transaction logs and therefore has small space requirements. You can only recover the last database backup but no changes after that last database backup was made.

The Full Recovery Model performs transaction log backups, so you can recover the database to a specific point in time, assuming that your backups are complete up to that point in time.

See also : SQL Server Information

Automatic Backups

Use this method to create regular, recurring backups of the StarShip database. To schedule automatic backups :

1. From the Database menu, select Backup Wizard.
2. Select Automatic Backup and click the Next button.

   

3. Enable the Turn on automatic StarShip Database Backup check box.
4. In the Backup folder field, enter the full path to the folder that Server Manager should use to store the backup files. The default setting is the location of the regular SQL Server ‘Backup’ folder. To restore the default location if a different folder is selected, click the Set Default button.
5. Next, schedule how frequently and at what time the backups should be performed. We recommend backing up the database at least once a week, preferably daily, at a time outside of normal shipping hours.
6. Enter a name for the backup file in the Database backup file field. Click Next.

   

7. Click Finish to exit the scheduling wizard.

   

Manual Backup

Use this method to create a one-time backup of the StarShip database. To run a manual backup:

1. From the Database menu, select Backup Wizard.

2. Select Manual Backup and click Next.

   

3. An informational window will appear. Click Next.

   

4. In the Backup folder field, enter the full path to the folder that Server Manager should use to store the backup files. The default setting is the location of the regular SQL Server ‘Backup’ folder. To restore the default location if a different folder is selected, click the Set Default button.

5. Enter a name for the backup file in the Database backup file field. Click Next.

6. To perform a full backup of the database, enable the Full database backup check box; for an incremental backup of the database, leave it unchecked. An incremental backup is only available once a full backup has already been performed. Click Next to start the backup.

   

7. Click Finish to exit the backup wizard.

   

 

Back to top