Database Restoration Error - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Database Restoration Error

Author

Topic

sachinsamuel
Constraint Violating Yak Guru

383 Posts

Posted - 2008-02-15 : 00:49:21

Hi Experts,

I am setting up new production box. I have 2 separate boxes with SQL server 2000 Standard Edition with sp4.

As SQL server standard edition don't have logshipping in it, I created manual jobs to ship logs every 10 mins and Full Backup once in a day from Server A to Server B.

Database on server A have multiple filegroups. When I try restoring database backup on Server B which already has the database on standby, I get an error.

Server: Msg 5173, Level 16, State 1, Line 1
Cannot associate files with different databases.
Server: Msg 5105, Level 16, State 1, Line 1
Device activation error. The physical file name 'I:\sqldata\psi_db\PSI_DB_TESTDATA.mdf' may be incorrect.
Server: Msg 5173, Level 16, State 1, Line 1
Cannot associate files with different databases.
Server: Msg 5105, Level 16, State 1, Line 1
Device activation error. The physical file name 'I:\sqldata\psi_db\PSI_DB_ITEMDATA.mdf' may be incorrect.
Server: Msg 5173, Level 16, State 1, Line 1
Cannot associate files with different databases.
Server: Msg 5105, Level 16, State 1, Line 1
Device activation error. The physical file name 'I:\sqldata\psi_db\PSI_DB_OTHERDATA.mdf' may be incorrect.
Server: Msg 5173, Level 16, State 1, Line 1
Cannot associate files with different databases.
Server: Msg 5105, Level 16, State 1, Line 1
Device activation error. The physical file name 'I:\sqldata\psi_db\PSI_DB_ANALYSISDATA.mdf' may be incorrect.
Server: Msg 5173, Level 16, State 1, Line 1
Cannot associate files with different databases.
Server: Msg 5105, Level 16, State 9, Line 1

.
.
.
.
.
.
.
This error continues for all the files I created on server A

But the path I:\sqldata\psi_db\ exists.

Restoration works fine when I don’t have any database on Server B.
I am using the "replace" keyword while doing the restoration

Please help, this is little urgent.

Thanks in advance.

Regards
Sachin

Don't sit back because of failure. It will come back to check if you still available. -- Binu

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-02-15 : 17:30:37

What command are you running when you get this error?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

sachinsamuel
Constraint Violating Yak Guru

383 Posts

Posted - 2008-02-18 : 03:42:25

Hi Tara,

Thanks for the reply.

Below is the command which I am using to restore, over an existing database. I am running on SQL server 2000 standard edition with SP4.

restore database psi_db from disk = '\\sdnetapp1\web_app_logs\SQLDBBackups\SDPROD-DB1\psi_db\SET-6-0_psi_db_FULL_200802140255.bak' with Move 'PSI_DB_Log3' to 'I:\sqldata\psi_db\PSI_DB_Log3.ldf',Move 'PSI_DB_Log2' to 'I:\sqldata\psi_db\PSI_DB_Log2.ldf',Move 'PSI_DB_Log1' to 'I:\sqldata\psi_db\PSI_DB_Log1.ldf',Move 'TCCFI_FG_File4' to 'I:\sqldata\psi_db\TCCFI_FG_File4.mdf',Move 'TCCFI_FG_File3' to 'I:\sqldata\psi_db\TCCFI_FG_File3.mdf',Move 'TCCFI_FG_File2' to 'I:\sqldata\psi_db\TCCFI_FG_File2.mdf',Move 'TCCFI_FG_File1' to 'I:\sqldata\psi_db\TCCFI_FG_File1.mdf',Move 'CAAV_FG_File3' to 'I:\sqldata\psi_db\CAAV_FG_File3.mdf',Move 'CAAV_FG_File2' to 'I:\sqldata\psi_db\CAAV_FG_File2.mdf',Move 'CAAV_FG_File1' to 'I:\sqldata\psi_db\CAAV_FG_File1.mdf',Move 'CTIO_FG_File2' to 'I:\sqldata\psi_db\CTIO_FG_File2.mdf',Move 'CTIO_FG_File1' to 'I:\sqldata\psi_db\CTIO_FG_File1.mdf',Move 'IA_FG_File3' to 'I:\sqldata\psi_db\IA_FG_File3.mdf',Move 'IA_FG_File2' to 'I:\sqldata\psi_db\IA_FG_File2.mdf',Move 'IA_FG_File1' to 'I:\sqldata\psi_db\IA_FG_File1.mdf',Move 'TestCenter_FG_File2' to 'I:\sqldata\psi_db\TestCenter_FG_File2.mdf',Move 'TestCenter_FG_File1' to 'I:\sqldata\psi_db\TestCenter_FG_File1.mdf',Move 'CTA_FG_File4' to 'I:\sqldata\psi_db\CTA_FG_File4.mdf',Move 'CTA_FG_File3' to 'I:\sqldata\psi_db\CTA_FG_File3.mdf',Move 'CTA_FG_File2' to 'I:\sqldata\psi_db\CTA_FG_File2.mdf',Move 'CTA_FG_File1' to 'I:\sqldata\psi_db\CTA_FG_File1.mdf',Move 'TestCenterDS_FG_File2' to 'I:\sqldata\psi_db\TestCenterDS_FG_File2.mdf',Move 'TestCenterDS_FG_File1' to 'I:\sqldata\psi_db\TestCenterDS_FG_File1.mdf',Move 'CTTS_FG_File2' to 'I:\sqldata\psi_db\CTTS_FG_File2.mdf',Move 'CTTS_FG_File1' to 'I:\sqldata\psi_db\CTTS_FG_File1.mdf',Move 'CTIR_FG_File4' to 'I:\sqldata\psi_db\CTIR_FG_File4.mdf',Move 'CTIR_FG_File3' to 'I:\sqldata\psi_db\CTIR_FG_File3.mdf',Move 'CTIR_FG_File2' to 'I:\sqldata\psi_db\CTIR_FG_File2.mdf',Move 'CTIR_FG_File1' to 'I:\sqldata\psi_db\CTIR_FG_File1.mdf',Move 'LOG_FILEGROUP_File4' to 'I:\sqldata\psi_db\LOG_FILEGROUP_File4.mdf',Move 'LOG_FILEGROUP_File3' to 'I:\sqldata\psi_db\LOG_FILEGROUP_File3.mdf',Move 'LOG_FILEGROUP_File2' to 'I:\sqldata\psi_db\LOG_FILEGROUP_File2.mdf',Move 'LOG_FILEGROUP_File1' to 'I:\sqldata\psi_db\LOG_FILEGROUP_File1.mdf',Move 'Candidate_Payments_FG_File4' to 'I:\sqldata\psi_db\Candidate_Payments_FG_File4.mdf',Move 'Candidate_Payments_FG_File3' to 'I:\sqldata\psi_db\Candidate_Payments_FG_File3.mdf',Move 'Candidate_Payments_FG_File2' to 'I:\sqldata\psi_db\Candidate_Payments_FG_File2.mdf',Move 'Candidate_Payments_FG_File1' to 'I:\sqldata\psi_db\Candidate_Payments_FG_File1.mdf',Move 'Candidate_Scores_FG_File4' to 'I:\sqldata\psi_db\Candidate_Scores_FG_File4.mdf',Move 'Candidate_Scores_FG_File3' to 'I:\sqldata\psi_db\Candidate_Scores_FG_File3.mdf',Move 'Candidate_Scores_FG_File2' to 'I:\sqldata\psi_db\Candidate_Scores_FG_File2.mdf',Move 'Candidate_Scores_FG_File1' to 'I:\sqldata\psi_db\Candidate_Scores_FG_File1.mdf',Move 'Test_Regn_FG_File4' to 'I:\sqldata\psi_db\Test_Regn_FG_File4.mdf',Move 'Test_Regn_FG_File3' to 'I:\sqldata\psi_db\Test_Regn_FG_File3.mdf',Move 'Test_Regn_FG_File2' to 'I:\sqldata\psi_db\Test_Regn_FG_File2.mdf',Move 'Test_Regn_FG_File1' to 'I:\sqldata\psi_db\Test_Regn_FG_File1.mdf',Move 'Candidate_photo_File3' to 'I:\sqldata\psi_db\Candidate_photo_File3.mdf',Move 'Candidate_photo_File2' to 'I:\sqldata\psi_db\Candidate_photo_File2.mdf',Move 'Candidate_Photo_File1' to 'I:\sqldata\psi_db\Candidate_Photo_File1.mdf',Move 'Candidate_Status_File2' to 'I:\sqldata\psi_db\Candidate_Status_File2.mdf',Move 'Candidate_Status_File1' to 'I:\sqldata\psi_db\Candidate_Status_File1.mdf',Move 'CandidateSiteDat' to 'I:\sqldata\psi_db\CandidateSiteDat.mdf',Move 'PracticeTestDat' to 'I:\sqldata\psi_db\PracticeTestDat.mdf',Move 'psi_db_licensedata' to 'I:\sqldata\psi_db\psi_db_licensedata.mdf',Move 'PSI_DB_HISTORYDATA' to 'I:\sqldata\psi_db\PSI_DB_HISTORYDATA.mdf',Move 'PSI_DB_ANALYSISDATA' to 'I:\sqldata\psi_db\PSI_DB_ANALYSISDATA.mdf',Move 'PSI_DB_OTHERDATA' to 'I:\sqldata\psi_db\PSI_DB_OTHERDATA.mdf',Move 'PSI_DB_ITEMDATA' to 'I:\sqldata\psi_db\PSI_DB_ITEMDATA.mdf',Move 'PSI_TestData_File2' to 'I:\sqldata\psi_db\PSI_TestData_File2.mdf',Move 'PSI_DB_TESTDATA' to 'I:\sqldata\psi_db\PSI_DB_TESTDATA.mdf',Move 'PSI_DB_Index_File2' to 'I:\sqldata\psi_db\PSI_DB_Index_File2.mdf',Move 'PSI_DB_INDEX2' to 'I:\sqldata\psi_db\PSI_DB_INDEX2.mdf',Move 'PSI_DB_INDEX1' to 'I:\sqldata\psi_db\PSI_DB_INDEX1.mdf',Move 'PSI_DB_LOOKUPDATA' to 'I:\sqldata\psi_db\PSI_DB_LOOKUPDATA.mdf',Move 'PSI_DB_CD_File2' to 'I:\sqldata\psi_db\PSI_DB_CD_File2.mdf',Move 'PSI_DB_CANDIDATEDATA' to 'I:\sqldata\psi_db\PSI_DB_CANDIDATEDATA.mdf',Move 'PSI_DB_ACCOUNTDATA_FILE3' to 'I:\sqldata\psi_db\PSI_DB_ACCOUNTDATA_FILE3.mdf',Move 'PSI_DB_ACCOUNTDATA_FILE2' to 'I:\sqldata\psi_db\PSI_DB_ACCOUNTDATA_FILE2.mdf',Move 'PSI_DB_ACCOUNTDATA' to 'I:\sqldata\psi_db\PSI_DB_ACCOUNTDATA.mdf',Move 'PSI_DB_DATA_File2' to 'I:\sqldata\psi_db\PSI_DB_DATA_File2.mdf',Move 'PSI_DB_Data' to 'I:\sqldata\psi_db\PSI_DB_Data.mdf', replace,
standby='\\sdnetapp1\web_app_logs\SQLDBBackups\SDPROD-DB1\psi_dbpsi_dbundo_full.bak'

Don't sit back because of failure. It will come back to check if you still available. -- Binu

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-02-18 : 12:50:35

Don't you have to put your undo file on a local drive?

How large is your database that youneed all of these files?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

sachinsamuel
Constraint Violating Yak Guru

383 Posts

Posted - 2008-02-19 : 01:24:11

I can put the undo file on local box too.. but that doesn't solve this error. The database size is 60 GB.

Regards
Sachin

Don't sit back because of failure. It will come back to check if you still available. -- Binu

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources