December 6, 2007 at 5:34 am
guys how are you doing? [Cool]
i am new to this website and i have a question regarding database mirroring but first i would like to give you full information how i am using it. my PC is win 2003 server sp2 and still i am using SQL server 2000 database and it has been almost 1 year. and right now, i have installed SQL server 2005 both with sql 2000,( i did not upgraded ), and i saw that it's automatically transfered all my database to SQL server 2005. then i downloaded sp1 for SQL 2005 in order to get database Mirroring. but i can't find it. do you think the problem is due to 2 SQL server is installed in one server? because i am not familiar with sql server 2005. may be i made wrong configuration.
please guys how can i find the database mirroring, even though i have installed the sp1 it's hard to find it. so, please i need your help?
thank you very much and have a good day
December 6, 2007 at 8:11 am
I'm not sure what do you think when you're saying that db's are upgraded automaticaly even if you done side-by-side installation of SQL2005? It cannot happened...
For set up db mirroring from Managemnt Studio - right click databasa -> properties -> mirroring tab.
Nevetheless, I would recommend:
http://msdn2.microsoft.com/en-us/library/ms190941.aspx
http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1199004,00.html
rgds
Sinisa
December 8, 2007 at 8:59 am
i have found it and thank you very much sir. i appreciate
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply