General discussion

Locked

SQL Server Backup

By mrlaw10 ·
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?

This conversation is currently closed to new comments.

8 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

SQL Server Backup

by TimTheToolMan In reply to SQL Server Backup

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.

Collapse -

SQL Server Backup

by TimTheToolMan In reply to SQL Server Backup

D'oh. First line, third word... "cant"

Collapse -

SQL Server Backup

by mrlaw10 In reply to SQL Server Backup

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?

Collapse -

SQL Server Backup

by TimTheToolMan In reply to SQL Server Backup

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.

Collapse -

SQL Server Backup

by mrlaw10 In reply to SQL Server Backup

The question was auto-closed by TechRepublic

Collapse -

SQL Server Backup

by jurasek In reply to SQL Server Backup

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.

Collapse -

SQL Server Backup

by mrlaw10 In reply to SQL Server Backup

The question was auto-closed by TechRepublic

Collapse -

SQL Server Backup

by mrlaw10 In reply to SQL Server Backup

This question was auto closed due to inactivity

Back to Networks Forum
8 total posts (Page 1 of 1)  

Related Forums