SQL Server Performance Forum – Threads Archive

Look For Service Pack in SQL

Hi Friends, After installing SP3 pack. I am looking for output of @@version to ensure that SP3 pack taken into effect. But when i Select @@version. I get below output which indicates still i am having SP1. Please let me know is there is anyway to get know about SP3 from SQL server apart from @@version. Microsoft SQL Server 2000 – 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
Second after completing SP3 installation i got message that please take backup of master and model db as SQL server is updated with latest service pack.what that means. Do i have to keep the backup of master and model db. Please provide your inputs Thanks and Regards
Ravi K

8.00.760 refers to be SQL 2000 SP3/SP3a and 8.00.194 will be SQL 2000 RTM/No SP. The service pack 1 on the query results refers to be for Windows operating system, as it clearly mentions against windows. Yes you must take regular backups for system database as well whenever any hotfix or service pack is applied, before and after. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

SELECT SERVERPROPERTY (‘productlevel’)
will give you the SP version

http://vyaskn.tripod.com/sqlsps.htm has the all the needed details for the SP versions. with regards to the second question, I normally take all the db backups before installing anything on the main server as a practice.

http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37 Btw, it is not the worst idea to have a current backup of the system db’s in case of a disaster [<img src=’/community/emoticons/emotion-5.gif’ alt=’

‘ />] – Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de</a> Ich unterstÃ¼tze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>)

]]>