Arrgh! Can't restore SQL?! WTF?

[DarthThorium]

Scenario: ArcServe2000 on Win2k Server SP2 (AS patched to SP4). SQL is Microsoft SQL 7 on a 2k server with 2000 Agent and SQL agent.

Problem: Have tried using the domain backup security, and domain admin security, to back up the SQL portion. Logs show IT BACKS UP, but I CANNOT see it on Restore.

Am i missing something bloody obvious? On the Restore, I get all the hard drives, System State, etc, but *no* SQL!

 

[DarthThorium]

Hello? Surely somone has seen this issue before?

 

[DebiJo]

The SQL backup will make a new session number for each database. If you are not seeing that, you are not getting the databases backed up.

When you expand the server tree, do you see the databases? You should see the drives, registry, system state and then the databases. Can you expand the database tree? Have you tried using the sa login and password? I'm thinking I read somewhere that Arcserve liked that the best.

Are you getting any errors? Any acknowledgement of the databases at all? On your log they would be listed after the system state.

-Debi

 

[DarthThorium]

They are listed. They are being backed, the logs show that, plus actual testing shows it as well.

The funky part is, the restore doesn't. I just upgraded the SQL Agent to SP4 yesterday, way late yesterday..so monday I shal see if it worked.

See, my ArcServe is at SP4, however the SQL client in question was at SP3. I don't hold my breath thinking it'll make a difference, but I'll see Monday.

If not, I'm stumped =oP

 

[wamason]

Are you trying to do a session restore?

 

[DarthThorium]

No. By tree, as specified in the arcserve SQL agent's options guide.