--Full BackUp
--Use Master
CREATE proc [dbo].[bakup_DataBase]
as
Declare @strPsw varchar(50)
Declare @strUsr varchar(50)
Declare @strCmdShell varchar(300)
Declare @strDataBaseName varchar(20)
Declare @FullFileName Varchar(200)
Declare @FileFlag varchar(50)
Declare @ToFileName varchar(200)
Declare @SQLStr varchar(500)
Declare @SQLStr2 varchar(500)
Declare @FlagDel varchar(20)
Set
@FileFlag=replace(replace(convert(char(20),getdate(),20),':','') ,' ','-') -- : - .bak
Set @strUsr='SOFMTI_TD\administrator' -- \ （ Windows )
Set @strPsw='sofmit'-- Windows ( :Soondy)
Set @strCmdShell= 'net use \\192.168.0.22\c$ ' + @strPsw + ' /user:' +@strUsr -- IP( IP ， :192.168.2.178)
Set @strDataBaseName='LilianDB'-- ( :Soondy)
Set @FullFileName='E:\SqlServer \'+'LilianDB_backup_'+@FileFlag+'.BAK'
-- ， copy ( : E:\SoondyTest\)
Set @ToFileName='\\192.168.0.22\D$\OneCardBak\' -- IP( IP ) ( :\\192.168.2.178\c$\Test\)
Set @FlagDel='False'-- True ， False
Set @SQLStr='copy '+@FullFileName+' '+@ToFileName
Set @SQLStr2='del ' +@FullFileName
BackUp DataBase @strDataBaseName To Disk= @FullFileName with init
exec master..xp_cmdshell @strCmdShell--
exec Master..xp_cmdshell @SQLStr --
if (@FlagDel ='True') exec master.. xp_cmdshell @SQLStr2--