August 17, 2009 at 12:51 pm
HI , Please help !
We have a window 32bit server WIN2003 with sp2, on which there are 2 sqlserver 2005 sandard instances and 1 sqlserver 2000 enterprise. Now we apply service pack 4 to sqlserver2000 but failed with error 'error running script sp3_serv_uni.sql'.
Thanks very much in advance
Moni
August 17, 2009 at 1:46 pm
do you have analysis services on this server?
August 17, 2009 at 1:50 pm
yes but it was installed with sqlserver 2005 standard.
August 17, 2009 at 1:56 pm
Are you in a position where you can reboot the machine? I have heard of instances where analysis services causes SPs to fail, and after a reboot sometimes they work. May be worth a shot. It seems like it was that particular script that would fail, but it's been quite some time.
August 17, 2009 at 2:00 pm
Can sp4 overwrite? I mean i will install sp4 again without resuming the backup. I will try to reboot the machine after the business hour. But the analysis service is in sql 2005, not sql2000.
Thank you for help !!
August 17, 2009 at 2:12 pm
yeah, I know it sounds strange, but I think I remember this one, but like I said, it's been a while since I have run 2000. If you are in a position to try it, I would give it a shot. Always good to backup your databases first.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy