October 19, 2005 at 7:52 am
I have an interesting issue with a nightly restore to our adhoc database.
The issue is that it works sometimes, and other nights it fails. We have 32 databases in this scheduled process, but only 3 of them have any problems, where some nights they work, and others they dont????
The code that is being executed is:
RESTORE DATABASE DB06
FROM DISK = 'D:\LogShipTemp\Production_data.bak'
WITH
REPLACE,
MOVE 'Production_Data' TO 'D:\SQLData\MSSQL\Data\DB06_data.mdf',
MOVE 'Production_log' TO 'D:\SQLData\MSSQL\Data\DB06_log.ldf'
The error message that we sometimes get is:
Server: Msg 5173, Level 16, State 1, Procedure restore_Production_backups, Line 23
Cannot associate files with different databases.
Log file 'D:\SQLData\MSSQL\Data\DB06_log.ldf' does not match the primary file. It may be from a different database or the log may have been rebuilt previously.
Processed 341720 pages for database 'DB06', file 'Production_Data' on file 1.
Processed 2 pages for database 'DB06', file 'Production_Log' on file 1.
RESTORE DATABASE successfully processed 341722 pages in 287.968 seconds (9.721 MB/sec).
The backup that we are using is a FULL backup.
Anyone have any ideas?
Thanks in Advance
Eric Peterson
October 21, 2005 at 7:23 pm
Are the paths to the data and log for the db different from the primary to the fail over server?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply