Re: Help Crash!!

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Mike Epprecht \(SQL MVP\) (mike_at_epprecht.net)
Date: 08/03/04 

Date: Tue, 3 Aug 2004 17:18:51 +0200

Copy the LDF and MDF files onto another computer with SQ Lon it and then run
sp_attach_db to attach each DB. 

-- 
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Johannesburg, South Africa
Mobile: +27-82-552-0268
IM: mike@epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Bradley M. Small" <BSmall@XNOSPAMXmjsi.com> wrote in message
news:OcvkKvWeEHA.732@tk2msftngp13.phx.gbl...
> Computer crashed quite severely, was able to recover the C:\MSSQL7\Data
> directory with all of the MDF and LDF files in it for the databases.
Backups
> directory was completely lost and as I understand it there are no outside
> copies of backups. How if it is at all possible does one get these mounted
> in such a way that they can be recovered in a new machine?
>
>

Relevant Pages

  • Re: recover a database on win2003
    ... >history files is selected. ... my ldf and mdf files are gone and i can't ... is there anyway i can recover the ...
    (microsoft.public.sqlserver)
  • Re: Restore of DB
    ... I think the .ldf and .mdf files would be on a different ... C coz of some issues and Installed the SQL Server again. ... >there a way to recreate the DB, ...
    (microsoft.public.sqlserver.server)
  • setting up a database in msde
    ... installed MSDE 2000. ... supposed to do more than copy the .ldf and .mdf files onto the hard drive. ... Was I supposed to somehow register those files with SQL Server? ...
    (microsoft.public.sqlserver.msde)
  • register database
    ... installed MSDE 2000. ... supposed to do more than copy the .ldf and .mdf files onto the hard drive. ... Was I supposed to somehow register those files with SQL Server? ...
    (microsoft.public.sqlserver.server)
  • setting up a database in msde
    ... installed MSDE 2000. ... supposed to do more than copy the .ldf and .mdf files onto the hard drive. ... Was I supposed to somehow register those files with SQL Server? ...
    (microsoft.public.sqlserver.tools)