I have two sql servers, one is replicating to the other using log shipping.
The backup directory got deleted.
Now replication says it is working, but I don't know how because the .trn
files are not being generated.
What do I have to do to get that started again?
Scott EmickScott,
Repliction is not the same as log shipping. If you are replicating, the
process can continue without transaction logs, but your publisher db will
increase in size if it is not in SIMPLE recovery model and you are not
taking transaction log backups.
Hope this helps,
Ron
--
Ron Talmage
SQL Server MVP
"Scott Emick" <semick@.ham.phoenix-sys.com> wrote in message
news:OolQXwu$DHA.1212@.TK2MSFTNGP12.phx.gbl...
> I have two sql servers, one is replicating to the other using log
shipping.
> The backup directory got deleted.
> Now replication says it is working, but I don't know how because the .trn
> files are not being generated.
> What do I have to do to get that started again?
> Scott Emick
>|||I did flip all the db's from FULL to simple, and back again, but I
still get no .trn files. I was trying to read about backups and maint
plans yesterday, but I haven't gotten anywhere yet. Yes, the
replication is still working, and I am glad of that, but I would like
to get things back to the way they were.
Scott
"Ron Talmage" <rtalmage@.prospice.com> wrote in message news:<#qyZTf1$DHA.1844@.TK2MSFTNGP11.
phx.gbl>...
> Scott,
> Repliction is not the same as log shipping. If you are replicating, the
> process can continue without transaction logs, but your publisher db will
> increase in size if it is not in SIMPLE recovery model and you are not
> taking transaction log backups.
> Hope this helps,
> Ron
> --
> Ron Talmage
> SQL Server MVP
> "Scott Emick" <semick@.ham.phoenix-sys.com> wrote in message
> news:OolQXwu$DHA.1212@.TK2MSFTNGP12.phx.gbl...
> shipping.|||Also, restarted sql server agent and the maint plans...Apparently one was
hung and I did not know it...
Scott
"Scott Emick" <semick@.msn.com> wrote in message
news:a2794831.0403020315.1c3ad442@.posting.google.com...
> I did flip all the db's from FULL to simple, and back again, but I
> still get no .trn files. I was trying to read about backups and maint
> plans yesterday, but I haven't gotten anywhere yet. Yes, the
> replication is still working, and I am glad of that, but I would like
> to get things back to the way they were.
> Scott
> "Ron Talmage" <rtalmage@.prospice.com> wrote in message
news:<#qyZTf1$DHA.1844@.TK2MSFTNGP11.phx.gbl>...
will
No comments:
Post a Comment