Recently, I went to Avantus for SQL Server 2005 clustering training.
Found on google there is a link that look exactly like our lab exercise :)
For database mirroring (with GUI how-to-do-it)
Source:
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1199004,00.html
The SQL 2005 feature comparison states that SQL Mirroring is available in Standard and Enterprise editions, making it a viable solution for smaller customers as well as for enterprise customers.
Source:
http://www.microsoft.com/sql/2005/productinfo/sql2005features.mspx
However, we can tweak the settings to get mirroring work in SQL Developer 2005 edition.
The lecturer said we can add a switch to start sqlserver under the services "-T 1400"
However, because of we not on SP1, the lab exercise failed. :(
Mirroring allows the user to create an exact copy of a database on a different server. The mirrored database must reside on different instance of SQL Server Database engine. Microsoft fully supports database mirroring with SQL Server 2005 SP1 onwards. For the RTM release (prior to SP1), Microsoft support services will not support databases or applications that use database mirroring. The database mirroring feature should not be used in production environments. Prior to SP1, database mirroring is disabled by default, but can be enabled for evaluation purposes by using trace flag 1400. The following T-SQL statement can be used to achieve this:
DBCC TRACEON(1400)(With T-SQL how-to-do-mirroring)
Source: http://www.sql-server-performance.com/articles/clustering/mirroring_2005_p1.aspx