Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 SQL SERVER 2008 Database Suspect Mode Reasons

Author  Topic 

prashant_akerkar
Starting Member

5 Posts

Posted - 2010-06-11 : 07:03:58
1.

I want to know all possible reasons for Particular Database/s within SQL SERVER 2008 ENGINE going in suspect mode.

2. When the database goes into suspect mode will there be transaction commit ?

i.e I executed insert records through Stored Procedure/s from my web application when the database was in suspect mode.


1. whether records will be inserted in the application database ?
2. whether records inserted in the application database can be corrupted data ?
3. whether records will not be inserted and my web application will throw "Could not connect to Database" error ?

Thanks & Regards,
Prashant S Akerkar

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-06-11 : 07:33:04
Asked and answered: http://www.sqlservercentral.com/Forums/Topic935838-266-1.aspx

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -