How to write the statement of the SQL Server7.0 database with RESTORE
Such as: I have backed up a database in E: /TSYY.DAT, I now want to restore this backup database to my database, the database name is Tsyy2, write in the query analyzer:
RESTORE DATABASE TSYY2 from disk = 'e: /tsyy.dat' The following error:
Server: Msg 3141, Level 16, State 1, Line 1The 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 1backup or restore Operation Terminating Abnormal.
