Sheduled task in sql server 2008 r2

Question

how to write Stored procedure for back up the files in database using sheduled task in sql server 2008 r2 Thanks&Regards Selastin C

Anupam Singh · Answer

Hi selastin bel  There are different types of backup in Sql server like : full backup differential backup transaction log backup. you can take a full backup using a simple query BACKUP DATABASE DB_NAME TO DISK = 'C:\DB_NAME.BAK' // where do you want save backup GO Although I would suggest you to read this you can use Job in sql to schedule this.

Khan Abrar Ahmed · Answer

Hi Create procedure getDbBackup as begin DECLARE @FileName varchar (128) @FilePath varchar (128) @FilePathName varchar (256) @DatabaseName varchar (128) @DatabaseBackupName varchar (256); set @DatabaseName = 'DB Name' set @FileName = '_backup_' + REPLACE(convert(varcharGETDATE()106)' ''')+'_'+REPLACE(convert(varcharGETDATE()108)':''')+'.bak' If (@@SERVERNAME = 'server name') begin set @FilePath = 'Backup location' End set @FilePathName = @FilePath+@DatabaseName+@FileName set @DatabaseBackupName = @DatabaseName+'-Full Database Backup' BACKUP DATABASE @DatabaseName TO DISK = @FilePathName WITH NOFORMAT INIT NAME = @DatabaseBackupName SKIP NOREWIND NOUNLOAD STATS = 10 end go