General discussion

Locked

Win2K Server / SQL backup problem.

By citizenklaw01 ·
Whenever my SQL backup agent tries to run on my Win2K server, the agent hangs the computer and we have to restart. The SQL version is 7.0, the server box is a Compaq Proliant 800 running Win2K server. The tape backup unit is the one that comes from the factory. We would like the SQL agent to manage the backups directly to tape. Help is appreciated. Thanks!

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Win2K Server / SQL backup problem.

by McKayTech In reply to Win2K Server / SQL backup ...

What backup software are you using?

Collapse -

Win2K Server / SQL backup problem.

by citizenklaw01 In reply to Win2K Server / SQL backup ...

I am performing the backup as a service of SQL server. The backup runs under the "jobs" section of the SQL Server Agent service. As a workaround, we perform the backup to another server, and then from there to a tape. But, we would like to perform these backups directly from this server. Should you need any more information, please contact me at joelomar@caribe.net. Thanks!

Collapse -

Win2K Server / SQL backup problem.

by McKayTech In reply to Win2K Server / SQL backup ...

Ah, now I understand... You're running a SQL backup job that dumps the database to a disk file and you want to dump it directly to tape.

Unfortunately, I don't have the answer for you. All my experience is with systems where I dump the SQL database to a disk file and then pick up the disk file using a conventional tape backup product (e.g. NTBackup or W2K Backup). I schedule the SQL dump to occur about an hour ahead of the tape backup.

My best guess, assuming the SQL 7.0 can even do what you want, is that there is problem with the tape unit or it's driver and my first troubleshooting effort would be to test the tape drive using W2K's built-in Backup program and carefully review the Event logs to see what errors, if any, were generated.

Hopefully, someone else on the forum who has specific experience with what you want to do will respond with a better answer.

regards!

paul

Collapse -

Win2K Server / SQL backup problem.

by citizenklaw01 In reply to Win2K Server / SQL backup ...

Thanks for the effort anyway. The tape unit does work properly on NTBackup on that particular server. We'll see if anyone else has an answer. Thanks!

Collapse -

Win2K Server / SQL backup problem.

by James_Randy In reply to Win2K Server / SQL backup ...

Since you rejected all those answers, why don't you just close your question? Never mind, I'll do it for you.

Collapse -

Win2K Server / SQL backup problem.

by citizenklaw01 In reply to Win2K Server / SQL backup ...

Poster rated this answer

Collapse -

Win2K Server / SQL backup problem.

by citizenklaw01 In reply to Win2K Server / SQL backup ...

This question was closed by the author

Back to Windows Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums