Understanding database backups in MS SQL Server 2008 R2

Author: techytube
36206 View
10m 59s Lenght
66 Rating

For more videos on technology, visit http://www.Techytube.com By Jayanth@techytube, http://www.techytube.com/author/jayanth-kurup/ This video covers a basic introduction to database backups within MS SQL Server 2008 R2. The approach is very similar to that of SQL 2005 and 2012 so the video is relevant for almost all version of MS SQL. The video covers a basic introduction to what gets backed up and the role of the recovery models in the backup and restore options. The video then moves on the explain what the different recovery models are and finally shows the user how to take a FULL database backup with compression of the Adventure works database in simple recovery model. The video is the first of a series of videos on MS SQL Server backup and restore technologies and covers many aspects that need to be considered as part of implementing a successful disaster recovery plan.

Comments

  1. Thanks, it is very useful!
    But you didn't tell about how to make backups with the help of MS-SQL Server.
    I found some articles about backups - check it here http://sqlbak.com/academy/
  2. Thanks for your great feedback , on to the next video
  3. thanks !
  4. Exactly what I was looking for! Thank you for making this tutorial.
  5. Thank you very much, the tutorial was very helpful.
  6. great speaker .
  7. Very good Tutorial. clear simple and contains everything I need to know about the database
  8. Good video, simple explanation. Thanks
  9. good stuff. thx