#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2015
    Posts
    1
    Rep Power
    0

    My SQL2000 server crashed


    My SQL2000 server crashed, and I was able to recover the data and log files. I had to reinstall from scratch after that. I found that I can use the sp_attach_db procedure to create databases on the new server from the data and log files. That recovery procedure worked, at least so far. But it's left me with a lot of questions. Is this a valid recovery? Will I be missing data, other than the obvious uncommitted transactions? Why isn't this documented as a recovery procedure? The BOL on sp_attach_db says it should only be used after a detach, which wasn't the case here. If this works, why bother with traditional backups at all? Why not just back up the live data files?
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2015
    Posts
    1
    Rep Power
    0
    Data changes are guaranteed to be written to the transaction log, but the data pages may still be held in cache. If every transaction had to write affected pages to disk on commit, the disk throughput and cache turnover would be so high that the database would be very slow indeed. The fact that the transaction changes are recorded in the transaction log means that a transaction can always be rolled back if necessary, even if the server crashes. This is why the transaction log is always scanned for transaction to be rolled back / rolled forward on server startup before a database is brought online.
    You may try read thes, it is a professional data recovery software.
    Here is page: techrepublic.com/forums/questions/how-to-fix-mdf-file/
  4. #3
  5. Banned ;)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Nov 2001
    Location
    Woodland Hills, Los Angeles County, California, USA
    Posts
    9,782
    Rep Power
    4302
    Interesting.... the above two users registered one after another and are posting from the same location. Buyer beware.
    Up the Irons
    What Would Jimi Do? Smash amps. Burn guitar. Take the groupies home.
    "Death Before Dishonour, my Friends!!" - Bruce D ickinson, Iron Maiden Aug 20, 2005 @ OzzFest
    Down with Sharon Osbourne

    "I wouldn't hire a butcher to fix my car. I also wouldn't hire a marketing firm to build my website." - Nilpo

IMN logo majestic logo threadwatch logo seochat tools logo