ARCSERVE BACKUP FAILS ON SQL OPEN FILES

[RBRYANT]

I'm having a problem getting ArcServe 6.x, loaded on an NT box, to backup open files.  Mainly these are SQL files.  It gives me the warning message W3404 - Sharing Violation.  We have the Open File Backup so I'm not sure what the problem is.

 

[EvilOptic]

have you ever thought of buying the "Backup Agent For SQL Server"???? or use the pre-and-post option to shut down sql

 

[RBRYANT]

Why yes, we do have the SQL 7 Backup Agent, which I should have mentioned, and I am still getting the same errors.  Why should I have to use a pre-post option if the SQL 7 Agent is designed to backup OPEN SQL files??????  Should the product not work like it is designed to?

 

[MagicHamster]

Unfortunately it will as part of the normal file backup. You can set it up so it ignores the SQL data folder.

 

[monkeylizard]

Basic tip, but I've seen it overlooked before. Make sure the BAOF and SQL Agents are loaded on the Source machine and not just on the ArcServe Server. Monkeylizard
-Isaiah 35-

 

[Shad007]

I've heard that you can dump the SQL database to a separate file to enable backups...please don't ask me how this is done as I have never done it but once figured out you could schedule it to run on a daily (or nightly) basis...if i get more info on how to do this i'll post it here.