sql server replication: bypass mode -- sql server replication

bypass mode

Kalyan
8/18/2005 1:40:04 PM

sql server replication:

i have setup replication that works fine, after adding some article while
applying changes, my db went to suspect mode,

by running following script

Sp_configure "allow updates", 1
go
Reconfigure with override
GO
Update sysdatabases set status = 32768 where name = 'criticaldevices'
go
Sp_configure "allow updates", 0
go
Reconfigure with override

Sp_configure "allow updates", 1
go
Reconfigure with override
GO
Update sysdatabases set status = 0 where name = 'criticaldevices'
go
Sp_configure "allow updates", 0
go
Reconfigure with override

while starting snopshot agent, i got following error

Could not run BEGIN TRANSACTION in database 'CriticalDevices' because the
database is in bypass recovery mode.

Can anyone help me to solve this issue

thanks

Re: bypass mode

Hilary Cotter
8/18/2005 9:42:58 PM

did you follow all of the steps listed here?

http://groups.google.com/group/microsoft.public.sqlserver.server/msg/16d817500c31713d?dmode=source&hl=en

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]