Backup , Restore با استفاده از SP

[mjdeveloper]

CREATE PROCEDURE Backup_DataBase
@disk nvarchar(255),
@filename nvarchar(255),
@dbname nvarchar(255),
@backupname nvarchar(255)
AS
exec('
BACKUP DATABASE '+@dbname+' TO DISK = N'''+
@disk+'\'+@filename+'.bak'+''' WITH INIT , NOUNLOAD , NAME = N'''+@backupname+''''+
', NOSKIP , STATS = 10, NOFORMAT')
GO

CREATE PROCEDURE restore_DataBase
@disk nvarchar(1000),
@dbname nvarchar(255)
AS
exec('use master '+
'alter database '+@dbname+' set single_user with rollback immediate '+
'restore database '+@dbname+' from disk =N'''+@disk+''' '+
'alter database '+@dbname+' set multi_user')
GO
:لبخند: