Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- BACKUP DATABASE { database_name | @database_name_var }
- TO <backup_device> [ ,...n ]
- [ <MIRROR TO clause> ] [ next-mirror-to ]
- [ WITH { DIFFERENTIAL | <general_WITH_options> [ ,...n ] } ]
- [;]
- EXEC dbo.sp_add_job
- @job_name = N'BackupDBTestJob',
- @enabled = 1,
- @description = N'Create a complete backup of database TestDB' ;
- GO
- EXEC dbo.sp_add_jobstep
- @job_name = N'BackupDBTestJob',
- @step_name = N'Create the backup',
- @subsystem = N'TSQL',
- @command = N'BACKUP DATABASE DBTest TO DISK = ''c:DBTest.bak'''
- GO
- EXEC dbo.sp_add_schedule
- @schedule_name = N'RunOnceAt23',
- @freq_type = 4, -- means run daily
- @freq_interval = 1, -- means run once every 1 day
- @active_start_time = 233000 ; -- means at 23:00:00
- GO
- EXEC sp_attach_schedule
- @job_name = N'BackupDBTestJob'
- @schedule_name = N'RunOnceAt23;
- GO
Add Comment
Please, Sign In to add comment