SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Log Shipping exe location


Log Shipping exe location

Author
Message
SQLSACT
SQLSACT
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2102 Visits: 2931
Hi All

Environment: 2 Node Cluster, Win2008 Ent, SQL 2008 Sp3 Ent

Log Shipping was always working fine, even after failover between nodes.

After the last failover, the backup job started failing with error "Log Shipping job failed with error: The process could not be created for step 1"

I checked the step properties of the backup job and it seems that the path to the sqllogship.exe has changed in the job.

Why would this happen?

We don't use the usual C: drive for our installations.

Up until now, the location always reflected in the job step properties as "h:\Services\Microsoft SQL Server\100\Tools\Binn\sqllogship.exe". Now it shows as "C:\Services\Microsoft SQL Server\100\Tools\Binn\sqllogship.exe"

Any Ideas why this happened?

Thanks
Perry Whittle
Perry Whittle
SSC-Insane
SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)

Group: General Forum Members
Points: 20036 Visits: 17244
what is the exact version of your sql server instance?

There was a small bug with the shared tools install on a cluster, you would install the new instance on the first node and set the tools install location to H:\whatever
Subsequent add node installs however would use the default of the c drive, I believe this may be what you are experiencing

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" ;-)
SQLSACT
SQLSACT
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2102 Visits: 2931
Perry Whittle (1/2/2013)
what is the exact version of your sql server instance?

There was a small bug with the shared tools install on a cluster, you would install the new instance on the first node and set the tools install location to H:\whatever
Subsequent add node installs however would use the default of the c drive, I believe this may be what you are experiencing


Thanks

SQL 2008 Service Pack 3 (10.0.5500)

I am aware of that bug, it's been pointed out at http://connect.microsoft.com/SQLServer/feedback/details/559435/log-shipping-stops-working-on-clustered-instance-if-failed-over-to-another-node

My situation is a bit different.

We have always used H:\whatever as our installation folder and we have failed over between nodes a few times, with no issues. The sqllogship.exe location always reflected as H:\whatever in the Job Step properties and it always worked after failover.

After our last failover, SQL has replaced the sqllogship.exe location in the Job Step properties from H:\whatever
to c:\program files\microsoft sql server\100\tools\binn

In our case, the H: drive is not Clustered and is local to both nodes.

Thanks
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search