none
DB Restoration from NAS RRS feed

  • Question

  • Hi all,

      We have to restore a database,  for which backup is on NAS. We are unable to restore is in normal way. Can any one let us know how to restore the DB from NAS share. We  can't move backup to local drive since the backup file size uis very huge.

    Regards,

    varun

    Thursday, January 28, 2016 9:21 AM

Answers

  • Hello Varun,

    SSMS don't support to select a backup file from an UNC path (NAS), but you could map the UNC path as a local drive.

    And the RESTORE (Transact-SQL) command supports to address UNC paths like

    RESTORE DATABASE AdventureWorks2012
    FROM DISK = '\\Nas\AdventureWorks2012.bak' 
    RECOVERY;


    Olaf Helper

    [ Blog] [ Xing] [ MVP]


    • Proposed as answer by Chetan Vishwakarma Thursday, January 28, 2016 9:40 AM
    • Edited by Olaf HelperMVP Thursday, January 28, 2016 9:42 AM
    • Marked as answer by Raje14 Thursday, January 28, 2016 10:28 AM
    Thursday, January 28, 2016 9:37 AM