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.
| Author |
Topic |
|
rushdib
Yak Posting Veteran
93 Posts |
 Posted - 2003-09-12 : 08:56:48
|
| Hi,This doesn't happen all the time, but sometimes the distribution database or other databases remian in 'suspect' mode, which hides all the objects in that database and hides all the replication items or links. Our current resolution is stopping the server and the agents and restarting them.Can someone please tell me why is it happenning?Thank you,Rushdi Basir |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2003-09-19 : 07:49:05
|
| Have you checked the disk space available?.Also, you don't have to restart your server, you can use sp_resetstatus & DBCC DBRecover to reset and recover the database.HTHSekar~~~~Success is not a destination that you ever reach. Success is the quality of your journey. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-19 : 12:26:03
|
| You need to figure out why your database is going into suspect mode. Rebooting the server is only temporarily correcting the problem. You need to check if you have any hardware problems, which is a main cause of this problem. Check the Event Log and any other logs that you might have. Also, instead of rebooting, run sp_resetstatus as Sekar mentioned. There isn't any way for us to know why your database is going into suspect mode. We would need to see all of the logs and do some analysis. Do you have a server administrator that can look into the problem?Tara |
|
|
|
rushdib
Yak Posting Veteran
93 Posts |
Posted - 2003-09-19 : 14:08:40
|
| Well, our IT is small. We have started out with SQL Server about a year ago converting Access databases. So we are more in the learning phase. We have 1 network admin. There 4 instances of SQL Sever and uses Transactional and merge replications among servers.I will ask the network admin to look into logs and the server.Thanks,Rushdi |
|
|
|
|
|
|
Replication issue - Database in suspect mode