SQL Network Backups

[CBell]

Hi, I've inherited a SQL problem. I'm a VMS system manager with a little SQL background. THe problem is a Log FIle backup thats goes to a Mapped network drive. It always fails with a device error or device offline. If I look in the event viewer, the error there is "Operating System error = 5 (access denied)". Another problem is this, if I go to create a new job, the mapped network drive ("I" in this case) does not show up in the list of places to put the backup. Is there something I need to do in order for ENterprise Manager to see the mapped drive? This is a NT 4.0 server with SQL 7.

Thanx in advance,

Chris...

 

[tlbroadbent]

Chris,

A login that is assigned to the system administrator server role doesn't need to be added to the db_owner role in the database. System Administrators are dbo in every database.

BeckahC,

I recommend a new thread for your question. You might want to post the question in a VB forum.
Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[BeckahC]

Actually - I think I was reading a different thread, one about books relating to SQL and VB, and for some reason, it posted here... that's weird! I'll just cut and paste, sorry for the bother! BeckahC