Attaching a Database

[twinsfan08]

I am trying to attach a DB but I receive a red X when I verify the .MDF file.

The .ldf amd .mdf file for the database I am trying to attach are coming back with green X's but for some reason it's placing another .ldf file in the attach screen with a red x. How can I delete that red x?

thanks,
Scott

 

[mrdenny]

When the database was detached there must have been a second ldf file. It may still be able to attach the database. If not, try renaming the existing ldf file and attaching the database again. You can also try attaching via the procedure sp_attach_single_file_db.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

Donate to Katrina relief