SQL Server 2008 Standby Database on a Network Drive

Question

I need to backup my SQL Server 2008 database on another PC on the network. I even mapped the network drive and assigned it another letter with the driver.

But when I try to select the .bak file when exporting, only C: appears. I even restarted SSMS.

Can someone point out what else I might need? Thank!

Answer 1

You can use sql

BACKUP DATABASE Foo TO DISK = '\\myserver\myshare\foo.bak' WITH INIT

Verify that the account used for sql services has sufficient permissions to write to another computer.

---

. , Sql , , .