Interested to Buy Any Domain ? << Click Here >> for more details...
can you any body tell me suppose database is suspect mode.
how can take to normal?
- 2 Answers
- 6393 Views
- Teledata, I also Faced
- E-Mail Answers
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
Do you know the policy based administration feature of sql server 2008?
Can we check locks in database? If so, how can we do this lock check?
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
Explain in details security in SQL azure?
What is order of B+tree?
Which is faster statement or preparedstatement?
What is the name of the system variable that returns the number of rows affected by a SQL statement?
What are rest-style architecture's?
What is the maximum number of index per table?
What are the different types of triggers in SQL SERVER?
What is meant by datasource?
how to do partition in sqlserver
Define left outer join in sql server joins?
what is a deadlock? : Sql server database administration
How do clustered indexes store data?
