Re: Help Crash!!

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 08/03/04 

Date: Tue, 3 Aug 2004 17:15:53 +0200

Read about sp_attach_db and sp_attach_single_file_db in Books Online. These are only guaranteed to work if you
properly detached the databases first. But if you are lucky... 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"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: If I did not have bad luck, I would have no luck at all
    ... do a "good" thing - backups! ... I somehow lost 340GB of space on the drive. ... reconfigure it without too much trouble and use the entire drive. ... I have called Recover Your Files and was able to recover over 32,000 files. ...
    (alt.support.chronic-pain)
  • Re: Backing up to hard disk - how large?
    ... > "Kevin Weilbacher" wrote in message ... >> As far as backups to recover a particular file, ... >> tape or disk backup! ... >>> several backups from successives days in case someone needs to ...
    (microsoft.public.backoffice.smallbiz2000)
  • RE: i just did a rm -rf /*r as root!!!
    ... > Boot from the install CD and go into Recovery mode. ... If you have backups, then the steps enough will get you enough to boot. ... >>i was hopeful that using the recover cd might provide a solution.... ... >>There are some very expensive disk recover companies out ...
    (RedHat)
  • Re: ADRDSSU protection [was:RE: Using FTP to send loadlib]
    ... The nature of our environment is such that in the unlikely event of a data-center-wide disaster we are not legally required to have near-continuous availability and zero transaction loss, and for the most part our corporate end users could re-enter critical data from primary documents and accept that some server platforms and applications might not be fully functional for up to 48hrs. ... All application tapes are on duplexed virtual tapes with a vault copy. ... The physical volume backups are made over the next several hours, and this is all coordinated with the tape library run to insure that all duplex HSM and VTape physical tapes relevant to the system status at the daily point-in-time backups make it to the vault with the daily DR dumps. ... This gives us assurance that we have off site everything that would have been accessible to all applications as of that point in time and can recover to that point. ...
    (bit.listserv.ibm-main)
  • Re: Recovering Data on a Failing Hard Drive
    ... I've spent the weekend since trying ot recover what data I can. ... The first thing I should address is the issue of backups. ... When I boot it up as a Slave, I can boot into XP from the other hard ... partition was completly unavailable. ...
    (alt.comp.hardware.pc-homebuilt)