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 (

For more on how to do backups and restores using T-SQL check out my other video:

#sqlserver #backup #restore

-~-~~-~~~-~~-~-
Please watch: “Extended Events Live Data Window ”

-~-~~-~~~-~~-~-

Nguồn:https://dantrithegioi.com/

36 Comments

Martin Cox

March 25, 2020

Hi Grant, thanks for sharing this information. I also follow your blog. Today, I read this blog on sqlservercentral and found it useful: https://www.sqlservercentral.com/blogs/sql-server-backup-and-restore-strategy-step-by-step

Reply

Mahlet Boyd

March 25, 2020

you are awesome

Reply

Sachin Jadhav

March 25, 2020

Short and nice explaination!!!

Reply

Vipassana Zen

March 25, 2020

Hello I am curious why your database icon green on some of them, Thanks for a great tutorial, very helpful!

Reply

Rocky

March 25, 2020

That's awesome video !

Reply

1337S0lja

March 25, 2020

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.

Reply

أعالي البحار لاستيراد السيارات من كندا

March 25, 2020

thanks a lot for the great demo. It helped me a lot

Reply

Roberto Rodriguez

March 25, 2020

What happend if you change again the recovery model from full to simple?

Reply

Sơn Kim

March 25, 2020

nice video

Reply

umesh naik

March 25, 2020

Nice video !!

Reply

Kenath Perera

March 25, 2020

thank you very much Sir!!!!!

Reply

Michael Okonji

March 25, 2020

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!

Reply

Prashant Wadekar

March 25, 2020

Thanks for giving us the detailed information of Back up and restore of sql

Reply

ross

March 25, 2020

What if I want to backup to a mapped network drive? I cannot see those drives when I go to pick where the backup is stored.

Reply

ahpitre

March 25, 2020

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.

Reply

Marsellus Wallace

March 25, 2020

Awesome, thanks!

Reply

sarath chandra

March 25, 2020

Awesome video ! Thank you very much. Grant Fritchey

Reply

Sarv Atam

March 25, 2020

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

Reply

Mohammed Mustafa

March 25, 2020

IT WORKS

Reply

elcool

March 25, 2020

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.  

Reply

Mizanur Rahman

March 25, 2020

mann  after    watch  this  video  back up is  clear   to me  thx from my heart boss

Reply

Anurag Taneja

March 25, 2020

That really helped me.Thanks.:)

Reply

New York Junky

March 25, 2020

Awesome. what additional options are you using in the Management Studio? I don't see my IntelliSense as smart as your

Reply

LaGazetteDuF2P

March 25, 2020

thx bro' you definitely make my day

Reply

Navjot Singh

March 25, 2020

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!

Reply

Tunasty

March 25, 2020

Really great tutorial! I feel so confident now

Reply

athreya vc

March 25, 2020

Awesome 

Reply

Eobard Thawne

March 25, 2020

Already 10 minutes into it 🙂

Reply

Grant Fritchey

March 25, 2020

Thanks. I've got another video on how to use T-SQL to do everything instead of the GUI. You might to take a look at that too.

Reply

Eobard Thawne

March 25, 2020

Fantastic work here. Made everything easy to understand.

Reply

Md Monirul

March 25, 2020

nice and helpfull

Reply

Grant Fritchey

March 25, 2020

Thanks. Glad it's useful. I've added another on doing the same stuff using just T-SQL. Can't link in the comments, but you can look it up under my channel.

Reply

Khalid Chabar

March 25, 2020

Great job on this video!

Reply

Grant Fritchey

March 25, 2020

Thanks. Plans are to expand on this a bunch in the coming months, so watch this space for more.

Reply

CodeBreaker

March 25, 2020

Grant.. Highly appreciated mate.. Loved your way of explaining it. Mo!

Reply

Syed Rafey

March 25, 2020

Very nice and helpful!!

Reply

Leave a Reply