Wow! A lot of reaction to this article! Barry, I just want to say thank you for the 60 seconds. I'm looking at getting certified next year and I needed...

Man, that was an easy one! You could have just asked me, 'When did I start suffering and desperately seeking help on the internet with the SQL 6.5/7.0/2000 servers I...

Nice question Steve.

At one point in my career, I would look forward to any innovation. I like building the box, installing the software, programming, modifying the ERP. However, (*sigh*)...

Nice surf. 3 of us took a 2 hour brunch on Tuesday... 😀

I'm with Aaron on this. Moderation. A little for collaboration with projects at work, a little at home to keep in touch with friends. However, my best and most productive...

I can't answer your immediate question, however, Jeff Moden has written some extensive articles here on SQLServerCentral and I would recommend taking a look at them first.

start here:

http://www.sqlservercentral.com/articles/T-SQL/63681/

best...

Nice reply by Steven. Technology that has improved efficiency:

Google - for finding scripts, help files, and SQLServerCentral.

SQLServerCentral - now my first stop before I hit Google.

Caller ID - Oh! The...

Thanks again. I worry too much and second guess myself alot. Guess it comes with the territory...

Have good day,

Alan

One more note - I left the distributor transaction retention at the default 0-72 hours and history at 48 hours. How do you determine what the best setting for this...

Thanks Noel,

Yes, we are using transactional replication. I've got plenty of log space and downtime will be no more than 30 minutes. Just wanted to confirm that this was going...

Yikes! What part of the country do you live in Steve, Montana? :w00t:

Calm down my foreign friends, it's not that bleak over here in the states. We have...

Late adoptor.

At least SP2.

We are still on SQL 2005 and have no plans for moving to 2008. We may even skip it and go directly to SQL Server...

I actually used a script...

For SOX audit purposes, we are required to demonstrate a successful restore (from an offsite backup tape) every quarter.

But we restore data from disk for testing environments every 1-2 weeks....

Whew! I thought I was going crazy or the network was! Thank goodness it was just you and these crazy links!

Downtime: No. Didn't have any last year. Had a power...