sql

Question

hi,

when i give system name and folder name in run. i face this problem

ex:\\vivek\\backup

error

network path was not fond 

---

vivek

Answer 1

BACKUP DATABASE dbname TO DISK = 
    N'\\SERVER\sharedfolder\dbname.BAK' 

---

Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Answer 2

Hi vivek,

What is the detailed scenario of your question? If you want to back up you database on a network shared folder. The script provided by Uri is correct.
By the way, please check whether folder '\\vivek\\backup' has been shared and SQL Service account has FULL CONTROL permissions on his folder which is in NTFS format.

---

Best Regards,
Peja

Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.