469,278 Members | 2,368 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,278 developers. It's quick & easy.

SQL Server 2000 - Recover Database using only File System Backup

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!
May 17 '07 #1
2 1724
Motoma
3,237 Expert 2GB
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.
May 17 '07 #2
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

Expand|Select|Wrap|Line Numbers
  1. EXEC sp_resetsatatus [YourDatabase];
  2. ALTER DATABASE [YourDatabase] SET EMERGENCY
  3. DBCC checkdb ([YourDatabase])
  4. ALTER DATABASE [YourDatabase] SET SINGLE USER WITH ROLLBACK IMMEDIATE
  5. DBCC DATABASE [YourDatabase], REPAIR_ALLOW_DATA-LOSS)
  6. ALTER DATABASE [YourDatabase] SET MULTI-USER
Jun 11 '14 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by nt | last post: by
3 posts views Thread by datapro01 | last post: by
reply views Thread by mike_dba | last post: by
3 posts views Thread by Jarosław Kozik | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.