Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kid_on_the_block
Posting Yak Master
172 Posts |
 Posted - 2005-07-01 : 11:52:26
|
| HiHow are Service packs & update patches applied to the SQL Server, I mean do we first give it a try on the test server , if its fine then apply it to the production server or ????What if a person does not have a test server what is the best way to take of any problems that could arise out of it Please advice |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-07-01 : 11:56:26
|
| first, do not install sql server service pack 4. it is causing grief for a number of people.second, if you do not have a test server, get one or turn your local PC into one.Yes it is a good idea to test service packs and patches and read the release notes.Sean RoussyPlease backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own.I am available for consulting work. Just email me though the forum. |
 |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2005-07-01 : 13:33:02
|
| What problems are there with SP4? |
|
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
|
|
|
|
|
Service Packs & Patches