SQL Server data backup and storage process [original]

open the park today and share the data backup and storage process that I have been using. Thank you for reprinting !!!

Use [Master] goset ansi_nulls ongoset quoted_identifier offgocreate proc [DBO]. [SQL _backup] @ database nvarchar (50) asdump transaction @ database with no_logbackup log @ database with no_logdbcc shrinkdatabase (@ database) ------------------------ original SQL backup database includeclare @ database nvarchar (100) declare @ datapath nvarchar (100) Declare @ filename nvarchar (100) Declare @ backupfilename nvarchar (100) Declare @ datadescription nvarchar (200) Declare @ datamedianame nvarchar (50) declare @ datamediadescription nvarchar (200) Declare @ okinfo nvarchar (300) Declare @ STR nvarchar (300) Declare @ RND nvarchar (11) Declare @ dir nvarchar (15) declare @ dirin bitdeclare @ temp nvarchar (500) -- Author: im531... -- Description: SQL _backup -- http://im531.cnblogs.com/-- Date: 2005-02-06-set @ database = 'test' set @ temp = ''set @ datapath = 'C: \ www \ SQL _backup \ 'set @ RND = (select left (newid (), 4) + right (newid (), 4) + (select right (datepart (MS, getdate (), 3) set @ STR = rtrim (convert (char (10), getdate (), 112) + '_' + rtrim (datepart (hour, getdate () + '_' + ltrim (datepart (minute, getdate () set @ dir = rtrim (convert (char (10), getdate (), 112) + '_' + rtrim (datepart (hour, getdate ())) set @ filename = @ datapath + @ dir + '\' + @ database + '_ backup _' set @ backupfilename = @ filename + @ STR + '_' + @ rndcreate table [# TB] (a bit, B bit, C bit) set @ temp = @ datapath + @ dirinsert into [# TB] execute Master .. xp_fileexist @ tempif exists (select 1 from [# TB] Where B = 1) set @ dirin = 1 elseset @ dirin = 0 drop table [# TB] Set @ temp = 'md' + @ datapath + @ dirif @ dirin = 0 beginexec master .. xp_mongoshell @ tempendset @ datadescription = 'backup generated by SQL statement, backup time: '+ convert (char (19), getdate (), 121) set @ datamedianame = 'im531 backup... 'set @ datamediadegion = 'author im531... 'set @ okinfo = 'database' + @ database + 'successfully backed up to' + @ backupfilenamebackup Database @ database to disk = @ backupfilenamewith noinit, nounload, noskip, stats = 10, noformat, name = @ database, description = @ datadeloud, medianame = @ datamedianame, mediadeloud = @ datamediadeloud -- 7z compression if @ database = 'dataname' beginset @ temp = 'C: \ 7-zip \ 7z.exe A-t7z' + @ datapath + @ dir + '.7z' + @ datapath + @ dir + '\ *-mx9-R' exec master .. xp_mongoshell @ tempset @ temp = 'rd' + @ datapath + @ dir + '/S/Q' exec master .. xp_mongoshell @ tempendselect @ okinfo as backupinfo ------------------- end --------------------- goexec SQL _backup @ database = n' datamame'