[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.
11/07/2009 at 01:53AM PST, ID: 24880193 | Points: 500
[x]
Attachment Details

How to Mirroring database in SQL Server 2005

Asked by umeshmodi in SQL Server 2005, Windows 2003 Server, Databases Miscellaneous

Tags: Database Mirroring, Mirroring in SQL Server 2005

Hi,

I am going to configure Database Mirroring. I have installed SQL Server 2005 (Developer Edition) on both end.
Any body guide me how to configure 'Database Mirroring'. I was trying to do it as per my application of mind but unfortunately I was unsuccessful. its returned an error as follow

"Database mirroring is disabled by default. Database mirroring is currently provided for evaluation purposes only and is not to be used in production environments. To enable database mirroring for evaluation purposes, use trace flag 1400 during startup. For more information about trace flags and startup options, see SQL Server Books Online. (Microsoft SQL Server, Error: 1498)"


Please help me out with above problem.

Regards,
Tushar Ghodake.
www.jimtrade.com
[+][-]11/07/09 02:01 AM, ID: 25765661

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/07/09 02:35 AM, ID: 25765736

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20090824-EE-VQP-74 - Hierarchy / EE_QW_3_20080625