restore replicated databases

I can't restore trans replicated databases because I get message that they
are in use - do I need to stop agents to get exclusive access - then restore
- then restart agents?
Thanks
yes, stop Sql Server agent, run sp_who2 to identify and kill spids that are
continuing to use the db and then retry your restore.
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
"DrBob" <DrBob@.discussions.microsoft.com> wrote in message
news:F2DC7A4C-D2DB-493B-BBDB-6BBBF95306CE@.microsoft.com...
> I can't restore trans replicated databases because I get message that they
> are in use - do I need to stop agents to get exclusive access - then
restore
> - then restart agents?
> Thanks
|||Thanks
"Hilary Cotter" wrote:

> yes, stop Sql Server agent, run sp_who2 to identify and kill spids that are
> continuing to use the db and then retry your restore.
> --
> 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
> "DrBob" <DrBob@.discussions.microsoft.com> wrote in message
> news:F2DC7A4C-D2DB-493B-BBDB-6BBBF95306CE@.microsoft.com...
> restore
>
>