Backing up to a network location

To create a backup of a database (as a .bak file) in a specified network location, use the following script:

BACKUP database [Database name] TO DISK = '\\servername\share\filename.bak'

Example: Backup database [Dentrix] TO DISK = '\\bcrosby12345\e\backup\dxebackup.bak'.

You should get results similar to the following after running the script:

Processed 75960 pages for database 'Dentrix', file 'Dentrix_Data' on file 1.

Processed 8 pages for database 'Dentrix', file 'Dentrix_Log' on file 1.

BACKUP DATABASE successfully processed 75968 pages in 99.330 seconds (5.975 MB/sec).

Note: There are other command lines that you can add, such as Checksum to verify integrity and other methods based on if you want to back up a file, filegroup, or a certain table.