How to backup your Ultimate Survey survey software database on a daily basis

Article ID	1044	Posted Date	5/6/2005
Product(s)	Ultimate Survey - Enterprise .NET Edition with Dev Kit	Updated Date	5/6/2005

Ultimate Survey Enterprise survey software often contains highly valuable data which should be backed up often. The following steps will show you how to automate a backup of your Ultimate Survey Enterprise survey software database. It will create a new file each day, appended with the number of the day of the week. Each file will be overwritten one week later.

1. Open SQL Enterprise Manager
2. Select the server that contains your Ultimate Survey Enterprise survey software database.
3. Expand the Management section
4. Expand the SQL Server Agent
5. Right-click Jobs and select New Job
6. Add a name for the job. (UltimateSurveyBackup for example)
7. Click the Steps tab
8. Click New
9. Choose a Step Name (BackupDatabase for example)
10. Paste the following into the command window:
(Replace YOUR_DATABASE_NAME with the name of your database, and replace c:\backup\ with the path to save the backup to. This must be a path that already exists.)

DECLARE @cmd varchar(1000)
DECLARE @dbName varchar(255)
DECLARE @path varchar(1000)

SET @dbName = 'YOUR_DATABASE_NAME'
SET @path = 'c:\backup\'
SET @cmd = 'BACKUP DATABASE [' + @dbName + '] TO DISK = N''' + @path + @dbName + '_' + cast(datePart(dw, getdate()) as varchar(10)) + '.bak'' WITH INIT , NOUNLOAD , NAME = N''' + @dbName + ' backup'', NOSKIP , STATS = 10, NOFORMAT'
EXEC(@cmd)
GO

11. Click OK
12. Click the Schedules tab.
13. Click New Schedule
14. Name the Schedule
15. Click Change
16. Choose Daily
17. Choose options for time
18. Click OK
19. Click OK again.