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