SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 upgrade msde sp3 to sp4		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

aki123
Starting Member

20 Posts
Posted - 08/26/2007 :  06:31:15  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
3575 Posts
Posted - 08/26/2007 :  09:38:04  Show Profile  Reply with Quote
do you perform regular backups of your database?
Go to Top of Page

aki123
Starting Member

20 Posts
Posted - 08/26/2007 :  11:24:23  Show Profile  Reply with Quote
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
Go to Top of Page

eyechart
Flowing Fount of Yak Knowledge

USA
3575 Posts
Posted - 08/26/2007 :  11:30:10  Show Profile  Reply with Quote
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?
Go to Top of Page

aki123
Starting Member

20 Posts
Posted - 08/27/2007 :  06:29:44  Show Profile  Reply with Quote
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
Go to Top of Page

eyechart
Flowing Fount of Yak Knowledge

USA
3575 Posts
Posted - 08/27/2007 :  14:45:53  Show Profile  Reply with Quote
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
Edited by - eyechart on 08/27/2007 16:17:19
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts
Posted - 08/27/2007 :  21:33:39  Show Profile  Reply with Quote
You should check if have any problem in bkupexec.
Go to Top of Page

aki123
Starting Member

20 Posts
Posted - 08/28/2007 :  08:18:36  Show Profile  Reply with Quote
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
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts
Posted - 08/28/2007 :  21:09:20  Show Profile  Reply with Quote
That means the db used by backup exec is bacped up, doesn't mean backup exec itself works.
Go to Top of Page

aki123
Starting Member

20 Posts
Posted - 08/30/2007 :  06:13:29  Show Profile  Reply with Quote
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
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts
Posted - 08/30/2007 :  21:30:50  Show Profile  Reply with Quote
They are explained in readme file.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.27 seconds. Powered By: Snitz Forums 2000