To restore a backup of a database (using a .bak file) from a specified network location, use the following script:
Restore database [database] FROM DISK = '\\servername\share\backupfile.bak' WITH REPLACE
Example: RESTORE database [Dentrix2] FROM DISK = '\\bcrosby12345\e\backup\dxebackup.bak' WITH REPLACE.
You should get results similar to the following after running the script:
Processed 75960 pages for database 'Dentrix2', file 'Dentrix_Data' on file 1.
Processed 8 pages for database 'Dentrix2', file 'Dentrix_Log' on file 1.
RESTORE DATABASE successfully processed 75968 pages in 97.812 seconds (6.067 MB/sec).