Re: Log shipping: When Standby server fails, will primary continue?
From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 05/15/03
- Next message: Dave: "File Permissions for BCP job"
- Previous message: Jasper Smith: "Re: Integrated security -whose credentials are used?"
- In reply to: Torben Gissel: "Log shipping: When Standby server fails, will primary continue?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 15 May 2003 19:46:46 +0100
The primary server will be fine. I don't tend to use the built
in log shipping as I have my own but I'd guess if there are
jobs on the primary that copy the logs across to the secondary
then the copy step will fail but this should have no impact on the
primary (except you might end up with more logs than usual so
disk space could be a factor)
-- HTH Jasper Smith (SQL Server MVP) I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Torben Gissel" <tog@gammapartner.dk> wrote in message news:069301c31aec$fa64cd20$a001280a@phx.gbl... > Hello, > > We are about to set up a log shipping solution using SQL > Server Enterprise on two seperate servers. > > I need to know what will happen with the primary server if > the secondary for some reason should fail (server crash, > network failure, or other). Will the primary server then > continue its operation uninterrupted, or what will happen? > > Any links on the web to resources would be nice. > > Thanks for helping. > > Torben
- Next message: Dave: "File Permissions for BCP job"
- Previous message: Jasper Smith: "Re: Integrated security -whose credentials are used?"
- In reply to: Torben Gissel: "Log shipping: When Standby server fails, will primary continue?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
