开发者

backup SQL Server 2008 database on a network drive

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? Than开发者_开发问答ks!


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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜