<div>
Hi,<br />
<br />
Did you ever run DBCC CHECKDB on your database. If you did what is output, and if you did not you should IMMEDIATELY and send the results.<br />
<br />
Luck.
</div>


Hi,

Did you ever run DBCC CHECKDB on your database. If you did what is output, and if you did not you should IMMEDIATELY and send the results.

Luck.

<div>
It sounds like everytime you are dumping your database, and preparing to load it, you are not clearing your transaction log as well. &nbsp;Databases are marked suspect, when they are unable to rollforward or back a transaction that is in the transaction logs. &nbsp;<br />
I would suggest running a DBCC on the database where you are dumping it from and looking for possible corruption.<br />
Also, be sure dump the transaction log prior to dumping the database, making sure there are no open transactions at the time.
</div>


It sounds like everytime you are dumping your database, and preparing to load it, you are not clearing your transaction log as well.  Databases are marked suspect, when they are unable to rollforward or back a transaction that is in the transaction logs.  
I would suggest running a DBCC on the database where you are dumping it from and looking for possible corruption.
Also, be sure dump the transaction log prior to dumping the database, making sure there are no open transactions at the time.

<div>
<div class="content wysiwyg-content">
i've a question to seek for assistance,<br />
what is the cause that our database is always marks as suspect or loading, which everytime we have to reset the status.<br />
for your information, we do a lot of dump and load, is that the cause of this problem !<br />
we need to avoid this serious problem as soon as possible !<br />
<br />
tks !<br />
&nbsp;
</div>
</div>


i've a question to seek for assistance,
what is the cause that our database is always marks as suspect or loading, which everytime we have to reset the status.
for your information, we do a lot of dump and load, is that the cause of this problem !
we need to avoid this serious problem as soon as possible !

tks !
 

database marked suspect or loading

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.