[EXTREMELY URGENT] sp_attach_db error

[George]

I am attaching a database with 3 data files.
When I execute "exe sp_attache_db.. ." I obtain this error:
database 'POINT' cannot be opened because some of the files could not be
activated.
I have deleted its LDF file.
Usually I detach my db, then I delete transaction log, and reattach 3 data
files...
Now it doesn'work!!!!! !!!!!
Someone can help me?
Thanks.

[Greg D. Moore \(Strider\)]

Re: [EXTREMELY URGENT] sp_attach_db error


"George" <giorgio.benede ttiNOSPAM@liber o.it> wrote in message
news:bovm8o$8o0 $1@newsreader.m ailgate.org...[color=blue]
> I am attaching a database with 3 data files.
> When I execute "exe sp_attache_db.. ." I obtain this error:
> database 'POINT' cannot be opened because some of the files could not be
> activated.
> I have deleted its LDF file.
> Usually I detach my db, then I delete transaction log, and reattach 3 data
> files...
> Now it doesn'work!!!!! !!!!![/color]

First, it should be noted in case you're not aware that deleting the LDF
file is a VERY bad idea. It should only be done in the most rare of cases.

I"m actually surprised that sp_attach_db has worked at all w/o the log file.

However, you can try sp_attach_singl efile_db, but I doubt it will work.

You'll probably have to call Microsoft on this.

[color=blue]
> Someone can help me?
> Thanks.
>
>[/color]