July 27, 2007 at 11:46 pm
i am going to create sql server mirroring on one a single server
for this i need to create new sql server instance i dont know
how to create new instance in mirroring
Kindly help me .
Regards
Syed Naveed
July 27, 2007 at 11:52 pm
In one singlre server you can create 3 seperate instances and configure dataabse mirroring.....even i had done the same it works....Just run through the setup.exe as you did for installing sql server default instance....you need to specify the instance name @one particular place....thats it the sql server instance will be created......then you can connect to the instance through SSMS by specifying servername\instance name in the connecting window of ssms
[font="Verdana"]- Deepak[/font]
July 28, 2007 at 12:01 am
you can refer this link,
http://dumthata.com/sqlchn/articles/install/insql.htm
refer the step 9 in that link you need to choose named instance option there and specify any name asper your desire.......cool
[font="Verdana"]- Deepak[/font]
July 28, 2007 at 1:14 am
thanks for assistance i got the result positive.
now i have another issue when i make the mirroring between 2 instance it shows the message.
" 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) "
July 28, 2007 at 1:49 am
Hey you need to use Trace flag 1400 for SQL server RTM versions i believe......even i had this issue.......go to sql server configuration manager and choose sql 2005 services and select sql server service and right click it and go to properties and choose startup parameters and include -T1400 @ the end....and restart sql services.....it shud be fine
[font="Verdana"]- Deepak[/font]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply