May 14, 2009 at 9:52 am
Hi,
Does any one know how to regress the Service pack in SQL server.
Today I spend couple of hours for this testing and came to know that my assumption that 'systemresource' database is used to regress the service pack in SQL server was wrong.
What i did:
1) Made a SQL Sever without SP (taken 'systemresource' database backup)
2) Install Service Pack1 (taken 'systemresource' database backup)
3) Install Service Pack2 (taken 'systemresource' database backup)
4) Install Service Pack3 (taken 'systemresource' database backup)
My purpose was to regress from heigher SP version to lower SP version. But when i replaced the 'systemresource' database files from lower version to heigher. The SP version didn't changed. I tried it with all the backups. But it didn't work at all.
Does anyone know if this is possible?
Thanks,
May 14, 2009 at 9:59 am
Unfortunately thats not possible. For SQL2005 and below you have to uninstall and reinstall to remove a service pack.
It is a worthwhile practice to have backups of your resource database though, in fact its imperative, and file copies of the other system databases (except tempdb) as having these makes the process of getting your configuration back once you have reinstalled easier and quicker (you just copy out new system db files and copy in the ones you saved.)
---------------------------------------------------------------------
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply