Database Suspect
in [Server Configuration]
|
From: David on 29 May 2010 01:59 To resolve the above problem, the user can use an inbuilt tool named sp_resetstatus. This tool enables the user to change the SQL database status and access the SQL database again. But in this case, this inbuilt tool will not be able to resolve the issue. This tool will only allow the you to connect to the SQL Server instances and will let you access other databases. To resolve the above error message and perform complete sql database recovery, you need to use a third party application known as SQL Recovery software. You can download it from http://www.mssqldatabaserecovery.com/download-sql-database-recovery-software.php PIT wrote: Database Suspect 19-Nov-09 Hi at all My database has been defined as marked suspect. How can i restore it? I tried to restart sql server service, dbcc checkdb repair_rebuild, alter db to emergency, sp_resetstatus etc... nothing!!! noone succeeded!!! alway the error is "db cannot be opend the db is marcked as suspect by recovery" (a phrase similar) and there are no error in the Error Log! so i do not want to lost my data and unfortunately i have no backup My data are losted forever? Any suggestion is welcome Thank you at all Pit Previous Posts In This Thread: On Thursday, November 19, 2009 3:50 PM PIT wrote: Database Suspect Hi at all My database has been defined as marked suspect. How can i restore it? I tried to restart sql server service, dbcc checkdb repair_rebuild, alter db to emergency, sp_resetstatus etc... nothing!!! noone succeeded!!! alway the error is "db cannot be opend the db is marcked as suspect by recovery" (a phrase similar) and there are no error in the Error Log! so i do not want to lost my data and unfortunately i have no backup My data are losted forever? Any suggestion is welcome Thank you at all Pit On Thursday, November 19, 2009 4:43 PM Geoff N. Hiten wrote: You need to determine why the database is suspect before trying to fix it. You need to determine why the database is suspect before trying to fix it. The most likely cause is one or more data files are missing. Is there a storage susbsystem that is not showing up on the host computer? Did somebody delete, rename, or move the files. Is there a permission problem. You should be able to look in the Windows Application Event log and discover where things went wrong. Depending on the actual problem, you might be able to recove with no data loss. Other problems will require you to go back to your latest backup. -- Geoff N. Hiten Principal SQL Infrastructure Consultant Microsoft SQL Server MVP On Monday, November 23, 2009 10:39 AM Dmitry K. wrote: dbHi Pit,I believe that the easiest way of database recovery implies the db Hi Pit, I believe that the easiest way of database recovery implies the usage of third party recovery applications. For example, you may try the reparation sql utility that can be found here: http://www.recoverytoolbox.com/export_data_from_emergency_database_in_sql_2= 008.html. Of course, there are some similar services, please let me know if you know something about it, so we can discuss the problem Submitted via EggHeadCafe - Software Developer Portal of Choice BOOK REVIEW: Effective C#, Second Edition [Addison Wesley] http://www.eggheadcafe.com/tutorials/aspnet/b2f8766d-a4c1-4d5a-97af-c38852b3b455/book-review-effective-c.aspx
|
Pages: 1 Prev: SQL Server 2005 Agent Will Not Start Next: remote backup in local drive |