can you any body tell me suppose database is suspect mode.
how can take to normal?

Answer Posted / kumar.t

EXEC sp_resetstatus 'database name'

By
Kumar.T

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between left and right outer join?

540


How can I get data from a database on another server?

507


Can I delete event logs?

541


Differentiate between ms sql server reporting services vs crystal reports?

485


What is extent? Types of extents?

587






What are the advantages of policy management?

582


Why we need sql server?

552


What is the fillfactor concept in indexes?

528


what's new in sql server 2016?

555


How to recreate an existing index in ms sql server?

544


How to add code to the existing article (using improve article)?

587


What is index, cluster index and nonclustered index?

512


How to create view in stored procedure sql server?

501


Is the log file is a part of file group?

548


How to drop existing views from a database in ms sql server?

528