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 |
|
seandonnelly
Starting Member
6 Posts |
 Posted - 2005-07-11 : 10:20:14
|
| I am in the process of doing a test run restore for our Microsoft CRM databases to the server they will be moved onto in a few weeks. I currently am running SQL 2000, and I backup the DB's to disk and then to tape. I copied the .BAK file and transaction log backups to the soon to be new server, and attempted to run a restore leaving all options at the defaults. When I do so I get the following error, the M drive is the location of the current SQL server I want to move.Device Activation Error The physical file name "M:\sqldata\mssql\data\my_database_org_MSCRM.mdf may be incorrect.File my_database_org_MSCRM can not be restored to M:\sqldata\mssql\data\my_database_org_MSCRM.mdf Use WITH MOVE to identify a valid location for the file.Restore database is terminating abnormally.Any thoughts why it wants to restore to the source drive? |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-07-11 : 10:26:52
|
| "Use WITH MOVE"You can trust the error message on this one. Go to SQL Server Books Online. On the Contents Tab go to Transact SQL Reference and lookup RESTORE and examine the WITH MOVE option.Sean RoussyPlease backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own.I am available for consulting work. Just email me through the forum. |
 |
|
|
seandonnelly
Starting Member
6 Posts |
Posted - 2005-07-11 : 10:32:11
|
| Thanks for the info. I do backup my db's nightly including the ones you mentioned. This is not for disaster recovery, it's to put our SQL onto a dedicated server to improve performance for the users. I actually have these db's backuped up to local disk, NAS, and VXA drive... |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-07-11 : 10:34:00
|
| do you have an M: drive on your new box? |
|
|
|
seandonnelly
Starting Member
6 Posts |
Posted - 2005-07-11 : 10:38:04
|
| No, just C doing RAID1. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-07-11 : 10:40:56
|
quote:
Originally posted by seandonnelly
No, just C doing RAID1.
Since your new system does not have an M: drive, you need to specify a new destination. That is what the WITH MOVE option does.-ec |
|
|
|
seandonnelly
Starting Member
6 Posts |
Posted - 2005-07-11 : 11:58:12
|
| eyechart, thanks for the clarification it's greatly appreciated. I am far from a SQL guru, so this is why I am peforming the test run prior to the scheduled date of the change over.Regards! |
|
|
|
|
|
|
|
|
Restore .BAK file to another server