用restore 恢复sql server7.0数据库的语句应怎样写
如:我现在备份了一个数据库在E:/tsyy.dat,我现在想把这个备份的数据库恢复到我的数据库中,数据库名为tsyy2,在查询分析器中写:
restore database tsyy2 from disk = 'E:/tsyy.dat' 执行后报以下错:
Server: Msg 3141, Level 16, State 1, Line 1
The database to be restored was named 'TSYY'. Reissue the statement using the WITH REPLACE option to overwrite the 'tsyy2' database.
Server: Msg 3013, Level 16, State 1, Line 1
Backup or restore operation terminating abnormally.