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.
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.
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!
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!
+Michael Okonji Thank you. I'm using a tool called SQL Prompt from my employer, Redgate Software. That does the advanced type-ahead as well as code formatting and a bunch of other stuff.www.red-gate.com/products/sql-development/sql-prompt/
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
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.
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.
![Noob To Max With DRAGON REWORK In Blox Fruits [FULL MOVIE]](http://i.ytimg.com/vi/LnBMOinoOvA/mqdefault.jpg)
Yeah man, plain simple and easy to digest. Good work 👍
Cheers! Still mostly applies to 2019 too. Check out the other video on using T-SQL to accomplish the same thing.
Grant Fritchey Sure Grant, will do 👍
That's another Red Gate product called SQL Prompt. I could not live without it, for what you saw and a whole bunch of other reasons.
Mr. Scary DBA, Thank you, Thank you, thank you!
Not a problem. Happy to help. Let me know if there's another topic you could use a video on.
Thanks for giving us the detailed information of Back up and restore of sql
Thanks. Plans are to expand on this a bunch in the coming months, so watch this space for more.
Short and nice explaination!!!
Thank you! Glad you found it useful.
It really cleared my doubts in backups and restore.
Grant.. Highly appreciated mate.. Loved your way of explaining it. Mo!
Fantastic work here. Made everything easy to understand.
great work man....fabulous explanation..god bless u
Thanks you so much for uploading this video in youtube ,it is really very helpful for me ...thanks man
thanks a lot for the great demo. It helped me a lot
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.
That's a Red Gate Software tool called SQL Prompt.
mann after watch this video back up is clear to me thx from my heart boss
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.
Thank you so much. Nice insight for beginners.
That's awesome video !
Thank you. I also added another on how to use T-SQL to do the same thing.
Hello I am curious why your database icon green on some of them, Thanks for a great tutorial, very helpful!
Thank you. That's a third party tool, Redgate SQL Source Control, marking those databases as being in source control.
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.
thx bro' you definitely make my day
Very nice and helpful!!
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!
In this case, no. You can, and should, verify a log backup in the same way you do any other backup.
Awesome. what additional options are you using in the Management Studio? I don't see my IntelliSense as smart as your
Great job on this video!
Nice video to understand for learners...
you are awesome
Thank you for the kind words. Make sure you look at the T-SQL video on backups as well.
Awesome video ! Thank you very much. Grant Fritchey
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!
+Michael Okonji Thank you. I'm using a tool called SQL Prompt from my employer, Redgate Software. That does the advanced type-ahead as well as code formatting and a bunch of other stuff.www.red-gate.com/products/sql-development/sql-prompt/
+Grant Fritchey Alright! Thank you!!
That really helped me.Thanks.:)
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.
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
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.
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.
Generally, yes. The processing time for compression usually far offsets the time saved by writing less to disk.
What happend if you change again the recovery model from full to simple?
Awesome, thanks!
IT WORKS
Nice video !!
thank you very much Sir!!!!!
Glad it was useful.
Thank you!
Thanks. I sure try to help.
thanks for the help....
thanks alot grant..
Already 10 minutes into it :)
nice and helpfull
nice video