SQL

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

Project Perfmon

I recently came across this great poster from the good people at Quest. It provides a huge list of all the relevant Performance Monitor metrics that you should be looking at along with what they mean and what values you should be looking out for.

PerfMonPosterThumb

I duly printed this off on a nice A3 page, started perusing and then realised that i would really need to work up examples for each of the Counters if i was to truly understand them. Thus the Perfmon Project idea was born, i thought, what better way to learn them all than to work through them, top to bottom, left to right and blog my findings.

Please note, this is in no way an attempt to plagiarise the great work from quest or by the authors, it is an effort by me to understand each of these items and build a worked example that i can refer back to at a later date. In each case i will ensure that i fully reference any resources/blogs/pages that i have used to come up with my interpretation. Lets look at it as standing on their shoulders to enjoy the view 🙂

For your own copy, head over to Quest and if you have a spare moment be sure to check out Kevin Klines Blog and dont forget to follow him on twitter

My plan is to post a new item every three weeks or so, as i want to fully understand the material instead of just pumping out posts…..so, on with the project.

In case anyone is wondering, I have contacted Kevin about this project idea and he is more than happy for me to use the poster in posts, thanks Kevin.

Categories: Performance Monitor, SQL | Tags: , , | Leave a comment

A Storm is brewing, no wait, its SQL in the cloud

SQL Data Services (SDS) has been available as a cloud service but until now we have been told it is NOT SQL Server in the cloud and is not to be seen as a RDBMS. There has since been a big change to that with the announcement that SDS will be enchanced with TDS, yay another TLA, TDS = Tabular Data Stream, or, a full RBBMS in the cloud.

The SQL Data Services Team blog lists, among other features:
Tables?…Check

Stored Procedures?…Check

Triggers?…Check

Views?…Check

Indexes?…Check

Visual Studio Compatibility?…Check

ADO.Net Compatibility?…Check

ODBC Compatibility?…Check

so there we have it, apparently you can just point your connection string towards the gathering clouds and thats it. Time to run a demo on this i think, coming soon….

The full announcment is available here .

Categories: SDS, SQL, SQL in the cloud, Tabular Data Stream, TDS | Tags: , , , , | Leave a comment

Blog at WordPress.com.