[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 195
  • Last Modified:

SQL Server logshipment

While doing the log shipment, i am getting the attahced error message. What could be the reasong for this?
untitled.JPG
0
salmanfazal
Asked:
salmanfazal
1 Solution
 
sureshchsahuCommented:
Does this message comes when the mode is in standby modeor in recovery.

Try rebooting the secondary server and reran the log shipping set up
0
 
salmanfazalAuthor Commented:
It comes in standby mode. If i do the log shipment 2,3 times, it will work. but its a time consuming for big databases.
0
 
Eugene ZCommented:
can you please tell what is your sql servers version, service pack?

if it is sql server 2000- you need at least sp3a (there is sp4 + 30patches)

if it is sql server 2005 - you would need sp3 ..
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
Eugene ZCommented:
also please tell
when and where from exactly your got the error ?
0
 
salmanfazalAuthor Commented:
I have Sql server 2005, with SP3, Standard Edition.

When i start the transaction log shipping for the database, it stops in between while doing the backup and give the attached error. It usually happens during backup and before copy and restore operation.
0
 
ZberteocCommented:
As I know the log shipping works only with Enterprise Edition:

http://msdn.microsoft.com/en-us/library/aa213785(SQL.80).aspx

"Administering SQL Server (SQL Server 2000)
Log Shipping
In Microsoft® SQL Server™ 2000 Enterprise Edition, you can use log shipping to feed transaction logs from one database to another on a constant basis."
0
 
Eugene ZCommented:
check if there is an unother trans log job running for the same database at same time.

was the error as popup or you see it inside maint plan history?


0
 
salmanfazalAuthor Commented:
Log shipping works with the standard version also. Anyways i did this, this error comes when you are taking the back up over the  remote machine.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now