Showing posts with label requirement. Show all posts
Showing posts with label requirement. Show all posts

Monday, March 12, 2012

Log File Backup and Log Shipping

Dear All,
We currently back up our log file every 10 minutes.
We now have a requirement to implement log shipping. My question however is
will this effect out Log File Backup, such that together they will not work
correctly ?Log shipping will include ( and become, and replace ) your log backup.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Patricia" <Patricia@.discussions.microsoft.com> wrote in message
news:1512FBDF-8A4B-4FF8-9092-5C2DBC377EC1@.microsoft.com...
> Dear All,
> We currently back up our log file every 10 minutes.
> We now have a requirement to implement log shipping. My question however
> is
> will this effect out Log File Backup, such that together they will not
> work
> correctly ?
>
>|||Thanks Wayne,
I guess we will not put it in then, we want to keep both a current copy and
point in time backup.
Thanks for your help
J
"Wayne Snyder" wrote:

> Log shipping will include ( and become, and replace ) your log backup.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Patricia" <Patricia@.discussions.microsoft.com> wrote in message
> news:1512FBDF-8A4B-4FF8-9092-5C2DBC377EC1@.microsoft.com...
>
>