Results 1 to 2 of 2
  1. #1
    rileycollins is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Jun 2015
    Posts
    1

    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
    NoellaG's Avatar
    NoellaG is offline VIP
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,035
    Hi,

    best practice is always to recover from your back-up files. Other methods can be tried when you don't have a good set of back-up files (full/partial/log). First thing I would do now is to set up a good backup/recovery plan for the future.
    https://technet.microsoft.com/en-us/...=sql.105).aspx

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 09-24-2014, 12:12 AM
  2. Replies: 1
    Last Post: 11-10-2013, 08:53 AM
  3. Office 2010, 64 bit crashed
    By gppkuntz in forum Access
    Replies: 2
    Last Post: 12-21-2010, 06:28 PM
  4. Replies: 10
    Last Post: 11-09-2010, 03:34 PM
  5. [Error]Access Crashed Issues
    By ckhaos in forum Security
    Replies: 1
    Last Post: 06-23-2009, 02:08 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums