Simon,
I've tried restoring from QA, the directories for the other server and my
server are different so I am using the MOVE option for the data and log
files. The same problem occurs that I was getting using EM, it complains
that the logical file being restored is not part of my database. I've tried
this without a database called 'Test', as well as after creating one and
using the RESTORE FILELISTONLY but the error message is always the same:
here's the code and error message:
RESTORE DATABASE Test FROM DISK = 'C:\Backups\Project Recovery\Sample
Data\RebillingMarch102005.SQLBackup'
WITH NORECOVERY,
MOVE 'g:\mssql\data\rebilling_Data.MDF' TO 'C:\Program Files\Microsoft
SQL Server\MSSQL\Data\Rebilling_Data.mdf',
MOVE 'E:\MSSQL\log\rebilling_Log.LDF' TO 'C:\Program Files\Microsoft SQL
Server\MSSQL\Data\Rebilling_Log.ldf'
response:
Server: Msg 3234, Level 16, State 2, Line 1
Logical file 'g:\mssql\data\rebilling_Data.MDF' is not part of database
'Test'. Use RESTORE FILELISTONLY to list the logical file names.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Thanks,
- Kevin
"Simon Hayes" <sq*@hayes.ch> wrote in message
news:42**********@news.bluewin.ch...
"Kevin" <no*****@provided.com> wrote in message
news:tr_Zd.699401$8l.384177@pd7tw1no... Can anyone recommend the easiest way to get a full copy of a database
from one server to another. The servers are not part of the same organization
or
network.
I have received a backup of the database created with enterprise manager
but
am unable to restore it into a database of the same name on my server.
Thanks,
Kevin
http://support.microsoft.com/default...b;en-us;314546
Backup and restore is usually the easiest way - if you're having a problem
restoring a backup, then I suggest you post whatever error message you
get. You can also try restoring from Query Analyzer:
restore database MyDB from disk = 'c:\temp\db.bak'
Sometimes errors in QA are more informative than what EM tells you. See
the full RESTORE syntax in Books Online for moving file locations etc.
Simon