Reputation: 5048
I need to backup my SQL Server 2008 database to another PC on network. I've even mapped network drive and assigned it another driver letter.
But when I try to select .bak file while exporting, only C: shows up. I've even restarted my SSMS.
Can somebody point out what else I may need to do? Thanks!
Upvotes: 3
Views: 15058
Reputation: 11756
You can by using SQL
BACKUP DATABASE Foo TO DISK = '\\myserver\myshare\foo.bak' WITH INIT
Make sure the account used for the sql services has enough rights to write to the other pc.
For the reason the mapped network drives don't show up made with your user account. This has to do with the Sql Server service running under another user account then the one you've used for mapping the drive.
Upvotes: 4