mohsinnazir
Programmer
Hello Guys,
I need experts suggestion about this issue, At the moment we have one databse server which is connected to our web site and internal system and it is round about 20GB of size.
Whenever user search some information from the web site system go to main databse server and gets the information and we have more than 50k hits on our database server.
My manager wants two database server one for web site and second for internal system.
Our main databse server which is sql server 2000 keep updating.
What i thought is create a same database on web server and on our internal database creats triggers which update or insert records in web server database in that way user will have updated information on the web site.
And other solution is Database mirroring which is in sql server 2005.
Will you guys please suggest me any another solution?
I need experts suggestion about this issue, At the moment we have one databse server which is connected to our web site and internal system and it is round about 20GB of size.
Whenever user search some information from the web site system go to main databse server and gets the information and we have more than 50k hits on our database server.
My manager wants two database server one for web site and second for internal system.
Our main databse server which is sql server 2000 keep updating.
What i thought is create a same database on web server and on our internal database creats triggers which update or insert records in web server database in that way user will have updated information on the web site.
And other solution is Database mirroring which is in sql server 2005.
Will you guys please suggest me any another solution?