SQL Database Recovery

[samman]

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?

[MAK]

sp_attach_db

and

sp_attach_single_file_db

refer bol for the above these two commands

[KnooKie]

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.

[jacelynsia]

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.**