Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-18 : 00:51:09
|
louis writes "Im having problem restoring a database to a new database for example
i have databas abc currently running nightly backups abc.bak
i tak a copy of abc.back to a new machine with SQL server runnning and run the following command
se master
restore database abc
from disk ='d:\livebackup\abc.BAK'
with move 'abc' to 'd:\mssql7\data\abc.mdf'
i get the following error:
Server: Msg 3234, Level 16, State 2, Line 2
File 'abc' is not a database file for database 'abc'.
Server: Msg 3013, Level 16, State 1, Line 2
Backup or restore operation terminating abnormally.
what im i doing wrong and what is the right way to do it
thanks in advance" |
|
|
|
|
|
Restoring a Database on different server