close
生成MSSQL Data備份的存儲過程SET QUOTED_IDENTIFIER OFF GOSET ANSI_NULLS OFF GO ALTER PROCEDURE CPP_BackDataBase@databasename varchar(100)) 情趣用品ASdeclare @filename varchar(100),@cmd varchar(255)select @databasename = rtrim(@databasename)select @filename = 'c:sqlbackup'+ 酒店打工rtrim(convert(varchar(10),getdate(),20))set @cmd = 'md '+@filenameexec master.dbo.xp_cmdshell @cmdselect @filename = @filename 澎湖民宿+''+@databasename + rtrim(convert(varchar(10),getdate(),20))select @filename = ltrim(rtrim(@filename))select @cmd ='BACKUP 土地買賣DATABASE['+@databasename+'] TO DISK = N'''+@filename +'.bak'' WITH INIT , NOUNLOAD , NAME = 借貸N''' +@filename+'備份 '', SKIP , STATS = 10, FORMAT 'exec (@cmd)if(@databasename <> 'master' and 找房子@databasename <>'msdb')begin --backup log with truncate_only select @filename = 酒店兼職'c:sqlbackup'+@databasename+'log.back' select @cmd = ' BACKUP LOG ['+@databasename+'] TO DISK = 新成屋N'''+@filename+''' WITH INIT , NOUNLOAD , NAME = N'''+@filename +'LOG Backup'', NOSKIP , 網路行銷STATS = 10, NOFORMAT ' exec (@cmd) select @cmd = 'backup log ['+@databasename+'] with truncate_only' exec 找房子(@cmd)endGOSET QUOTED_IDENTIFIER OFF GOSET ANSI_NULLS ON GO http://blog.csdn.net/downmoon/archive/2007/06/05/1639398.aspx baidu
全站熱搜
留言列表
