Networks

Ask something
Discussion Locked

SQL Server Backup

0 helpful
8 replies

by mrlaw10 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Using SQL server backup wizard (named create Database Backup Wizard) and I get to the 4th page of wizard to select dstination and I want to send it to a mapped drive letter E: (a zip drive) but it will only show me the local drives under the file button...what am I missing here?

8 replies

by timthetoolman

Hi,

Although I can remember the screen exactly, I'm fairly sure that this will be by design. SQL backups can happen as tasks - and these will not necessarily have mapped drives present.

Afterall if a scheduled task starts up automatically in the background, what mapped drives does it have? none.

Hopefully you should be able to specify a full share name instead. For exmple...

\\ZIPserver\ZIPshare

Naturally, you'll need to set the ZIP drive up as an actual share on the machine its attached to.

Hope this helps - as I said, I cant recall the exact screen so I'm not sure what you'll be able to enter.

Cheers,
Tim.

by mrlaw10

Tim, Thanks for your comments but I do have the drive shared and even mapped out on the server as a drive letter. I can see other physical drives (C,D) but no virutal ones. That is exactly where I am hung on that forth wizard screen. How do I getit to see the virtual drives that I have created?

by timthetoolman

Hi,

Thats what I'm saying... You wont be able to see it! Hopefully there will be a spot for you to manually enter the...

\\server\share

information, rather than choose it from a browser popup?

Cheers,
Tim.

by jurasek

I don't believe it is possible to backup to a hard drive that is not local to the machine.

Therefore, I would handle this situation by either using a DTS Package or a SQL script to first do a local backup and then automate the regular copy of the *.bak file.

This discussion is closed to new replies.