Hi Erik,

I knew of this tool, but this one requires running a seprate service on the SQL server, which is fine if you are allowed do that.

If not... you could...

🙂

I allready reinstalled it.

But the screen seems to suggest a downgrade is possible using the UI, and since upgrading a standard edition to enterprise works, the reverse should also be...

Cheers thus far Kevin,

I'm now running AlwaysOn, an i will keep you informed when i have found a solution,

Theo 🙂

Hi Kevin,

I did'nt add the waitstates because on the mirror there are only 2 (Script at end of message)

Top 10 Waits @ primary

WaitTypePercentage

CXPACKET40.70

DBMIRROR_WORKER_QUEUE8.58

LATCH_EX8.40

HADR_FILESTREAM_IOMGR_IOCOMPLETION8.07

DIRTY_PAGE_POLL8.07

SP_SERVER_DIAGNOSTICS_SLEEP8.07

SOS_SCHEDULER_YIELD1.92

BACKUPIO1.75

ASYNC_IO_COMPLETION1.40

ASYNC_NETWORK_IO1.30

All Waits @ mirror

WaitType ...

@TheSQLGuru & @jeremye

Thanks for the feedback guys 🙂 Much appreciated!

I have tried trace flag 1485 on the mirror, just to be sure, but as the Guru...

Hi Kevin,

Good point, i was somewhat sparse with the amount of details... here goes:

As you quite rightly pointed out it's not the size of the DB that is important...

I think the dependency is assumed to be correct if the object does not exist.

Probably to allow to build install scripts that don't have the exact order of dependancy 🙂

Hm.

This sounds familiar to a SQL install problem i once had with a large (16 CPU) HP server.

I ended up disabling all but 1 quadcore CPU until the initial install...

You could change the SQL compatibility setting from sql 2000 to 2005, if the app will allow it?

I have never come across an app that has issues with an higher...

Thanks ryanwooster1980 😀

It will be much appreciated by the poor sods that still have to maintain SQL2000 databases.

I for one still have 2 old boxes that were virtualized because the...

Ahhh...

This is why i like SqlCentral so much, its truly is a place where ideas can be shared 🙂

Thanks for posting the tweaked version!

Theo

Some people report errors downloading the EXCEL file with Internet Explorer, please try another browser (chrome of Firefox).

I suspect yahoo hosting does something weird when IE downloads.

Or try this...

Hi Guys,

Thanks for the feedback, and yes.... My bad, i left ONE line of code in that is SQL 2012 specific, if you comment out line 77, the code...

A usefull script to have,especially with "all or nothing" apps like sharepoint.

Thx for sharing 🙂

Another excellent article, John ! This is really usefull.

Keep e'm coming 🙂

Theo

(NL)