217 W3404 can't open and backup the database file in SQL7

[Guest_imported]

Hi,

I have a SQL 7 database on SQL server (W2K Adv. server, SP1) and a SONY SDT-9000 DDS Tape Drive in the backup server(NT4, SP6)--different server. I use ARCserve IT Version 6.6 as backup software.

When I backup SQL data via Intranet, the backup engine can never open any file with extention 'mdf'and 'ldf' in the folder of \\SQLSERVER\mssql7\data\ except 'msdbdata.mdf' and 'msdblog.ldf'. But if I stop the SQL server service during backup, the engine can open and backup all files.

So, how can I backup SQL 7 database when SQL service is running?

Thanks,

Yujie

 

[HereIam]

on top of NT4 licence from ArcServe, you need to buy Backup Agent for Open File and Backup Agent for SQL. If you don't have a promission problem ( you need to create an account for ArcServe, rather than using your god Admin account), After that, you should be fine.

HereIam

 

[HbO]

I have the same problem:
W3404 Unable to open file. (FILE=C:\WINNT\system32\Perflib_Perfdata_628.dat, EC=SHARING VIOLATION)

I have the Open File Agent. Is anyone know how to resolve my problem?

Thanks

 

[Arcservebaba]

Hi all,

You do not need a backup agent for open files to backup the
sql server online..
You just need a sql agent to back it up..

I don't think that CA is selling arcserve 6.61 and its agents anymore as they have released arcserve2000..

I ran into same problems and atlast i bought arcserve2000 and its agents to backup my sql 7.0 databases..

Thanks,
baba

Baba says...
"Known is a drop, unknown is a ocean"