SQL Server 2000 backup command config

SQL Server 2000 backup command config

1.open [sql server enterprise manager]

2.open [microsof sql servers\sql group\local\manage\sql 代理程式\operation]

3.open and modify item

4.click [setup] and [edit]

5.modify [command] below

DECLARE @filename NVARCHAR(200)

set @filename = convert(NVARCHAR(19),getdate(),120)

set @filename = REPLACE(@filename,':','.')

set @filename = N'C:\backup\'+@filename+'_dbname.bak'

BACKUP DATABASE [dbname] TO DISK = @filename WITH NOINIT , NOUNLOAD , NAME = N'dbname backup', NOSKIP , STATS = 10, NOFORMAT