backup SQL Server 2008 database on a network drive

Question

Hi,

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!

Answer 1

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.