locked
sql RRS feed

  • 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

    Monday, April 23, 2012 6:21 AM

Answers

  • 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/

    • Proposed as answer by PrinceLucifer Monday, April 23, 2012 9:54 AM
    • Marked as answer by Peja Tao Monday, April 30, 2012 1:59 AM
    Monday, April 23, 2012 7:10 AM
  • 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.

    • Marked as answer by Peja Tao Monday, April 30, 2012 1:59 AM
    Tuesday, April 24, 2012 3:07 AM

All replies

  • 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/

    • Proposed as answer by PrinceLucifer Monday, April 23, 2012 9:54 AM
    • Marked as answer by Peja Tao Monday, April 30, 2012 1:59 AM
    Monday, April 23, 2012 7:10 AM
  • 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.

    • Marked as answer by Peja Tao Monday, April 30, 2012 1:59 AM
    Tuesday, April 24, 2012 3:07 AM