Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: May 2010

Time Off, Recharge, Rethink

Some of you may have noticed that I haven’t posted for a while. The 12th May was the date of my last post. Well, in the last few weeks I have been on holiday. Me and the family took a trip to the USA and the Sunshine state to celebrate… Read more

2 comments, 254 reads

Posted in The SQL DBA in the UK on 25 May 2010

Are Transaction Rolled Back When CHECKDB Runs?

Ever come across a scary error in the SQL Server log when running CHECKDB against your databases. The error looks something like this:

1 transactions rolled back in database 'CHECKDB' (32). This is an informational message only. No user action is required.


Are transactions rolled back when CHECKDB runs?



No. Read more

3 comments, 213 reads

Posted in The SQL DBA in the UK on 12 May 2010

SQL Server Integrity Checks – DBCC CHECKDB

I like to run integrity checks against my databases very regularly, sometimes daily if I can get away with it. For some of the larger databases that I manage I change how this is run but on my consolidated instances which can house several different smaller databases I run the… Read more

8 comments, 939 reads

Posted in The SQL DBA in the UK on 5 May 2010

SQL Server Replication - Replication Agents

My first post in my replication series gave a brief overview of replication, before I dive into setting up and configuring the different types of replication I wanted to look a little more closely at the respective agents and the role they play in the different types of replication. Read more

7 comments, 1,411 reads

Posted in The SQL DBA in the UK on 4 May 2010