May 5, 2009 at 6:35 am
Hi,
We currently have seperate servers for our production and test database.
I would like to know if there would be any problems if we start having them on the same server?
Thanks
Shruti
May 5, 2009 at 7:51 am
Well, you could do it, but typically you want to be able to try out new queries on test databases and you may have a poorly written query or a bug that consumes resources which will cause problems in your production databases if they are on the same server. Also you should be testing service packs and CU's on your test server before applying to production.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 5, 2009 at 8:19 am
Hi Could you please elaborate on CU's and service packs?
Thanks
Shruti
May 5, 2009 at 8:26 am
A CU is a cumulative update of fixes that is not as rigorously tested as a service pack. These fixes can change the behavior of code so that what worked no longer works or no longer works as expected, which is why when applying them you should do so to a test server first, then to a production server.
A service pack is an rigorously tested update to the software that fixes bugs and can include new features. Again the update(s) couls change behavior of code so needs to be tested before applying to a production server.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 5, 2009 at 2:47 pm
Thanks Jack
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply