471,873 Members | 2,040 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,873 software developers and data experts.

find backup directory

Hello!
MSQL2000:
I want to make db-backup (maintenance) but haven't enough space on the
discs that are physically in the machine. I have enough on the network, but
i can't choose an network-drive, when
i want to specify the backup directory.

What to do?
/Bjørn
Jul 20 '05 #1
3 3219
"bdjensen" <b.***************@gmx.net> wrote in message news:<3f***********************@dread11.news.tele. dk>...
Hello!
MSQL2000:
I want to make db-backup (maintenance) but haven't enough space on the
discs that are physically in the machine. I have enough on the network, but
i can't choose an network-drive, when
i want to specify the backup directory.

What to do?
/Bjørn


Enterprise Manager only displays the local drives, but you can just
type in the UNC path: \\Server\Share\Folder.

Simon
Jul 20 '05 #2
Create a backup device in enterprise manager. You can backup to network
locations this way.
Jul 20 '05 #3

"bdjensen" <b.***************@gmx.net> wrote in message
news:3f***********************@dread11.news.tele.d k...
Hello!
MSQL2000:
I want to make db-backup (maintenance) but haven't enough space on the
discs that are physically in the machine. I have enough on the network, but i can't choose an network-drive, when
i want to specify the backup directory.

Note, as others have said, you can use UNC paths. However, SQL Server Agent
must be running in a user context that can map those drives w/o human
intervention.

What to do?
/Bjørn

Jul 20 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by James | last post: by
1 post views Thread by Pierre-Yves | last post: by
6 posts views Thread by Steven | last post: by
1 post views Thread by microsoft . public . sqlserver | last post: by
8 posts views Thread by k.i.n.g. | last post: by
reply views Thread by YellowAndGreen | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.