upgrade msde sp3 to sp4 - SQL Server Forums

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 2005 Forums

SQL Server Administration (2005)

upgrade msde sp3 to sp4

Author

Topic

aki123
Starting Member

20 Posts

Posted - 2007-08-26 : 06:31:15

hi

i have some problems with my msde 2000
i notice that my server is quite buzy
and only when i disable the bkupexec instance, the cpu relax

i inteand to update msde 2000 sp3a to sp4
it is recommended?
since as far as i know, backup exec should work fine with sp3.

is there any thing to check of this instance before updating?

thanks

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-08-26 : 09:38:04

do you perform regular backups of your database?

aki123
Starting Member

20 Posts

Posted - 2007-08-26 : 11:24:23

hi eyechart

now that u mentioned it, i notice that i dont do any
backups to my msde database. i have to sql 2005.

thanks

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-08-26 : 11:30:10

quote:
Originally posted by aki123
now that u mentioned it, i notice that i dont do any
backups to my msde database. i have to sql 2005.

you see the irony right?

aki123
Starting Member

20 Posts

Posted - 2007-08-27 : 06:29:44

hi eyechart

didnt understand?
what irony u mean?

as i said
i have 2005 express, and did backup him
but as u mentioned i noticed taht i dont
do any backup to msde.

should i? i guess i do.

thanks

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-08-27 : 14:45:53

the instance you are backing up is for backup exec - an enterprise backup solution - yet you aren't even backing up the database that it uses. that is irony my friend. It would be even more ironic if you had a problem and could not recover the backup exec database. You should probably try to avoid that level of irony

so, my suggestion is to make sure you have regular backups of the database scheduled and that they actually work (you have tested a recovery). then, try installing the service pack to MSDE.

-ec

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-27 : 21:33:39

You should check if have any problem in bkupexec.

aki123
Starting Member

20 Posts

Posted - 2007-08-28 : 08:18:36

hi
eyechart

- yet you aren't even backing up the database that it uses.
well u see, when i check the bkupexec instance
open it with 2005 express - choose task - backup
i see that the path to the backup file
and browse to this folder i saw the bak file
of the be database and that is up to date modified

so i guess the backup exec do its on scheduled backup?
i event delete the mdf and ldf of be and restore the db.

so i guess the backup exec do its on scheduled backup?

thanks

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-28 : 21:09:20

That means the db used by backup exec is bacped up, doesn't mean backup exec itself works.

aki123
Starting Member

20 Posts

Posted - 2007-08-30 : 06:13:29

hi

i test this line to upgarde backupexec msde instance to sp4

setup /upgradesp sqlrun instancename=bkupexec
blanksapwd=1 /L*v c:\log.log

my question:
what are the blanksapwd=1 and /L*v stands for?

i once used the same syantax and once not
and didnt see any differances

thanks

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-30 : 21:30:50

They are explained in readme file.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources