Backup Devices - Part 2 | Microsoft SQL Server | Data Science | Business Continuity
#sqlserver #sqlforbeginners #sqlab #database #databasesystems #sql #sqltips #databaseconcepts #databases #databaseprogramming #databasedevelopment #databaseadmin #ssis #ssms #indexing #backupdata #sqlinterviewquestions #sqltraining
#sqltutorial #sqltutorials #sqltutorialforbeginners #sqlcourse #sqlcommands #sqlquery #sqlqueries #backup #data #databackup #datacommunity #datacamp #datadrivensuccess #dataengineering #dataengineer #dataengineers #dataengineeringessentials
In this video part 2, we have started our conversation with Tape Devices. We have specified how you can specify a backup tape using its physical name while taking backup. We have talked about tape-specific backup and restore options i.e. NOUNLOAD | UNLOAD and REQIND | NOREWIND.
We then continued discussing about Logical Backup devices and have demonstrated how to create one and how to use that logical backup device, in place of actual physical backup device, while taking backups. We talked about advantages of using the Logical Backup Device and discussed about a procedure on how to switch the old physical device with a new one, when we are using Logical Backup Devices.
We briefly discussed about mirrored media sets and also about archiving SQL Server Backups.
My Channel Page : / @masterdatasciencewithvineet
SQL Server Database Design Playlist : • SQL Server - Database Design Video Li...
Business Continuity Playlist : • SQL Server - Business Continuity
SQL Server Indexing Playlist : • SQL Server - Indexes
SQL Server Performance Tuning Playlist : • SQL Server - Performance Tuning
SQL Server Integration Services Playlist : • SQL Server Integration Services
SQL Server Tables Playlist : • SQL Server - Tables
