sp_attach_single_file_db

[sahernandez]

Hi, I have a big problem,
One of my database were "Loading" status,
I used the sp_detach_db, and when I try to attach with the sp_attach_db I got the error "the LDF file is corrupt".
so I deleted and I used "sp_attach_single_file_db" but I'm also got this error.
"Server: Msg 945, Level 14, State 2, Line 1
Database 'SocMaster' cannot be opened because some of the files could not be activated.
Server: Msg 1813, Level 16, State 2, Line 1
Could not open new database 'SocMaster'. CREATE DATABASE is aborted."

SO now I try to create a new database (diferent server) with my SocMaster_Data.mdf , how can I do that, can anybody help me please.

Thxs.
Alexander

 

[TheBugSlayer]

What do you mean by 'loading status'? Are you sure the DB was effectively detached? If yes, reatach the DB where it was originally, backup both DB and log file and try again.

Check this link for more details

http://support.microsoft.com/defaul...port/kb/articles/q271/2/23.ASP&NoWebContent=1