Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Log Shipping - Error

0 views
Skip to first unread message

Gabe Matteson

unread,
Jan 9, 2006, 3:26:37 PM1/9/06
to
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.

Michael Hotek

unread,
Jan 9, 2006, 4:40:53 PM1/9/06
to
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" <gmat...@nospam.inquery.biz> wrote in message
news:%238IXDpV...@tk2msftngp13.phx.gbl...

Gabe Matteson

unread,
Jan 9, 2006, 5:05:10 PM1/9/06
to
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.

"Michael Hotek" <mi...@solidqualitylearning.com> wrote in message
news:OfrjmVWF...@TK2MSFTNGP09.phx.gbl...

Geoff N. Hiten

unread,
Jan 9, 2006, 4:59:58 PM1/9/06
to
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

"Michael Hotek" <mi...@solidqualitylearning.com> wrote in message
news:OfrjmVWF...@TK2MSFTNGP09.phx.gbl...

0 new messages