469,090 Members | 1,204 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,090 developers. It's quick & easy.

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 3164
"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
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.