If you need to deploy Symantec Data Center Security: Server Advanced in an evaluation installation, or you just need to install several DCS agents on the critial business server, you can use SQL Server express edition.
The installation of the DCS:SA will install the server and the SQL Server express automatically.
After the installtion, you can use the following steps to backup the database:
1. Create a sql file named backup.sql which contains these SQL statements:
GO
DECLARE
@backupTime VARCHAR(20)
DECLARE
@fileName VARCHAR(1000)
SELECT
@backupTime=(CONVERT(VARCHAR(8), GETDATE(), 112) +REPLACE(CONVERT(VARCHAR(5), GETDATE(), 114), ':', ''))
SELECT
@fileName='E:\DCSDB_backup\DCSDB_'+@backupTime+'.bak'
backup database SCSPDB to disk=@fileName
2. Create a bat file named backup.bat which contains the following statement:
sqlcmd -S localhost\SCSP -i E:\DCSDB_backup\backup.sql
3. Copy these two files to the backup folder, for example: E:\DCSDB_backup\:
4. Launch Task Scheduler from Windows start:
5. Right click 'Task Scheduler Library', select 'Create Basic Task':
6. Input the task name and description:
7. Select the trigger as 'Daily':
8. Set the task start time:
9. Select 'Start a program':
10. Select the backup.bat as the program/script:
11. Select 'Open the Properties dialog for this task when I click Finish':
12. Select 'Run whether user is logged on or not':
13. You can test the configuration of the task by start it manually:
14. After the task finished, there is a database backup file created on E:\DCSDB_backup\:
