[dba-SQLServer]Re: Help - get db back

John W. Colby jcolby at colbyconsulting.com
Thu Nov 13 16:05:15 CST 2003


Thanks,

John W. Colby
www.colbyconsulting.com

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of Robert
L. Stewart
Sent: Thursday, November 13, 2003 1:12 PM
To: dba-sqlserver at databaseadvisors.com
Cc: jcolby at colbyconsulting.com
Subject: [dba-SQLServer]Re: Help - get db back


John,

In Enterprise Manager
right click on "Databases"
click on attach database
point to the mdf file you want to get loaded

That should work

At 12:01 PM 11/13/2003 -0600, you wrote:
>Date: Thu, 13 Nov 2003 10:27:58 -0500
>From: "John W. Colby" <jcolby at colbyconsulting.com>
>Subject: [dba-SQLServer]Help - get db back
>To: "SQLServer" <dba-sqlserver at databaseadvisors.com>
>Message-ID: <DCEFJAOENMNENLAAOFGPCEMMFKAA.jcolby at colbyconsulting.com>
>Content-Type: text/plain;       charset="iso-8859-1"
>
>Folks,
>
>I had a hard disk decide to disappear occasionally.  Yep, a soft reboot
>would show it completely missing, only a hard boot (power off/on) would
>display it again.  Of course it was my system disk.  In the two days of
>screwing around finding and fixing it, I forgot to back up my SQL Server
>database.  It appears that I was connected to a database out on my data
>disk, and I didn't lose it, but the question is, how do I "attach to" that
>SQL Server database?  It's my billing database and rather critical.
>
>Again, I have the database itself, but it is out in my data directory and I
>need to get SQL Server to open it and let me use it.
>
>Possible?
>
>John W. Colby


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com






More information about the dba-SQLServer mailing list