Sheduled task in sql server 2008 r2

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.

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(varchar,GETDATE(),106),' ','')+'_'+REPLACE(convert(varchar,GETDATE(),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