Community archive

Ask something
Discussion Locked

SQL Backup Agent & Arcserve 2000

0 helpful
1 reply

by johanvdm

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have installed ARCserve 2000 WG Edi SP 1 on Windows 2000 Server SP 1. Then I installed SQL Backup agent to backup my SQL Server 2000 databases. I have selected mixed mode authentication. However, I cannot backup any of my databases using the agent. No problem with other backups.

Not even the 'Northwinds' database. There is no error message. The backup job calculates the session as normal, formats the tape and then the status changes to 'HOLD' and the last result changes to 'Crashed'.

Has anybody had similar problems and possibly found a solution.

1 reply

by merv amos

We had a similar problem with SQL 7 and another backup program.
It was discovered that the upgrade to SQL 7 puts the password from the service used to start SQL on the SQL sa account.
We used sa and the password and the backup now works.
Hope this helps.
Merv.
(Go the Wallabies)

This discussion is closed to new replies.