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 inChapter 4,Database in the Sandbox:
- First let's create a full database backup of our
University
database:
1> BACKUP DATABASE University2> TO DISK = '/var/opt/mssql/data/University.bak'3> GOProcessed 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)
- Now let's check the content of the table
Students
:
1> USE University 2> GO Changed database context to 'University' 1> SELECT LastName...