cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Veritas.com
Support

SQL Shuts down when I use Liveupdate

Exchange_Agent
Level 4

‎07-25-2007 01:15 AM

Why does this happen
A live server using 2005 SQL server. Veritas 11d installed and everytime liveupdate runs it stops SQL server.
Why doesn't live update just update veritas software why interfere with Microsoft's Software.

0 Kudos
3 REPLIES 3

Exchange_Agent
Level 4

‎08-07-2007 02:15 PM

Anyone got any ideas?
0 Kudos

Hywel_Mallett
Level 6
Certified

‎08-08-2007 03:05 AM

When a hotfix is applied to BE the database is restarted, in order to ensure the schema is updated correctly (I seem to remember a Symantec tech saying).
This is why I recommend using a dedicated SQL instance just for BE. This also simplifies disaster recovery.
Are you saying this restart happens when LiveUpdate runs, even if there are no hotfixes applied?
0 Kudos

SteveBurkett
Level 3

‎08-08-2007 04:15 AM

Yup, it's 'working as designed' when it stops the SQL Server services, as 'it is necessary to clear out all connections to the database, so that the database can be successfully detached and attached'.
 
Ah ha.
 
Backup Exec is the only product I know which does this, and as far as I'm concerned is very sloppy/lazy programming on Veritas' behalf. An application should not be able to/need to down the whole MS SQL service on which it holds its data.
 
And worse still it does this with no warning or prompt to the user. Very uncouth.
 
So for this reason, have to agree with Hywel, don't put Backup Exec databases on your production SQL Server, instead install it to a seperate SQL instance. Means you'll be able to update Backup Exec during the day, rather then in the evening when your backups are probably supposed to be running.
 
See the following articles for their cop out reason for this stupid behaviour:
 
 
0 Kudos