can you any body tell me suppose database is suspect mode.
how can take to normal?
Answer Posted / praveen.g
1. Firstly look in the SQL Server Logs in Enterprise Manager
(EM). To get there, start EM and drill down from the
Database Server … Management … SQL Server Logs. There
should be multiple logs starting with Current and then
followed by 6 or more archived logs.
2. Review all recent Error Log(s). There WILL be an
indication here as to why the database has been marked
suspect. You need to fix whatever the problem is first
(i.e. missing file, permissions problem, hardware error
etc.)
3. Then, when the problem has been fixed and you're either
sure that the data is going to be ok, or you have no backup
anyway, so you've nothing to lose, then change the database
status to normal and restart SQL Server.
4. To change the database status we will us the following
store procedure: sp_resetstatus.
The steps are as follows:
a. USE master
GO
sp_configure 'allow updates', 1
GO
RECONFIGURE WITH OVERRIDE
GO
b.
sp_resetstatus
GO
-- Example: sp_resetstatus ‘Washington’
5. After the procedure is run, immediately disable updates
to the system tables:
a. sp_configure 'allow updates', 0
GO
RECONFIGURE WITH OVERRIDE
GO
6. Stop and Restart ALL SQL Server Services
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is difference between inner join and join?
What is the recursive stored procedure in sql server?
What is sparse columns of sql server 2008?
What happens if ntwdblib.dll is missing on your machine?
How do you migrate data from mssql server to azure?
How to view existing indexes on an given table using sys.indexes?
What are the different subsets of sql?
What does the on delete cascade option do?
What are character string data types in ms sql server?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
What is exporting and importing utility?
How to list all login names on the ms sql server?
Explain four layers of abstraction microsoft architectured?
What is encryption key?
What is the Main Difference between ACCESS and SQL SERVER?