| Groups | Blog | Home |
sql server new users : Log Shipping - Error
a domain account - rrg-sqlagent which is an administrator on both servers. The initialization of the database works but 15 minutes later when the the log shipping starts to occur i recieve the following errors. does anyone have any idea why? Do both SQLSERVER services need to run under the domain account as well? Thanks, - Gabe Event Type: Error Event Source: MSSQLSERVER Event Category: (2) Event ID: 17052 Date: 1/9/2006 Time: 2:16:00 PM User: RRG\RRG-SQLAGENT Computer: SRVDB1 Description: Error: 14421, Severity: 16, State: 1 The log shipping destination SRVDB2.rims is out of sync by 49 minutes. Event Type: Warning Event Source: SQLSERVERAGENT Event Category: Job Engine Event ID: 208 Date: 1/9/2006 Time: 2:16:00 PM User: N/A Computer: SRVDB1 Description: SQL Server Scheduled Job 'Log Shipping Alert Job - Restore' (0x1D395170F12D324A84AF10E264AF513F) - Status: Failed - Invoked on: 2006-01-09 14:16:00 - Message: The job failed. The Job was invoked by Schedule 286 (Log Shipping Alert Job - Restore). The last step to run was step 1 (Log Shipping Alert Job - Restore). For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
No, they don't. But, the job owner for the backup job must have the
authority to backup the database as well as read/write to the backup share. The job owner for the copy job must have permissions to read/write to the backup share on the primary as well as read/write permissions to the backup share on the secondary. The job owner for the restore job must have permission to read the backup share as well as restore a database. -- Mike Mentor Solid Quality Learning http://www.solidqualitylearning.com [quoted text, click to view] "Gabe Matteson" <gmatteson@nospam.inquery.biz> wrote in message news:%238IXDpVFGHA.3200@tk2msftngp13.phx.gbl... >I have two servers, the sql agent service on both servers are running under >a domain account - rrg-sqlagent which is an administrator on both servers. >The initialization of the database works but 15 minutes later when the the >log shipping starts to occur i recieve the following errors. does anyone >have any idea why? Do both SQLSERVER services need to run under the domain >account as well? Thanks, > - Gabe > Event Type: Error > Event Source: MSSQLSERVER > Event Category: (2) > Event ID: 17052 > Date: 1/9/2006 > Time: 2:16:00 PM > User: RRG\RRG-SQLAGENT > Computer: SRVDB1 > Description: > Error: 14421, Severity: 16, State: 1 > The log shipping destination SRVDB2.rims is out of sync by 49 minutes. > > Event Type: Warning > Event Source: SQLSERVERAGENT > Event Category: Job Engine > Event ID: 208 > Date: 1/9/2006 > Time: 2:16:00 PM > User: N/A > Computer: SRVDB1 > Description: > SQL Server Scheduled Job 'Log Shipping Alert Job - Restore' > (0x1D395170F12D324A84AF10E264AF513F) - Status: Failed - Invoked on: > 2006-01-09 14:16:00 - Message: The job failed. The Job was invoked by > Schedule 286 (Log Shipping Alert Job - Restore). The last step to run was > step 1 (Log Shipping Alert Job - Restore). > > For more information, see Help and Support Center at > http://go.microsoft.com/fwlink/events.asp. > > > > >
It is the SQL Server account on the primary server, not the SQL Agent
account, that must have permissions on the file system. Also, the backup server must have Full Control permissions to the backup share and the underlying NTFS folder. The restore server SQL Service account must have read permissions on the backup share. The job owner still needs correct permissions to backup or restore a database. -- Geoff N. Hiten Senior Database Administrator Microsoft SQL Server MVP [quoted text, click to view] "Michael Hotek" <mike@solidqualitylearning.com> wrote in message news:OfrjmVWFGHA.1312@TK2MSFTNGP09.phx.gbl... > No, they don't. But, the job owner for the backup job must have the > authority to backup the database as well as read/write to the backup > share. The job owner for the copy job must have permissions to read/write > to the backup share on the primary as well as read/write permissions to > the backup share on the secondary. The job owner for the restore job must > have permission to read the backup share as well as restore a database. > > -- > Mike > Mentor > Solid Quality Learning > http://www.solidqualitylearning.com > > > "Gabe Matteson" <gmatteson@nospam.inquery.biz> wrote in message > news:%238IXDpVFGHA.3200@tk2msftngp13.phx.gbl... >>I have two servers, the sql agent service on both servers are running >>under a domain account - rrg-sqlagent which is an administrator on both >>servers. The initialization of the database works but 15 minutes later >>when the the log shipping starts to occur i recieve the following errors. >>does anyone have any idea why? Do both SQLSERVER services need to run >>under the domain account as well? Thanks, >> - Gabe >> Event Type: Error >> Event Source: MSSQLSERVER >> Event Category: (2) >> Event ID: 17052 >> Date: 1/9/2006 >> Time: 2:16:00 PM >> User: RRG\RRG-SQLAGENT >> Computer: SRVDB1 >> Description: >> Error: 14421, Severity: 16, State: 1 >> The log shipping destination SRVDB2.rims is out of sync by 49 minutes. >> >> Event Type: Warning >> Event Source: SQLSERVERAGENT >> Event Category: Job Engine >> Event ID: 208 >> Date: 1/9/2006 >> Time: 2:16:00 PM >> User: N/A >> Computer: SRVDB1 >> Description: >> SQL Server Scheduled Job 'Log Shipping Alert Job - Restore' >> (0x1D395170F12D324A84AF10E264AF513F) - Status: Failed - Invoked on: >> 2006-01-09 14:16:00 - Message: The job failed. The Job was invoked by >> Schedule 286 (Log Shipping Alert Job - Restore). The last step to run >> was step 1 (Log Shipping Alert Job - Restore). >> >> For more information, see Help and Support Center at >> http://go.microsoft.com/fwlink/events.asp. >> >> >> >> >> > >
Thanks. The job owner is a domain admin with server administrator privileges
on the sql server and full permissions to everything on the server yet i still recieve those errors. is there something that i am missing or over looked? thank you. [quoted text, click to view] "Michael Hotek" <mike@solidqualitylearning.com> wrote in message news:OfrjmVWFGHA.1312@TK2MSFTNGP09.phx.gbl... > No, they don't. But, the job owner for the backup job must have the > authority to backup the database as well as read/write to the backup > share. The job owner for the copy job must have permissions to read/write > to the backup share on the primary as well as read/write permissions to > the backup share on the secondary. The job owner for the restore job must > have permission to read the backup share as well as restore a database. > > -- > Mike > Mentor > Solid Quality Learning > http://www.solidqualitylearning.com > > > "Gabe Matteson" <gmatteson@nospam.inquery.biz> wrote in message > news:%238IXDpVFGHA.3200@tk2msftngp13.phx.gbl... >>I have two servers, the sql agent service on both servers are running >>under a domain account - rrg-sqlagent which is an administrator on both >>servers. The initialization of the database works but 15 minutes later >>when the the log shipping starts to occur i recieve the following errors. >>does anyone have any idea why? Do both SQLSERVER services need to run >>under the domain account as well? Thanks, >> - Gabe >> Event Type: Error >> Event Source: MSSQLSERVER >> Event Category: (2) >> Event ID: 17052 >> Date: 1/9/2006 >> Time: 2:16:00 PM >> User: RRG\RRG-SQLAGENT >> Computer: SRVDB1 >> Description: >> Error: 14421, Severity: 16, State: 1 >> The log shipping destination SRVDB2.rims is out of sync by 49 minutes. >> >> Event Type: Warning >> Event Source: SQLSERVERAGENT >> Event Category: Job Engine >> Event ID: 208 >> Date: 1/9/2006 >> Time: 2:16:00 PM >> User: N/A >> Computer: SRVDB1 >> Description: >> SQL Server Scheduled Job 'Log Shipping Alert Job - Restore' >> (0x1D395170F12D324A84AF10E264AF513F) - Status: Failed - Invoked on: >> 2006-01-09 14:16:00 - Message: The job failed. The Job was invoked by >> Schedule 286 (Log Shipping Alert Job - Restore). The last step to run >> was step 1 (Log Shipping Alert Job - Restore). >> >> For more information, see Help and Support Center at >> http://go.microsoft.com/fwlink/events.asp. >> >> >> >> >> > >
Don't see what you're looking for? Try a search.
|
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |