云服务器sqlserver数据库备份

USE msdb;
GO

EXEC sp_add_job @job_name = N'DatabaseBackupJob';
GO

EXEC sp_add_jobstep @job_name = N'DatabaseBackupJob',
    @step_name = N'BackupDatabase',
    @subsystem = N'TSQL',
    @command = N'BACKUP DATABASE [YourDatabaseName] TO DISK = N''/path/to/backup/file.bak'' WITH INIT, NAME = N''Full Backup of YourDatabaseName'', SKIP, STATS = 10;',
    @retry_attempts = 5,
    @retry_interval = 5;
GO

EXEC sp_add_schedule @schedule_name = N'DailyBackupSchedule',
    @freq_type = 4,
    @freq_interval = 1,
    @active_start_time = 233000;
GO

EXEC sp_attach_schedule @job_name = N'DatabaseBackupJob', @schedule_name = N'DailyBackupSchedule';
GO

EXEC sp_add_jobserver @job_name = N'DatabaseBackupJob';
GO