July 28, 2008 at 3:32 am
Hi,
When I set database mirroring I recieve following error..
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. (.Net SqlClient Data Provider)
Pls help me to remove above error.
Regards,
Sunil Kumar
July 28, 2008 at 3:39 am
This sounds like you have the RTM version of SQL 2005 server, if so then you will have to start the server with the trace flag of 1400. else you will need to stall service pack 2 and then try to configuer DB Mirroring.
Regards,
Terry
July 28, 2008 at 3:53 am
Could u please tell me how to start the server with traceflag 1400.
July 28, 2008 at 4:15 am
You need to do the following in order to enable the database mirroring on you server:
1: Open SQL Server Configuration Manager
2: Right-Click SQL Server serivice.
3: Click on Advanced tab.
4: On the startup option add -t1400
5: Apply and re-start SQL Server Service.
And the database mirroring is enable on your instance.
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
July 28, 2008 at 4:21 am
su_kumar11 (7/28/2008)
Could u please tell me how to start the server with traceflag 1400.
I would recommend that you don't and rather look at patching the server to SP2 at the minimum.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 10, 2009 at 9:02 pm
Basit, I'm afraid your steps are wrong or incomplete.
Gail, I can't seem to install sp2 or sp3. At the "Authentication" step, I always get a "Your account information could not be verified" error. The Status for "Database Services" was Success, but for "Reporting Services" is always "Login Failed". Turning on or off "Apply selection to all instances" and selecting only "Database Services" had no effect.
Here's what worked for me:
1. Open SQL Server Configuration Manager.
(Start / Programs / Microsoft SQL Server 2005 / Configuration tools / SQL Server Configuration Manager)
2. Click SQL Server 2005 Services.
3. Right-click SQL Server (MSSQLSERVER) (in the right frame) / Properties.
4. At the SQL Server (MSSQLSERVER) properties window, click the Advanced tab.
5. Locate the "Startup Parameters" setting, and click inside the text field on the right. It will expand into a little text window.
6. At the end, add ";t1400".
Example: Here's mine now (not including the quotes):
"-dC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf;-t1400"
7. Click Apply.
8. At the Warning, click OK.
9. At the SQL Server (MSSQLSERVER) properties window, click OK.
10. At the SQL Server Configuration Manager window, right-click SQL Server (MSSQLSERVER) (in the right frame) and click Restart.
Wait a few moments for the service to restart.
Disclosure: I have not (yet) set up database mirroring yet (adventureworks), but I'm closer.
August 10, 2009 at 10:12 pm
Better try doing it in the command prompt.
NET STOP MSSQLSERVER
and then again start it by enabling the trace.
Use this
NET START MSSQLSERVER t1400.
The above mentioned commands are for default instance.
Thanks,
Leks
August 10, 2009 at 10:14 pm
Better try doing it in the command prompt.
NET STOP MSSQLSERVER
and then again start it by enabling the trace.
Use this
NET START MSSQLSERVER t1400.
The above mentioned commands are for default instance.
Thanks,
Leks
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply