Can't Restore Database to New Server

Hi
I am attempting to transfer a database from my server to my customers
server. I took the backup file on CD however when I try to do a restore with
it I get the following error
Microsoft SQL-DMO (ODBC SQLState:42000)
Device activation error:The physical file name
'd:\sqldata\mssql\data\sa.mdf' may be incorrect.
File 'SA-V1_dat' cannot be restored to 'd:\sqlData\MSSQL\data\sa.mdf'. Use
WITH MOVE to identify a valid location for the file.
Device activation error. The physical file name
'd:\sqlData\MSSQL\data\sa_log.ldf' may be incorrect.
File 'SA-V1_log' cannot be restored to 'd:\sqlData\MSSQL\data\sa_log.ldf'.
Use WITH MOVE to identify a valid location for the file.
RESTORE DATABASE is terminating abnormally.
Suggestions how to overcome this'
Regards
MeirDo what the error message say. Read about the RESTORE command in Books Online and use the MOVE
option to specify desired physical files names for your database files.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"mrrcomp" <mrrcomp@.discussions.microsoft.com> wrote in message
news:41F751D3-42E2-4292-B0F5-77E593B6C75D@.microsoft.com...
> Hi
> I am attempting to transfer a database from my server to my customers
> server. I took the backup file on CD however when I try to do a restore with
> it I get the following error
> Microsoft SQL-DMO (ODBC SQLState:42000)
> Device activation error:The physical file name
> 'd:\sqldata\mssql\data\sa.mdf' may be incorrect.
> File 'SA-V1_dat' cannot be restored to 'd:\sqlData\MSSQL\data\sa.mdf'. Use
> WITH MOVE to identify a valid location for the file.
> Device activation error. The physical file name
> 'd:\sqlData\MSSQL\data\sa_log.ldf' may be incorrect.
> File 'SA-V1_log' cannot be restored to 'd:\sqlData\MSSQL\data\sa_log.ldf'.
> Use WITH MOVE to identify a valid location for the file.
> RESTORE DATABASE is terminating abnormally.
> Suggestions how to overcome this'
> Regards
> Meir
>|||As error says to you, use MOVE TO option of the RESTORE command to move
physical files to a new location. If you use EM, check the Options tab when
restoring, there you can specify a new location.
--
Dejan Sarka, SQL Server MVP
Mentor
www.SolidQualityLearning.com
"mrrcomp" <mrrcomp@.discussions.microsoft.com> wrote in message
news:41F751D3-42E2-4292-B0F5-77E593B6C75D@.microsoft.com...
> Hi
> I am attempting to transfer a database from my server to my customers
> server. I took the backup file on CD however when I try to do a restore
> with
> it I get the following error
> Microsoft SQL-DMO (ODBC SQLState:42000)
> Device activation error:The physical file name
> 'd:\sqldata\mssql\data\sa.mdf' may be incorrect.
> File 'SA-V1_dat' cannot be restored to 'd:\sqlData\MSSQL\data\sa.mdf'. Use
> WITH MOVE to identify a valid location for the file.
> Device activation error. The physical file name
> 'd:\sqlData\MSSQL\data\sa_log.ldf' may be incorrect.
> File 'SA-V1_log' cannot be restored to 'd:\sqlData\MSSQL\data\sa_log.ldf'.
> Use WITH MOVE to identify a valid location for the file.
> RESTORE DATABASE is terminating abnormally.
> Suggestions how to overcome this'
> Regards
> Meir
>|||Hi,
To add on:
Try the below steps:-
From Query Analyzer:-
1. Using Restore filelistonly command identify the logical file names of the
database backup file
RESTORE FILELISTONLY from disk='c:\x.bak'
2. With the output of the above query use RESTORE database
RESTORE DATABASE <newdbname> from disk='c:\backup\x.bak'
WITH move 'logical_mdf_filename' to 'new physical name with path',
move 'logical_ldf_filename' to 'new physical log name with
Path'
After the restore refer sp_change_users_login to syncronize the Logins.
Thanks
Hari
SQL Server MVP
"mrrcomp" <mrrcomp@.discussions.microsoft.com> wrote in message
news:41F751D3-42E2-4292-B0F5-77E593B6C75D@.microsoft.com...
> Hi
> I am attempting to transfer a database from my server to my customers
> server. I took the backup file on CD however when I try to do a restore
> with
> it I get the following error
> Microsoft SQL-DMO (ODBC SQLState:42000)
> Device activation error:The physical file name
> 'd:\sqldata\mssql\data\sa.mdf' may be incorrect.
> File 'SA-V1_dat' cannot be restored to 'd:\sqlData\MSSQL\data\sa.mdf'. Use
> WITH MOVE to identify a valid location for the file.
> Device activation error. The physical file name
> 'd:\sqlData\MSSQL\data\sa_log.ldf' may be incorrect.
> File 'SA-V1_log' cannot be restored to 'd:\sqlData\MSSQL\data\sa_log.ldf'.
> Use WITH MOVE to identify a valid location for the file.
> RESTORE DATABASE is terminating abnormally.
> Suggestions how to overcome this'
> Regards
> Meir
>

Can't read from database ?

Hi,
one of our customers had a server crash. So I recovered the database from
backup and integrated it successfully into another sql server. I'm able to
connect through DSN file. Tests ok but the application which should work wit
h
the database seems to have problems to read or connect to the database.
What have I to bear in mind when recovering a database from backup on a new
server?
Sincerely
makOne of the first things is to ensure you have proper Login to User mapping.
You also may need to worry about some permissions. Have a look at these:
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://msdn2.microsoft.com/en-us/library/ms345408(en-US,SQL.90).aspx Moving
system dbs 2005
http://www.databasejournal.com/feat...cle.php/3379901 Moving
system DB's 2000
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://www.support.microsoft.com/?id=221465 Using WITH MOVE in a Restore
http://www.sqlservercentral.com/col...se
s.asp
Moving Users
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after
a Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scr...sp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
http://www.support.microsoft.com/?id=320125 Moving a Diagram
http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues 2000
http://www.sqlservercentral.com/scr...utions/1598.asp Script
Roles and Permissions
Andrew J. Kelly SQL MVP
"K-iS" <KiS@.discussions.microsoft.com> wrote in message
news:A1A76593-8903-4C6E-8B69-464524359F8D@.microsoft.com...
> Hi,
> one of our customers had a server crash. So I recovered the database from
> backup and integrated it successfully into another sql server. I'm able to
> connect through DSN file. Tests ok but the application which should work
> with
> the database seems to have problems to read or connect to the database.
> What have I to bear in mind when recovering a database from backup on a
> new
> server?
> Sincerely
> mak
>|||Does the server have the same name? If not, has the application connection
string been changed to the new server?
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"K-iS" <KiS@.discussions.microsoft.com> wrote in message
news:A1A76593-8903-4C6E-8B69-464524359F8D@.microsoft.com...
> Hi,
> one of our customers had a server crash. So I recovered the database from
> backup and integrated it successfully into another sql server. I'm able to
> connect through DSN file. Tests ok but the application which should work
> with
> the database seems to have problems to read or connect to the database.
> What have I to bear in mind when recovering a database from backup on a
> new
> server?
> Sincerely
> mak
>