Sunday, February 12, 2012

Attaching a Database which was not deatached.

Hello Can anyone please tell me how i can attach a database which was not
detached from the server previously?
right now when i try to use sp_attach_db i get error code 9004 , same thing
happens in SQL Enterprise manager...
I made backup of the 2 datafile/logfile on cd-rom but when i try to attach
them after the server hardware failed, i get that weird 9004 error code.Did you make a SQL Server backup of the database by issuing a BACKUP
DATABASE command?
What version and service pack are you using?
You might find the following useful:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;277843
http://support.microsoft.com/default.aspx?scid=kb;EN-US;274797
--
Bryan Bitzer MCP
Senior Database Administrator
Marshall & Swift / Boeckh
www.msbinfo.com
"Artmic" <Artmic@.discussions.microsoft.com> wrote in message
news:2DB5489D-137F-4A40-8122-810E9F80036C@.microsoft.com...
> Hello Can anyone please tell me how i can attach a database which was not
> detached from the server previously?
> right now when i try to use sp_attach_db i get error code 9004 , same
thing
> happens in SQL Enterprise manager...
>
> I made backup of the 2 datafile/logfile on cd-rom but when i try to attach
> them after the server hardware failed, i get that weird 9004 error code.
>|||9004 usually means you have a corrupt logfile (means that your logfile is
useless)
you can try
sp_attach_single_file_db (use datafile only)
see how this goes.
"Bryan Bitzer" wrote:
> Did you make a SQL Server backup of the database by issuing a BACKUP
> DATABASE command?
> What version and service pack are you using?
> You might find the following useful:
> http://support.microsoft.com/default.aspx?scid=kb;EN-US;277843
> http://support.microsoft.com/default.aspx?scid=kb;EN-US;274797
> --
> Bryan Bitzer MCP
> Senior Database Administrator
> Marshall & Swift / Boeckh
> www.msbinfo.com
> "Artmic" <Artmic@.discussions.microsoft.com> wrote in message
> news:2DB5489D-137F-4A40-8122-810E9F80036C@.microsoft.com...
> > Hello Can anyone please tell me how i can attach a database which was not
> > detached from the server previously?
> >
> > right now when i try to use sp_attach_db i get error code 9004 , same
> thing
> > happens in SQL Enterprise manager...
> >
> >
> > I made backup of the 2 datafile/logfile on cd-rom but when i try to attach
> > them after the server hardware failed, i get that weird 9004 error code.
> >
>
>

No comments:

Post a Comment