Sorry about the delays. I haven't added the changes yet to the script here. However, I am creating a newer...

Why would I use PowerShell...

KWymore (9/12/2013)

---

I think adding the list of dangerous settings with short explanations to the text of your post would make this a better article. While that information does reside in...

Hello,

"Dangerous setting" doesn't mean that your SQL Server will die or become unsecure. In...

Hello Gary,

Since I have a different process...

Hello everyone,

Thanks for the feed back! Glad to see others are talking about this script and modifying it to fit their needs.

As for the issue with xp_readerrorlog, I have...

Hello David,

Glad you find the script useful. I will be updated it soon with additional features so look if an update sometime in August.

Thanks,

Rudy

Excellent!!!

Great article!!! I would change only one thing to make it easier to ready for all DBA levels. Think if you put the actual version of SQL Server like SQL...

Hmmm, good question! I have to look into this a bit further as I don't know.

But I will let you know what I find.

Thanks,

Rudy

Hello and thanks for your comment.

Below is the answer from Microsoft: http://msdn.microsoft.com/en-us/library/ff877972.aspx

"A monotonically increasing number for the database indicating a low water mark used by ghost cleanup on...

Hello Fercasas,

Thank you for comemnts but I'm not an expert but just spend a lot of time with SQL Server. Your blog is very good, I like the layout and...

Hello Fercasas,

I'm glad that the code is working out for you. We have use it to script our all our production servers (SQL2005, 2008/R2 and 2012).

As for posting on your...

I agree but the app systems (web, routers, networking, apps, bathrooms) are not "really" the job of the DBA. If you are responsible for those things then you need to...

Well, like I mentioned before it appears that lots of people for get about DR situations where you need to rebuild basically everything from scratch. I would be interesting to...