Printable View
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?
sp_attach_db
and
sp_attach_single_file_db
refer bol for the above these two commands
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.
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.**