none
How to restore database backup (.bak ) file from shared network drive

    Question

  • HI Guys,

     

    I tried to restore the backup thru shared Network drive but got some error which described that sql server not able to find the path.

     

    Please advice if it is possible to restore the (.baK) file thru the shared network drive


    Rajan
    Wednesday, November 30, 2011 5:28 AM

Answers

  • Hi,

    Just map the network drive using 'XP_CMDSHELL net use' query. Then u mentioned the mapped drive address to restore the database easily.

     


    Regards, RM Thirunavukkarasu CAPM,ITIL,MCITP,MCP,SIX Sigma GB Certified <http://thiruna.blog.com/>
    • Proposed as answer by Peja Tao Thursday, December 01, 2011 2:10 AM
    • Marked as answer by Peja Tao Tuesday, December 06, 2011 3:41 AM
    Wednesday, November 30, 2011 6:13 AM
  • Normally system error 5 is access denied.

    Check the N/W folder it has everyone access permission or add a service account ID to that folder.

     



    Muthukkumaran Kaliyamoorthy

    Helping SQL DBAs and Developers >>> SqlserverBlogForum
    • Proposed as answer by Peja Tao Thursday, December 01, 2011 2:10 AM
    • Marked as answer by Peja Tao Tuesday, December 06, 2011 3:41 AM
    Wednesday, November 30, 2011 12:13 PM

All replies