SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: November 2012

Backup History

This is a quick rewrite of the script I just posted a few days ago.  The script had a few flaws if trying to run it on a SQL 2005 box.  I have updated it to run against SQL 2005 and up.

This version is done using Dynamic SQL to… Read more

5 comments, 2,487 reads

Posted in SQL RNNR on 30 November 2012

Differential Restore Fail

We have all heard that backup is not complete until you test it by restoring it.  We also know that part of a DR plan involves the testing of those backups through restores.

I recently had the opportunity to run through a test scenario and ran into a substantial failure.… Read more

8 comments, 1,494 reads

Posted in SQL RNNR on 28 November 2012

Most Interesting People…

Here are the most interesting people I met at PASS Summit 2012


Mickey Stuewe (sqlmickey)

Neil Hambly (neil_hambly)

Bob Hovious

Gail Shaw (sqlinthewild)

Ed Watson (SQLGator)






This is the short list of the many many many… Read more

0 comments, 1,422 reads

Posted in SQL RNNR on 21 November 2012

Last Known Good CheckDB

Diligent DBAs like to check their databases for a little thing called corruption.  Some of those DBAs are masterful at keeping records and logging that the database was checked and came up with a clean bill of health.

There are many different ways of logging this kind of activity.  Today… Read more

10 comments, 2,603 reads

Posted in SQL RNNR on 20 November 2012

T-SQL Tuesday #36 SQL Community

Community – What is it?

Community is something that is improperly defined with words alone.  Community is best defined through first person experience.  Community is a feeling and a sense more than it is a definition in “pick your dictionary here.”

So how do you experience this thing we call… Read more

0 comments, 842 reads

Posted in SQL RNNR on 13 November 2012

Summit 2012 Community Zone





Will you be at Summit 2012?

I will be. I will even be pretty easy to find on multiple occasions.  If you haven’t seen my schedule already – you can check it out here. You’ll probably notice that there are a few times where I… Read more

1 comments, 1,012 reads

Posted in SQL RNNR on 2 November 2012

Summit 2012

In case you have been living under a rock (I know it’s not under my rock), here is your notice that Summit 2012 is just a few days away at this point.

I will soon be boarding a jet bound for Seattle for a week full of all things SQL.… Read more

0 comments, 889 reads

Posted in SQL RNNR on 1 November 2012