Log Shipping error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Log Shipping error

Author

Topic

Jason100
Starting Member

34 Posts

Posted - 2009-09-09 : 22:55:42

My log Shipping is error in the last set

Date 9/10/2009 10:45:03 AM
Log Job History (LSRestore_SZALTERNATIVEDB_SecurityData)

Step ID 1
Server SZGADB02
Job Name LSRestore_SZALTERNATIVEDB_SecurityData
Step Name Log shipping restore log job step.
Duration 00:00:01
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: SZGADB02\SQLAgent. The step failed.

Jason100
Starting Member

34 Posts

Posted - 2009-09-09 : 23:20:43

anyone can help me ?

Sitka
Aged Yak Warrior

571 Posts

Posted - 2009-09-10 : 08:52:08

check diskspace,

Look through a firewall's (ISA) conectivity verifier logs
or network monitoring logs for lack of communication to the Domain controller, hot sql server, and warm sql failover server at the time of the Logship step,

what has changed since 09/09?
-new or different SSIS (DTS) package?
-new maintenance plan?
-other IT personnel changing backup routines?

this "SZGADB02" looks like a server name (local machine) rather than a domain. Domain or Network credentials are often used when log shipping.

"it's definitely useless and maybe harmful".

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources