Installation of Service Pack 4

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Installation of Service Pack 4

Author

Topic

ynaina
Starting Member

9 Posts

Posted - 2008-08-25 : 00:57:23

I have SQL Server 2000 standard edition. Database log file is started increasing very fast after i started doing snapshot replication. My Sqlserver didn't have any service packs, so I have updated service pack SQL2000-KB884525-SP4-x86-ENU.EXE in my sql server. When i run the following query
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

I am getting
8.00.194 RTM Standard Edition

Where can i see the service pack's updation?

My data file size is 600 MB and log file size is 7GB. How to i reduce the size? Shrinking file is not working.

Help Me.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-08-25 : 08:00:18

You should be able to get SP info with this? Did you restart services after installing?
SELECT SERVERPROPERTY ('productlevel')

also you should backup your log frequently to control your log size.Did you try taking log backup and shrinking log file?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources