Re: Hard drive crashed but MDF/LDF on drive D:
From: Olu Adedeji (i-oluade_at_microsoft.com)
Date: 01/11/05
- Next message: Olu Adedeji: "Re: Scheduled Tasks for SQL 7.0"
- Previous message: Richard: "Stored procedure is exiting during OpenDatasource() call"
- In reply to: Don: "Hard drive crashed but MDF/LDF on drive D:"
- Next in thread: Andrew J. Kelly: "Re: Hard drive crashed but MDF/LDF on drive D:"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 11 Jan 2005 23:54:07 -0000
with SQL7 and/or SQL 2000
you can try sp_attach_db
PS. usually better to perform sp_detach_db but you had no choice in this
instance :-)
hope this works.
"Don" <anonymous@discussions.microsoft.com> wrote in message
news:086001c4f832$20813b50$a601280a@phx.gbl...
> SQL 7.0/Server 2000
>
> The c: drive crashed;
>
> the MDF and LDF files were on drive D:
>
> When a new hard drive is installed with the new OS and
> SQL 7.0 installed on it...is there a way to "attach" to
> the MDF and LDF files? or are they lost?
>
> Thanks,
> Don
>
>
- Next message: Olu Adedeji: "Re: Scheduled Tasks for SQL 7.0"
- Previous message: Richard: "Stored procedure is exiting during OpenDatasource() call"
- In reply to: Don: "Hard drive crashed but MDF/LDF on drive D:"
- Next in thread: Andrew J. Kelly: "Re: Hard drive crashed but MDF/LDF on drive D:"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
