SQL Server 2000 - Recover Database using only File System Backup

[JeanGreyRedd]

Hi!

Just recently OS (Windows 2003 Server) of our server crashed and needed to be re-installed. Unfortunately, we we not able to create a backup of the databases using the ENTERPRISE MANAGER. HOwever, we have managed to backup the file system of the server (Drives C, D and E)

Is there a way that I can recover the databases using only the file system backup? What steps should i take? Hope you will be able to answer my query ASAP.

Thanks alot!

[Motoma]

Hi!

Just recently OS (Windows 2003 Server) of our server crashed and needed to be re-installed. Unfortunately, we we not able to create a backup of the databases using the ENTERPRISE MANAGER. HOwever, we have managed to backup the file system of the server (Drives C, D and E)

Is there a way that I can recover the databases using only the file system backup? What steps should i take? Hope you will be able to answer my query ASAP.

Thanks alot!

You may be able to restore from the MDF and LDF files, by creating a new database, and replacing those files. There may be a simpler solution, and I do not know if this method will even work.

[sariftustu]

You need any solution to repair and recover SQL server with the help this forum post it is very helpful try ti.: http://www.bubblews.com/news/3733174...erver-database

and second option is also here if you want try

EXEC sp_resetsatatus [YourDatabase];
ALTER DATABASE [YourDatabase] SET EMERGENCY
DBCC checkdb ([YourDatabase])
ALTER DATABASE [YourDatabase] SET SINGLE USER WITH ROLLBACK IMMEDIATE
DBCC DATABASE [YourDatabase], REPAIR_ALLOW_DATA-LOSS)
ALTER DATABASE [YourDatabase] SET MULTI-USER