Introduction to SQL Server Database Backup and Restore

Author: Grant Fritchey
153058 View
22m 6s Lenght
269 Rating

This video introduces the concepts of the backup and restore for SQL Server. It's meant to be a companion piece to this article on Backup and Restore for the Accidental DBA (http://www.simple-talk.com/sql/database-administration/sql-server-backup-and-restore-for-the-accidental-dba/) For more on how to do backups and restores using T-SQL check out my other video: http://www.youtube.com/watch?v=ITXPTviK2dQ

Comments

  1. Had a break/fix client who had a hdd crash. All we could get was the MSQL directory from the .vhdx image (Which we couldnt restore because the image itself was corrupted....). I have yet to see a way that you can restore by using just the raw data included in the MSQL directory. If someone could point me in the right direction, it would be much appreciated. Most of our clients are break/fix, small town environment. People don't like contracts.
  2. thanks a lot for the great demo. It helped me a lot
  3. What happend if you change again the recovery model from full to simple?
  4. nice video
  5. Nice video !!
  6. thank you very much Sir!!!!!
  7. Nice video Grant Fritchey, can you tell me how you have your ssms setup in a way that it pulls up suggestions for you while you type commands in the query window? it seems to be doing more than intellisense at 12:50 . would be glad if you can show me how to set that up. Thanks in advance!
  8. Thanks for giving us the detailed information of Back up and restore of sql
  9. Are you really increasing speed if you select compression? My experience while using backup software (for Sql, or simply for Windows/Apps/Data is that compression saves storage space, but increases the time it takes to backup as the software needs to 1st compress, then store the data.
  10. Awesome, thanks!
  11. Awesome video ! Thank you very much. Grant Fritchey
  12. Hi, my server failed, i rebuilt it...i have acronis backups of the old drive, i'm trying to get the ms bcm database back on new install but i cant go around to it. I mounted the backup as E drive and can see the mdb and log files, how do i copy into the new server install? thx
  13. IT WORKS
  14. What is that autocomplete tool you're using at 12:50 ? BTW, Excellent video. I finally understood the theory behind those simple and full recovery options and the norecovery.  
  15. mann  after    watch  this  video  back up is  clear   to me  thx from my heart boss
  16. That really helped me.Thanks.:)
  17. Awesome. what additional options are you using in the Management Studio? I don't see my IntelliSense as smart as your
  18. thx bro' you definitely make my day
  19. Job well done Grant!
    One question for you, is there a particular reason why you left VERIFY BACKUP unchecked while doing tlog backup compared to a full backup. Looking forward to your response, thanks!