使用存储过程备份与还原数据库
备份:
ALTER PROCEDURE [dbo].[database_backup](
@dir VARCHAR(100) --文件目录
)
AS
BEGIN
declare @cmd nvarchar(4000)
declare @path nvarchar(4000)
declare @now datetime
set @now = getdate()
set @dir = @dir + '\' +'bakup'
set @path=@dir+'\bakup.bak'
set @cmd = 'mkdir ' + @dir;
PRINT @cmd;
exec sp_configure 'show advanced options'<