bypass mode

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
Kalyan
did you follow all of the steps listed here?
http://groups.google.com/group/micro...e=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
"Kalyan" <Kalyan@.discussions.microsoft.com> wrote in message
news:FD9CB3DF-315A-4AA7-81B5-88503B9181FF@.microsoft.com...
> 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
> Kalyan