几句SQL解释？

[xiaowangtian1117]

Alter Database @DatabaseName Set OFFLINE with Rollback immediate
RESTORE DATABASE @DatabaseName FROM DISK = @BackupPath
Alter Database @DatabaseName Set ONLINE With rollback Immediate
我知道第二句是数据库恢复，请问第一句和第三句是什么意思？
是不是数据库中事务处理，当恢复中断时撤销以前的恢复动作，保持原来的数据？
当我把这几句写到存储过程中时，报错!是不是OFFLINE 和ONLINE 有问题?请问怎么修改,谢谢!

[xiaowangtian1117]

高手在那里?

[ZHANGWEI15]

Alter Database @DatabaseName Set OFFLINE with Rollback immediate
RESTORE DATABASE @DatabaseName FROM DISK = @BackupPath
Alter Database @DatabaseName Set ONLINE With rollback Immediate


第一句应该是设置数据库脱机.报错的话可能有人在使用巴

[xiaowangtian1117]

是在存储过程保存的时候报错,是语法错误

[xiaowangtian1117]

up

[vivianfdlpw]

create procedure p
@DatabaseName varchar(20)
as
declare @sql varchar(200)
set @sql='Alter Database @DatabaseName Set OFFLINE with Rollback immediate'+
'RESTORE DATABASE @DatabaseName FROM DISK = @BackupPath'+
'Alter Database @DatabaseName Set ONLINE With rollback Immediate'
exec(@sql)

[vivianfdlpw]

写错了，blush:

create procedure p
@DatabaseName varchar(20)
as
declare @sql varchar(200)
set @sql='Alter Database '+@DatabaseName+' Set OFFLINE with Rollback immediate'+
'RESTORE DATABASE '+@DatabaseName+' FROM DISK = @BackupPath'+
'Alter Database '+@DatabaseName+' Set ONLINE With rollback Immediate'
exec(@sql)