NOTE: The following
only applies to a
full installation (
Standard, Enterprise, etc.) of
SQL Server. SQL Server Express does not include some features that are mentioned below. Following steps shall assist with determining the SQL version:
- Log into SSMS.
- Once logged in, right-click on the SQL Server Name on the top-left under Object Explorer and use the New Query option.
- Type/Paste the following query into the window in the middle of the screen:
select @@version
- Hit F5 or the Execute button above the Object Explorer on the top-left. The results window at the bottom will return the version.
If you're unsure about the SQL Server details for the Track-It! Database, refer
How to check the Database name and SQL Server/Instance name for Track-It! 20.xx.
Instructions:
- On the database server, open SQL Server Management Studio (SSMS).
- Login using SysAdmin (SA) or equivalent account.
- Under the database server name from the Object explorer on the top-left, expand the Databases folder.
- Right-click the Track-It! database and then click Properties.
- Select the Options page and make sure the Recovery Model is set to "Full". NOTE: You may choose the "Simple" recovery model, however, you will not be able to setup scheduled backups of the Transaction log as instructed below.
- Click Ok if any changes had been made.
- Next, under the database server name expand the Management folder.
- Right-click Maintenance Plans and then select Maintenance Plan Wizard. You also need to make sure the SQL Server Agent windows Service is up and running.
- When the SQL Server Maintenance Plan Wizard appears, click Next.
- Enter a name for the plan and description if desired (eg: Track-It! DB Backups).
- At the bottom, enable the 'Separate schedules for each task' option (unless the database is running in Simple recovery mode and you will only be doing a full backup). click Next.
- Enable the Back Up Database (Full) and Back Up Database (Transaction Log) options and then click Next.
- On the 'Select Maintenance Tasks Order' window click Next again.
- Select the database that you would like to backup, i.e., the Track-It! 20.xx database, and, if desired, specify a location, using the Destination tab, other than the default path for where the backup will be saved. Additional settings can be configured using the Options tab.
- At the bottom, under Schedule click the Change button and select the frequency that you would like the full backup to run.
- Once the schedule has been set, click OK.
- Click Next to go to the next task (Transaction Log backup).
- Once again, select the database that you would like to backup and, if desired, specify a location other than the default path for where the transaction log backup will be saved. NOTE: Only databases running in Full recovery mode will appear in the list.
- At the bottom, under Schedule click the Change button and select the frequency that you would like the transaction log backup to run. For example, set it to run the backup every four hours or more.
- Once the schedule has been set, click OK.
- Click Next, select the location where a backup report file will be created and then click Next.
- Click Finish to complete the wizard.
A maintenance plan has now been created to create a full database backup as well as frequent transaction log backups that can be used to recover the database if needed. Make sure to monitor the jobs to make sure the backups are being created as expected.