June 26, 2008 at 10:21 am
Hi,
We just did a migration of hardware for our SQL Server 2005 databases. The procedure was suppose to be very straight forward but we ended up with having one of the databases (1 out of 5) becoming invalid when we remounted.
Has anyone seen this issue? What could cause this? The procedure was to shutdown SQL Server then reattach the new hardware to same SAN fibre and then remount the databases. But one of the databases became invalid and we had to spend hours doing restore and copying from our datawarehouse to get back to normal.
Would greatly appriciate any feedback on this issue as we are about to update even more hardware.
Thanks,
lhamre
June 26, 2008 at 10:22 am
This is the exact error:
the file 'S:\..._log.mdf' is not a primary database file
June 26, 2008 at 10:02 pm
That error indicates that an attempt was made to mount a log file as a data file (which is never going to work). Seems to be some sort of mismatch somewhere. Most log files will have _log in their name and by default will have a .ldf extension. From what you have posted, you have a log file with a .mdf extension. What other files are associated with that database? Make sure you know which file is which.
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply