Backup to Novell volume

[clynch117]

Hello all,

How do I backup my database to a Novell volume? I am using SQL server 7 on NT 4 sp5.

I have been trying to use Enterprise Manager but it will not let me select any Novell mapped drives from the NT box.

I know about sp_addumpdevice but do not know how or where to apply it.

Thanks in advance.

 

[tlbroadbent]

SQL Server will not recognize the drives mapped by the Windows login. You need to use the UNC.

BACKUP DATABASE MyDB TO DISK = '\\myserver\myshare\MyDB.bak' WITH INIT
Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it if you have time.

 

[clynch117]

Thanks, however my dilemma is where to apply this code. I am comfortable with UNC notation but do not know where to use it. Where does it go, I tried running code in the query analyzer but was not sure that it worked.

BTW I read the faq but was unclear as to why you pointed me to it.

Thanks.

 

[tlbroadbent]

[ol][li]The code I posted could be run in query analyzer. Of course, you'd need to modify to name you server, volume (share), database, etc. If you made appropriate changes and ran it; if it worked you should see a backup on the Novell volume. Make sure the SQL account has been granted permissions on the Novell volume.

[li]You can add a backup device in Enterprise manager on a Novell share using the UNC.

[li]The reference to the FAQ is part of my sig and was not directed to you personally. It appears on all my posts.[/ol] Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it if you have time.