Backing up SQL server

[Crommm]

Hello,

I know similar questions have been posted in the past but I have tried all the suggestions with no luck.

We have the latest build of BE server edition with SQL server agent and remote agent for NT/2000 installed on w2k server (sr1). The server is a PDC and has SQL Server 2000 on it. Having finally got the Onstream tape drive to work backing up normal files, I now can't see any SQL databases in the file windows. They don't appear in the file window, but if I go to tools/options I can specify global options for the SQL server support. However, if I click the Backup button from the main button bar, the sql tab is all greyed out (like the Exchange tab next to it). This led me to think that perhaps it hasn't recognised the SQL agent install, so I re-installed to no effect.

There looks to be some really helpful hints about how to actually backup SQL Server databases but I haven't reached that far. If anyone can offer assistance getting the databases to appear, I'd be most grateful.

Cheers,
Ben

 

[Zelandakh]

I have found SQL agent more trouble than it is worth. Do a SQL maintenance plan to drop the DB to disk. Then back up that static data file.

 

[Tilo]

Another thing to keep in mind is, that there are two SQL Agents. One for 7.0 and one for 2000.
If you have the wrong agent, then the symptoms you describe here are correct.
When you entered the Serialnumber for the agent, what did he come up with?
Also make sure that you have Backup Exec revision 3572 installed, as that fixed a few problems with the previous build.

Tilo