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 |
|
learntsql
524 Posts |
 Posted - 2011-12-07 : 04:56:11
|
| Hi All,I am new to administration side.Please guide me about why to install Service pack1 for SQL Server 2008 r2 Standard edition?Do we get really get benifit with service packs?TIA. |
|
|
Eagle_f90
Constraint Violating Yak Guru
424 Posts |
Posted - 2011-12-07 : 06:58:41
|
| Service packs contain all security and bug fixes that where released up to that point, and sometimes new ones. Some service packs also contiain some hotfixes that will improve some functions of the program. It is always recomened to test out the service pack on a test environment to makes sure it will not interfear with the stability of your environment or cause any other unforseen issues (like fixing a loop hope that your developers take advantage of). Once that testing is done then you should deploy to your production environment.-- If I get used to envying others...Those things about my self I pride will slowly fade away.-Stellvia |
 |
|
|
learntsql
524 Posts |
Posted - 2011-12-07 : 07:04:47
|
| ThankQ very much.I have one query after installing in testing how to verify its prose and cons.TIA. |
|
|
|
|
|
|
Why to install Service pack for SQL Server 2008 r2