Backup and restore

Now it's time for SQL coding and implementing backup/restore operations in our own environments. We will use the University database that you created in Chapter 4, Database in the Sandbox:

1. First let's create a full database backup of our University database:

        1> BACKUP DATABASE University
        2> TO DISK = '/var/opt/mssql/data/University.bak'
        3> GO
        
        Processed 376 pages for database'University', file 'University' on file 1.
        Processed 7 pages for database 'University', file 'University_log' on file 1.
        BACKUP DATABASE successfully processed 383 pages in 0.562 seconds (5.324 MB/sec)

2. Now let's check the content of the table Students:

        1> USE University                                                                      ...