find backup directory

[bdjensen]

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

[Simon Hayes]

"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

[toeho]

Create a backup device in enterprise manager. You can backup to network
locations this way.

[Greg D. Moore \(Strider\)]

"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