CODEWITHSUNDEEP
databasesql-server-2008backup
Vishal Seth
Vishal Seth

Reputation: 5048

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? Thanks!

Upvotes: 3

Views: 15058

Answers (1)

Ralf de Kleine
Ralf de Kleine

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

Related Questions