在VC客户端里使用调用存储过程,存储调用backup备份了数据库,可是调用restore恢复时,不能将restore 写在所操作的数据库的存储过程里,还有要恢复的数据库不能处于使用状态,并且需要sysadmin用户才能操作,问题:
1、如何在客户端调用restore;
2、用connection对象的execute方法调用总出错;
3、如何保证要恢复的数据库不在使用状态;
1、如何在客户端调用restore;
2、用connection对象的execute方法调用总出错;
3、如何保证要恢复的数据库不在使用状态;
RESTORE DATABASE { database_name | @database_name_var }
[ FROM < backup_device > [ ,...n ] ]
[ WITH
[ RESTRICTED_USER ]
[ [ , ] FILE = { file_number | @file_number } ]
[ [ , ] PASSWORD = { password | @password_variable } ]
[ [ , ] MEDIANAME = { media_name | @media_name_variable } ]
[ [ , ] MEDIAPASSWORD = { mediapassword | @mediapassword_variable } ]
[ [ , ] MOVE 'logical_file_name' TO 'operating_system_file_name' ]
[ ,...n ]
[ [ , ] KEEP_REPLICATION ]
[ [ , ] { NORECOVERY | RECOVERY | STANDBY = undo_file_name } ]
[ [ , ] { NOREWIND | REWIND } ]
[ [ , ] { NOUNLOAD | UNLOAD } ]
[ [ , ] REPLACE ]
[ [ , ] RESTART ]
[ [ , ] STATS [ = percentage ] ]
]