Results 1 to 4 of 4

Thread: SQL Database Recovery

  1. #1
    Join Date
    May 2003
    Posts
    1

    Unhappy SQL Database Recovery

    I just had to reload my windows 2000 server because of corrupt files. I was able to ghost my data across to another disk. Unfortunately, i lost my database backup files but still have the .mdf and .ldf files. Is there any way of restoring these databases using these files?

  2. #2
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    sp_attach_db

    and

    sp_attach_single_file_db

    refer bol for the above these two commands

  3. #3
    Join Date
    Jan 2003
    Location
    UK
    Posts
    277
    unless you need the ldf file you can just attach the mdf and a new minimum size ldf will be auto created for you.

    A good if unorthodox way of clearing out a massive log file as well. Make sure you don't need anything that may be in it though.

  4. #4
    Join Date
    May 2024
    Posts
    1
    Recovering data from a Windows 2000 server due to corrupt files involves several steps:

    Boot into Safe Mode: Restart the server and press F8 to enter Safe Mode. This can help bypass some issues causing corruption.

    Run Check Disk Utility: Use the command chkdsk /f in the command prompt to check and repair file system errors.

    Use Backup: Restore data from the most recent backup. Windows 2000 servers should have a backup strategy in place.

    Recovery Console: Insert the Windows 2000 installation CD and boot from it. Select the Recovery Console and use commands like fixboot and fixmbr to repair boot-related issues.

    Data Recovery Software: If the above steps fail, use third-party data recovery tools such as Recuva, EaseUS Data Recovery Wizard, or similar software to attempt to recover the files.

    Professional Help: For critical data, consider consulting professional data recovery services.

    Remember to always maintain regular backups to mitigate the risk of data loss.


    **Links removed by Site Administrator so it doesn't look like you're spamming us. Please don't post them again.**

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •