I have additional 10 GB NICs on each node of the mirror...

On the principal I used the following to create the end point:

CREATE ENDPOINT [DB_Mirror]

...

Strictly FYI -

http://blogs.msdn.com/b/sqlserverfaq/archive/2010/03/31/step-by-step-guide-to-setup-a-dedicated-sql-database-mirroring-dbm-on-dedicated-nic-card.aspx

Going to give it a try...

Anyone ever use SQL Power Tools for SQL2008 ENT?

We inherited a custom app with substantial amount of generated dynamic tsql.

I need to identify the code being executed so it can...

Looks like the business has agreed to a weekly data load. It appears i'll have to copy a compressed full backup file across a relatively slow WAN connection and perform...

Thanks for the response. Currently running on WIN2008 R2, SQL 2008 64 Bit Enterprise Multi-site cluster.

Just looking for the best way to create a read only copy of the database...

Found it:

select * from sys.objects

where modify_date >= '12/1/09'

order by name