BrightStor ARCserve Backup showing as Incomplete

active8it
active8it used Ask the Experts™
on
Morning folks,

One of our clients uses BrightStor ARCserve to perform their backups - the job appears to run each day but comes back as 'Incomplete'

Under the job log there are a series of files reporting a W3404 'Unable to Open File' error - even though the ARCserve has administrative access

Has anyone come across this before?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
Sometimes its a corrupted file or else the user has permission to edit permissions and removes domain admins or domain access from the folder. Full control permission needs to be take from the user to prevent this

Author

Commented:
Thanks Sid - I will check the permission settings and run the backup again tonight

Author

Commented:
Unfortunately that does not seem to have worked - permissions seem to be set correctly but there are a number of files within the MS SQL 2005 folder which are throwing up 'Sharing Violation' errors, as described above.

Any further advice anyone has would be appreciated as everything else seems to be backing up correctly
They might be database files. You have to use SQL agent to backup online SQL databases. Another option is to use ACT!'s Scheduler to backup the database to a ZIP and backup those files via Arcserver

If they are not database file, you have to use Open file agent to backup.

Author

Commented:
Prashant, I believe they may be SQL database files; the files in question are in the folder:

C:\WINDOWS\SYSMI\SSEE\MSSQL2005\MSSQL\DATA

and the files themselves are:
master.mdf
mastlog.mdf
model.mdf
modellog.ldf
msdbdata.mdf
msdblog.ldf
tempdb.mdf
templog.ldf

Looks like I might need to set up the ACT Scheduler then...
Yes, these are database file and dynamic in nature. You should either use an agent which is SQL aware  or use ACT scheduler and then use ARCserve to backup as flat files to tape.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial