Forum Posts

Unable to restore backup from 2008 R2 to 2008

By Adam Bean, on October 5th, 2009

Locally I am running 2008 R2 and on my DBA management server I run 2008 RTM. Today I went to restore a database from my local to my server and received the following awesome error:

The database was backed up on a server running version 10.50.1092. That version is incompatible with this server, which is [...]

October 5th, 2009 | Category: Backups, Restores, SQL 2008, SQL 2008 R2 | 6 comments

sysperfinfo not matching up with sysprocesses

By Adam Bean, on October 1st, 2009

So this was an interesting one, never seen such a thing before.

I wrote a quick audit procedure to basically monitor connections to every instance in my environment by simply querying sysperfinfo. Well, for the most part the data is spot on. Except for two instances. The cntr_value in sysprocesses for counter_name = ‘user connections’ is [...]

October 1st, 2009 | Category: Audit | Leave a comment
Page 2 of 212