Re: Error 5123 Cannot Attach DB

Thanks Hari,

I will try the stopping of SQL Server and do the file move/renames after
hours. I think this will work and hopefully SQL Server won't choke on
restart!

Cheers,
Leslie

"Hari Prasad" wrote:

> Hi,
>
> Can you stop MSSQL Server service and copy both files into a new folder.
> Then rename the copied files to a different name
> and try to attach the database.
>
> Also verify the file names and directory you mention is correct.
>
> Thanks
> Hari
> SQL Server MVP
>
> "Leslie" <Leslie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:A9250A47-F159-4DD0-B7B3-B3AE24638468@xxxxxxxxxxxxxxxx
> > Hari,
> >
> > I cannot copy the files as I get the same lock error. I have determined
> > it
> > is indeed SQL Server which is locking the files. I have rebooted the SQL
> > Server as well, and that does not clear the file locks. I'm afraid the
> > DBCC
> > OpenTran (oldoaiapp) is what caused the lock.
> >
> > I tried the Query Analyzer command below and am getting the error below
> > (the
> > filename path IS correct):
> >
> > EXEC sp_attach_db @dbname = 'OldOAIApp',
> >
> > @filename1 = N'C:\SQLData\MSSQL\Data\POAIAPP.mdf',
> > @filename2 = N'C:\SQLData\MSSQL\Data\POAIAPP_log.ldf'
> >
> > Error:
> > Server: Msg 5105, Level 16, State 4, Line 1
> > Device activation error. The physical file name
> > 'C:\SQLData\MSSQL\Data\POAIAPP.mdf' may be incorrect.
> >
> > "Hari Prasad" wrote:
> >
> >> Hi,
> >>
> >> Probably your MDF or LDF file will be used by either Backup process or
> >> Anti
> >> virus software. Verify both first and attach again.
> >> If you still have issues then try to copy the files to a new folder and
> >> use
> >> SP_ATTACH_DB to attach the database.
> >>
> >> Incase if you still have issues then restart sql server service.
> >>
> >> Thanks
> >> Hari
> >> SQL Server MVP
> >
>
>
>
.

Relevant Pages

  • Re: waitresource
    ... SQL Server MVP ... > Also on lock escalation, i think in your Inside SQL server 2000, you ... >> Kalen Delaney ... >> SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: master db
    ... > In this case you can have a common database user and keep a application ... >>> It is always better to create SQL Server Logins rather than ... >>> Hari ... >>> SQL Server MVP ...
    (microsoft.public.sqlserver.clients)
  • Re: Database corrupted since windows reboot
    ... Well, I don't really know about SQL server, so I just can answer a few ... Hari Prasad a écrit: ... Did you gone thru the SQL Server Error logs and Event viewer? ... >> the help of a third part program, and he never restart his computer. ...
    (microsoft.public.sqlserver.tools)
  • Re: Restore msdb and master db from files.
    ... Thanks Hari, you're saying the same thing as me, just better. ... > applied service pack and attached the user databases. ... Install SQl server in same directory as old and apply the same service ...
    (microsoft.public.sqlserver.server)
  • Re: cant backup - urgent
    ... So some other program with an improper install program or version DLL checking might mess thing up ... Tibor Karaszi, SQL Server MVP ... > Hari and Adam, ... But as an immediate solution execute the backup database command from ...
    (microsoft.public.sqlserver.server)