Thank you both for your replies! I feel uch better now 🙂 I was starting to question my understanding which is never good headed into an exam!

Kim

Turns out WMI was hosed so it wasn't just that class that was missing 🙂 I repaired SQL Server and my script started working again.

Thanks,

Kim

Met with the vendor. It got heated for a short time.... so much so the company called me later to apologize. Then they provided me with an emergency...

Have a conference call with the vendor this morning to discuss this further. wish me luck!

My coworker who is a senior DBA (mainly Oracle) of 20 years says we...

GSquared (10/26/2011)

---

kstjacques: Most likely, if it's doing that, it's breaking your log chain anyway, and your log backups aren't doing you any good.

Have you tested point-in-time recovery with your current...

OK, vendor got back to me with the final fix/recomendation.... my co-woker is agreeing with the vendor on this and I am a Jr. DBA, so I need someone to...

Grant Fritchey (10/23/2011)

---

I just hope the vendor isn't one near & dear to my heart.

Yeah, there are lots of reasons to use a third party backup method. For example, we...

Thank you for all your responses!

So the good news is the vendor is saying they will look into fixing the issue.

My favorite part of the latest response was:...

I'm not familiar with documentation, but I know you can use mount points in a SQL Server cluster and work it out so each SQL instance has its own drive...

Not sure if this is helpful, but I found this article....

>2011-07-15 16:33:10.17 spid4 Starting up database 'master'.

>2011-07-15 16:33:10.18 spid4 Error: 823, Severity: 24, State: 6.

http://support.microsoft.com/kb/828339

"Error message 823 may...

I place my system databases on their own lun. I prefer to not risk inadvertantly filling the C drive and bringing the server down 🙂

Thank you for the responses. I was able to explain to the vendor with confidence that the database was indeed SQl Server 2008 and they no longer refused to...

I don't know what your needs are, but have you considered querying the instance for the list of DBs and then traversing through the result set to see which ones...

If they don't mind the data that is loaded in the test environment moving to prod, I would just backup the database in test and restore it to the production...

If you have a windows administration team, you should inquire if they are using SCOM to monitor the windows environment. If they are, you can ask them to install...