Adding the backup to the Master Database:

1. Create the backup procedure in the Master database:

USE master
EXEC sp_addumpdevice 'disk', 'Pharos_backup', 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup'

2. Check to see if the backup procedure was inserted correctly:

select * from master.dbo.sysdevices

Create the backup job:

3. Scroll down to SQL Server Agent

4. Right Click on Jobs and choose New Job .

Under the General Option:

5. Set Name = Pharos Database Backup
6. Set Owner = sa

Under the Steps option:

7. Click on New
8. Step Name = Database Backup
9. Type = Transact-SQL script (T-SQL)
10. Runas is blank
11. Database = Master
12. Command (Copy and paste the following):

backup log pharos with truncate_only backup database pharos to pharos_backup with init

13. Keep the advance options standard.

Under the Schedule option:

14. Name = Database Backup Schedule
15. Schedule Type= Recurring
16. Occurs = Daily
17. Set the date and time (1:00am) when you would start then click apply

If you would like to complete a test, run the following query:

USE master
backup log pharos with truncate_only backup database pharos to pharos_backup with init

Then check to make sure the backup file was created in the following directory:

'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup'