there are a couple of nice articles regarding SSB at SSC too.

A simple walk trough I've written can be found at:http://www.sqlservercentral.com/articles/Service+Broker/2897/

There is no need for a clustered index to be unique !

However, if it isn't unique, sqlserver will "uniquify" it for you by adding a 4-byte part to it.

The clustered...

Is this a named instance or a default instance ?

IMO it should be doable for a default instance, provided you follow the "rename server" procedure sequence after you restored the...

IMO you should split your @consultants string using another split character !!

Your data contains a comma, and your current split function is called using a comma as split character, so...

sql2008 uses compression to ship log records to its mirrored dbs.

one of the down sides of a system upgrade is you may end up with old stuff you don't want. ( vs new install and userdb migration )

- did you...

Easiest way to show open transactions is using sql server management studio (SSMS).

Connect to your sqlinstance, double check you are connected to the correct database and then execute

dbcc opentran

another this...

- someone may have restored your db to that point in time. (maybe targeted the wrong server.

- Do / did you have long running open transactions ???

- check your instances...

Did...

- you simply cannot empty the first "primary" file as it contains all catalog info !

Your alternatives could have been to add another filegroup, and put two files in that...

apparently something went wrong in your setup process.

I would clean it up totally and start all over again.

Prepare your checklist and tick the steps you perform.

You should first have looked in your sqlserver errorlog.

- what topology of mirroring were you using ?

- did you have a look at your SQLServer ERRORLOG file ?

- did you...

double check your both msdb broker setting.

SELECT ''...

this will be a source of coming bugs !(people will actually take if for a date and not just a number of days !)

But since you insist:

-- keep in mind...

- another thing to keep in mind is the size of your database files vs the size of your backup file(s). (time needed for the copy/move action)