Restore Database from a Network Path in SQL Management Studio

There’s a lot of times when people need to restore databases from a network (UNC) path.  There are two ways of doing this:

  • By giving the path in the RESTORE DATABASE command like:
    RESTORE DATABASE FROM DISK = \\server_name\shared_drive\backup_file_name.bak
  • By giving the path of the file (\\server_name\shared_drive\backup_file_name.bak) in the management studio restore wizard

Read more