Great Script, Just a small tweak if i may;

The 'Order By' clause you use on line 45 does not really work as the data column is a nvarchar and contains...

Hi Varun

The script creates several different alerts. Alerts such as "Mirror Connection Lost" and "Principal Running Exposed" etc dont require thresholds, however, alerts such as "Unrestored Log Threshold" do.

The SP...

Working great for 1,2,3 & 4th occurances, but if i pass in 5 for april 2010, i am getting the wrong date

For example:

SELECT dbo.getNthOccuranceOfWeekDay(YEAR(GETDATE()), MONTH(GETDATE()), 1, 5)

Resulting in:

2010-04-18 00:00:00.000

Should be:

2010-04-25...

Robert Davis (2/21/2010)

---

You can do it that way, but then it will take a longer time to sync up again because the mirror is doing nothing during the batch processing....

Hi Robert, as I said In my post, I am stuck with using 2008 standard edition. I thought high performance mode mirroring was only available in enterprise editions? Or have...

Hi

Cheers for the link mate, read that some time ago, meant to update this thread!

Basically after reading just about everything i could find on Mirroring, (i even bought 'Pro SQL...

on further investigation into this, its defiantly my Weekly Maintenance task that is causing the Log File to explode in size (Probably due to the Rebuilding of Indexes)

Now, the database...

Aye, i realise that the shrink fragments the new index, that’s why i proposed a...

The original problem was a 150GB log file on a different database which i shrunk to get working this morning (desperate measure, 500 staff screaming at me etc, you get...

The Transaction logs are being backed up, see the screenshot below, this shows several things:

Transaction logs are being dumped every 30 minutes (and 1 ad-hoc one i ran for the...

on running:

SELECT NAME, compatibility_level, log_reuse_wait, log_reuse_wait_desc FROM sys.databases

i get:

NAME compatibility_level log_reuse_waitlog_reuse_wait_desc

synergy ...

Yes, it is possible, and you can keep the User Accounts etc.

The Tools here help alot:

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

And a script to generate server logins, roles, permissions, users etc can be found...

i know this threads getting a little old, but we have just started setting up the 2008 (64bit) server to replace a 2005 server, and migrating users, passwords, roles, memberships...

UPDATE:

as a test i tried to disable parallelism by running the following:

exec sp_configure 'max degree of parallelism', 1

go

reconfigure

go

THe SP still gets stuck on the 2005 box, however the thread is...

hi m8,

I just kinda came up with a solution by using a function to take a date and return the year end for that date + 1 day to...