P_db_full_backup database full backup
P_db_log_backup Database Log backup
Add to job. Welcome to test
Leadbbs code |
Create proc p_db_full_backup @ dbname nvarchar (500), @ path nvarchar (500) as declare @ SQL nvarchar (4000) declare @ date nvarchar (600) declare @ filename nvarchar (1000) If isnull (@ dbname, '') ='' or isnull (@ path ,'') = ''in in return end set @ date = Replace (replace (convert (nvarchar, getdate (), 120 ),'','. '),'-',''),':','') set @ Path = @ path + N' \ ' set @ filename = @ dbname + N' _ full_back _' + @ date + N '. bak' set @ SQL = n' backup database ['+ @ dbname + N'] to disk = n' + @ path + @ filename + ''' with init, nounload, name = n''' + @ dbname + N' _ full _ backup '', noskip, stats = 10, noformat ' exec (@ SQL) |
leadbbs Code |
Create proc p_db_log_backup @ dbname nvarchar (500), @ path nvarchar (500) as declare @ SQL nvarchar (4000) declare @ date nvarchar (600) declare @ filename nvarchar (1000) If isnull (@ dbname, '') ='' or isnull (@ path ,'') = ''in in return end set @ date = Replace (replace (convert (nvarchar, getdate (), 120 ),'','. '),'-',''),':','') set @ Path = @ path + N' \ ' set @ filename = @ dbname + N' _ log_back _' + @ date + N '. bak' set @ SQL = n' backup log ['+ @ dbname + N'] to disk = n' + @ path + @ filename + ''' with retaindays = 2, noinit, name = n''' + @ dbname + N' _ log _ backup ''' ' exec (@ SQL) |