Recover a database?

#1

I messed up SQL Server 2000 by inadvertently deleting some files. So I
uninstalled and reinstalled it. And I assumed that this blew away my databases.

But alas my database files are where I left them, the MDF and LDF files. Yet
the databases now don't show up in Enterprise Manager.

So how do I put them back into Enterprise Manager? I tried a few thing but got
error messages.

Thanks for your help.

#2

Bruce,

Since you have the mdf and ldf files, try attaching the database(s) back by
doing sp_attach_db.Though a prerequisite is that, the database should be
properly detached , it may sometimes work.

--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com

"Bruce W...1" <bruce (AT) noDirectEmail (DOT) com> wrote

Quote:

I messed up SQL Server 2000 by inadvertently deleting some files. So I
uninstalled and reinstalled it. And I assumed that this blew away my
databases.

But alas my database files are where I left them, the MDF and LDF files.
Yet
the databases now don't show up in Enterprise Manager.

So how do I put them back into Enterprise Manager? I tried a few thing
but got
error messages.

Thanks for your help.

#3

"Dinesh.T.K" wrote:

Quote:

Bruce,

Since you have the mdf and ldf files, try attaching the database(s) back by
doing sp_attach_db.Though a prerequisite is that, the database should be
properly detached , it may sometimes work.

--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com

"Bruce W...1" <bruce (AT) noDirectEmail (DOT) com> wrote in message
news:3F68905E.1AD1A01A (AT) noDirectEmail (DOT) com...
I messed up SQL Server 2000 by inadvertently deleting some files. So I
uninstalled and reinstalled it. And I assumed that this blew away my
databases.

But alas my database files are where I left them, the MDF and LDF files.
Yet
the databases now don't show up in Enterprise Manager.

So how do I put them back into Enterprise Manager? I tried a few thing
but got
error messages.

Thanks for your help.

================================================== =========

Not sure exactly what you mean. Looks like a stored procedure. Anyway, attach
is the key word I was looking for. Was able to attach the files, after browsing
to it. Thanks.

#4

Bruce,

Yes, sp_attach_db is a system stored procedure used to attach the database
files.You must have performed the corresponding action in the gui.

--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com

"Bruce W...1" <bruce (AT) noDirectEmail (DOT) com> wrote

Quote:

"Dinesh.T.K" wrote:

Bruce,

Since you have the mdf and ldf files, try attaching the database(s) back
by
doing sp_attach_db.Though a prerequisite is that, the database should be
properly detached , it may sometimes work.

--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com

"Bruce W...1" <bruce (AT) noDirectEmail (DOT) com> wrote in message
news:3F68905E.1AD1A01A (AT) noDirectEmail (DOT) com...
I messed up SQL Server 2000 by inadvertently deleting some files. So
I
uninstalled and reinstalled it. And I assumed that this blew away my
databases.

But alas my database files are where I left them, the MDF and LDF
files.
Yet
the databases now don't show up in Enterprise Manager.

So how do I put them back into Enterprise Manager? I tried a few
thing
but got
error messages.

Thanks for your help.

================================================== =========

Not sure exactly what you mean. Looks like a stored procedure. Anyway,
attach
is the key word I was looking for. Was able to attach the files, after
browsing
to it. Thanks.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Recover a database?

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Recover a database? - 09-17-2003 , 11:48 AM

Re: Recover a database? - 09-17-2003 , 11:59 AM

Re: Recover a database? - 09-17-2003 , 03:10 PM

Re: Recover a database? - 09-17-2003 , 03:14 PM