Archive | July, 2012

In praise of pens, pencils and paper

Even in these days of Netbooks, Tablets and Evernote I still find that a simple pad of paper and a basic pen or pencil is a vital thing to carry round.

Ultra simple to carry everywhere, even when going ultralight. Easy to replace if you do manage to misplace or forget them, I can certainly think of more places with 300m of this desk that I can pick them up from than I can tablet sellers. And most of them will be selling it for less than the cost of an App, let alone the device.

As a follower of “Getting Things Done” I find dumping all the ideas out onto paper a much quicker way of working. Just turning over the page or grabbing another sheet off the stack is always faster than saving a note and starting a new one. It also just lets you flow as you go. And if you suddenly find you need to mind map or brainstorm something there’s no panic about which app to use, maybe just whether to grab a larger sheet or not.

Yes, there’ll be a little overhead later when it needs transcribing. But you could always just photograph it with a SmartPhone and upload it, or invest in a scanner and some OCR software. In fact I find this a useful way of making sure I only take onboard the pertinent actions following a meeting, by going through each page of the notebook I just snap the ones I need and send them up to Evernote. Job Done.

Suddenly find yourself needing to sketch a schema diagram or an new proposed infrastructure architecture? No problems with pencil and paper.

 

Stuart Moore

Stuart Moore

Nottingham based IT professional with over 15 years in the industry. Specialising in SQL Server, Infrastructure design, Disaster Recovery and Service Continuity management. Now happily probing the options the cloud provides

When not in front of a computer, is most likely to be found on the saddle of his bike

More Posts - Website

Follow Me:
TwitterLinkedInGoogle Plus

Stuart Moore

About Stuart Moore

Nottingham based IT professional with over 15 years in the industry. Specialising in SQL Server, Infrastructure design, Disaster Recovery and Service Continuity management. Now happily probing the options the cloud provides

When not in front of a computer, is most likely to be found on the saddle of his bike

Problems migrating and upgrading SQL Server Reporting Services DBs

Ever upgaded a SQL Server Reporting Services instance after migrating to a new SQL Server, and everything looks good until you click on the Report Server URL to be greeted with:

The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is ‘C.0.8.54’. The expected version is ‘147’. (rsInvalidReportServerDatabase)

You dillegently read through all the google and bing results you can find. But there’s nothing useful in there, and all the guides say that connecting the Reporting Services instance should upgrade the database schemas to the correct versions. So why isn’t it for you?

By now you’ve started to delve into the depths of the Reporting Services logfiles (always a great place to look for any Reporting Services issues, can be quicker than googling). And you’ve spotted what looks like the smoking gun:

library!WindowsService_0!b84!07/23/2012-11:28:31:: i INFO: Current DB Version C.0.8.54, Instance Version 147.
library!WindowsService_0!b84!07/23/2012-11:28:31:: i INFO: Starting upgrade DB version from C.0.8.54 to 147.
library!WindowsService_0!b84!07/23/2012-11:28:32:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: , An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database.;
library!WindowsService_0!b84!07/23/2012-11:28:32:: e ERROR: ServiceStartThread: Exception caught while starting service. Error: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database. ---> System.Data.SqlClient.SqlException: Cannot find the object "dbo.SnapshotData" because it does not exist or you do not have permissions.
Changed database context to 'ReportServerTempDB'.

So you dutifully go and check if dbo.SnapShotData exists, check the permissions, maybe even give you service user sysadmin rights as a last chance hope?

And still none of it works. So what is the problem then. Well, did you move over ReportServerTempDB as well as ReportServer? Wait a sec, why should you? Didn’t some guy on the internet say you didn’t need to backup that one, just like TempDB? Well they may have said it, and sometimes they might have been right. But when doing an uprade you need ReportServerTempDB as well. So now you need to find it, hopefully you’ve still got the original kicking around to make life easier. If not you’ll need to find one of the same original version and then sort the permissions out.

This is a very common issue we see when we get called in to look at Reporting services upgrades gone bad. For most instances, the space used by a ReportServerTempDB backup isn’t really a worthwhile reason for not taking one just to make your life easier.

Stuart Moore

Stuart Moore

Nottingham based IT professional with over 15 years in the industry. Specialising in SQL Server, Infrastructure design, Disaster Recovery and Service Continuity management. Now happily probing the options the cloud provides

When not in front of a computer, is most likely to be found on the saddle of his bike

More Posts - Website

Follow Me:
TwitterLinkedInGoogle Plus

Stuart Moore

About Stuart Moore

Nottingham based IT professional with over 15 years in the industry. Specialising in SQL Server, Infrastructure design, Disaster Recovery and Service Continuity management. Now happily probing the options the cloud provides

When not in front of a computer, is most likely to be found on the saddle of his bike

Managing Microsoft Message Queuing in a cluster remotely

Ever had the problem when you’ve only got remote access to your cluster nodes and you need to modify a clustered MSMQ instance, but the tools just won’t connect to the correct instance, even when you’ve tried the set computername command prompt trick, you can’t use mstsc /console or you’re stuck on Windows 2008R2 and you don’t have the manage option on right click in Failover Manager.

Make your life so much easier by getting a nice simple free tool from Microsoft MMCV –

Stuart Moore

Stuart Moore

Nottingham based IT professional with over 15 years in the industry. Specialising in SQL Server, Infrastructure design, Disaster Recovery and Service Continuity management. Now happily probing the options the cloud provides

When not in front of a computer, is most likely to be found on the saddle of his bike

More Posts - Website

Follow Me:
TwitterLinkedInGoogle Plus

Stuart Moore

About Stuart Moore

Nottingham based IT professional with over 15 years in the industry. Specialising in SQL Server, Infrastructure design, Disaster Recovery and Service Continuity management. Now happily probing the options the cloud provides

When not in front of a computer, is most likely to be found on the saddle of his bike