Note To Self

Copy and Restore Job Errors with Log Shipping

After recent issues with log shipping, specifically, copy and restore jobs failing on the secondary server, I found this post from 2010. Whilst sceptical that the issue would be relevant to mine, 6 years down the track, the error messages and symptoms matched. Trying the fix mentioned in the post by Kirsty (@msDBA) fixed the error perfectly.

https://ms-dba.blogspot.com.au/2010/06/copy-and-restore-job-errors-with-log.html?showComment=1462924100120#c6762197589939254347

I just thought I’d post a link here as I’m sure ill come across it again in another 6 years time.

Advertisements
Categories: Log Shipping, Note To Self, SQL, Uncategorized | Leave a comment

2007 Office System Driver: Data Connectivity Components

This post is more of a note to myself in order to bookmark the Data Connectivity Tools for, in my case, SQL Server installs.

If, for example, you wish to load Excel files with SSIS, your server will require the appropriate drivers, one method to handle this would be to load office onto the server, this is not recommended though for security reasons as it provides an unneeded possible vulnerability, however low and also just means that you have another set of programs to patch as updates are released.

In order to get around this, simply load the free drivers from Microsoft, which are available for download from this address:

http://www.microsoft.com/downloads/en/confirmation.aspx?familyId=7554f536-8c28-4598-9b72-ef94e038c891&displayLang=en

DataConnectivityComponents

Categories: Note To Self, SQL Tools | Tags: , , , | Leave a comment

Blog at WordPress.com.