August 9, 2007 at 11:08 pm
Dear All,
I have a problem in restoring the databases onto a standby server with the recent full backup and diff backup as the recovery model is simple. The error message i get is
1. "Cannot associate file with different databases."
2. "Cannot apply the backup on device --- to dabase 'xxxx'
3. Log file ---- does not match the primary file. It may be from a different database or the log may have been rebuilt previously.
Thanks & Regards
Chandra Mohan N
[font="Verdana"]Thanks
Chandra Mohan[/font]
August 13, 2007 at 10:08 pm
The database on your standby server may be different from the database you would like to restore.
September 12, 2007 at 6:45 pm
Can you post the exact command you issued and the exact error messages that were output?
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply