Geek asks and answers

Backup and restore from the network

I can log in to SQL Server installed on "Machine A". Now I need Backupthe database (say "DB_A") of "Machine A" on my local drive so that I can Restoredatabase on my SQL Server computer. I tried this one but gets errors.

+3
source share
3 answers

I could do that. I did the following

  • Create a folder on your PC, say MySharedDB.

  • Set folder permissions as follows

    enter image description here

  • Then in the SSMS backup window add the UNC path \\rauf\MySharedDBtoDestination

0
source

You cannot do this directly.

SQL Server - UNC, SQL Server , .

: , , SQL Server . .

+3

marc_s, SQL Server UNC.
SQL Server Management Studio, , .
UNC-, T-SQL:

So, you need to create a shared folder on your computer and back up from the server via T-SQL.
On the other hand, you do not need to create a shared folder on the machine . You can backup the server in any shared folder and restore there. Or you can create a backup locally on the server, make the backup folder on the server a public folder and restore the backup directly to your computer.

+1
source

More articles:


All Articles