SQL 6.5 + backup exec error, free muffin to first person to help.

[Abbadon]

Hi Guys,

Getting an error that I can't for the life of me figure out. The backup does actually backup the SQL, but still generates this error. My first thought was that the remote agent was failing to login, but then the backup would have failed. If anyone can shed any light on the error below I'd be muchos grateful.

Cheers

An error occurred while attempting to log in to the following server: "SAABS003".
OS error message: "ConnectionOpen (connect()).".
DBLIB error message: "Unable to connect: SQL Server is unavailable or does not exist. General network error. Check your documentation.".
Server error message: "".

 

[steveot]

What version of Backup Exec
Are there any database offline or suspect?

 

[SQLBill]

Check that your SQL Server is up. Check that the login for Backup Exec Jobs has access to the SQL Server.

Have you tried restoring a backup to make sure that it really IS backing up the database(s)?

I dislike using BE's SQL Agent for backups. I use the SQL Server BACKUP commands to backup to disk and then use BE to copy the backup files to tape.

-SQLBill

 

[Abbadon]

Hi Guys,

thanks for the replies.

We are using 9.1 - all the databases are up and users have reported no issues with the databases. I will double check the backup exec login for SQL.

Thanks for your help and I'll keep you giys posted! )

 

[steveot]

Backup exec 9.1 doesnt support SQL 6.5 database

 

[Zelandakh]

Use the SQL backup routine then backup the flat files.

Search this forum as it has been covered many times. It is much more reliable than BE with agent.

 

[steveot]

Ok I see, but how is this a Backup Exec problem if your just dumping out a flat backu file of SQL, then backing that up to tape. Seem more of a SQL problem.

 

[Abbadon]

I'm not currently using a SQL maint plan to export to a flat file and backup - the backup is actually backing up the databases, but I'm getting this error which I cant explain.