Search for questions :
My Profile
Categories

Marcdel

Open Question Bookmark and Share

Want to get repair SQL Database, Help needed!! ?

I have SQL Server 2000 in my system. Now on opening it I found that SQL Server 2000 master database has been marked as suspect. This is a type of test server that has been mirrored from a production server. Right now on using it a test server it cannot save DTS package in SQL 2000 and even it’s not getting opened in SQL2005. Is their any simple way to repair the suspect database? Can DTS packages be saved in SQL2000 and on need opened in SQL2005 also?

724 day ago

    Comment(s) (0)
    Report Abuse
   Find Intereseting  
   E-Mail to Friends  
   Bookmark  
   Subscribe to Answer Alert  
No comments yet !!!     Be the first to comment
Answers (2)

tanvi 		Many software available in market to repair SQL Database. but I heard about Stellar Phoenix <a href="http://www.mssqldatabaserecovery.com/">SQL Recovery</a> Software.It is good software.You can also download its demo version and check how much data repaired by this software.

Posted 544 days ago

( 0 )
( 0 )
    Comment(s) (0)
   Report Abuse
No comments yet !!! Be the first to comment on this answer !!!


Stefen 		Before considering your point, I would like to know that whether you had made any backup of your system database. By making any changes if you got your database lost than you will certainly have a backup copy. Otherwise the ms sql database repair can also be used to get back the lost data if there is such case of deletion of files. Or any other suggestions can work out too.
So get your all database saved before making any changes. Same SQL Database can run in both the versions of SQL 2000 and 2005. I had also used the same database in both versions and this has well worked out. You can better collect information about these test servers and production servers.



Posted 724 days ago

( 0 )
( 0 )
    Comment(s) (0)
   Report Abuse
No comments yet !!! Be the first to comment on this answer !!!

Email this question link to friends
You must enter email-address, if name is entered and vice-versa for each friend.
Friend #1 -
Friend #2 -
Friend #3 -
Friend #4 -
Friend #5 -
  Your comment on this question
Max Allowed : 5000 Characters Current Count : 0
  Your comment on this answer
Max Allowed : 5000 Characters Current Count : 0