Backup and Restore Database in SQL Server

Backup and Restore Database in SQL Server
"SQL Server Basics" series: • SQL Server Basics
#SQLwithManoj #SQLServer #SQLServerBasics #DatabaseBasics
SQL blog at: sqlwithmanoj.com/
LinkedIn: / manub22
Facebook: / sqlwithmanoj
Telegram: t.me/sqlwithmanoj

[@xiellesky5527]

Thank you for that, this was really helpful because I don't know what to do. It's to the point and just what I needed

[@An_Urban_monk]

Manoj, thanks for this video. Concise and fat-free!

[@coreyrodgers6621]

Thank you, Manoj. This video was very helpful.

[@GoogleOwnYoutube]

That seemed very easy when you showed it like that. Thanks alot

[@S2100211]

Thanks for taking the time to make this video. It was a very good explanation and has been very helpful. I do this type of backup and resore once every 18 or 24 months so don't practice this type of thing very often. This has made my job a lot more easy. Thanks

[@dazyparker1988]

Thank you so much, Manoj for sharing this video. In my case, the backup was not updated so, I tried Stellar SQL database repair software. I also read about this software in your blog.

[@TechandArt]

Plz have a watch on Tech & Art

[@johnwzimmer405]

Thanks - a good overview

[@18SANABRIA]

Thank you so much! It was very useful!

[@gilbertorogel81]

Lifesaver, thank you!

[@bernarddsilva8050]

Thanks for a great video on backup and restore. Brief and concise.

[@TechandArt]

Plz have a watch on Tech & Art

[@barbaraulitsky9055]

Thank you so much for sharing your knowledge with us, Manoj! This video was very helpful for me in my work!

[@TechandArt]

Plz have a watch on Tech & Art

[@shazwanisbintiabdulaziz1188]

This video is good for user that are beginner for database administrator. It shows the way how backup and restore function. This video show the strategy by restore a set of backups, then recover user database to prepare you to respond productively to a disasters.

[@DarkWorldQ8]

Thank you very much. You are a life saver

[@danish__official5374]

Thank you for this video, very nicely explained it.

[@itsmekars4311]

this helped me so much, thanks!

[@dennisharris144]

great video this is very helpful

[@mohitverma-zl5iw]

Thank you so much for sharing your knowledge with us, Manoj This video was very helpful for me in my work!

[@jeffottesen143]

Very well done. Thanks for sharing.

[@sujusuresh]

very clear instructions. Thank you

[@boris-nathanrwe9878]

keep on making videos man u out here making me pass my classes hhh

[@thamodaran8811]

Thank You.....!!
very useful

[@venkateswarluguditi8461]

Superb bro..thank u soo much..
keep going like this type of videos which is helpful to others

[@davaasurenjj]

THANK YOU

[@Maheshreddy9010]

awesome explanation cool and neat

[@MichaelNickolai]

could you comment on what are some of the things that you need to configure / copy manually when doing backup & restore to a new server? eg linked databases and credentials?

[@adikunam2093]

In ur tutorial Is there difference between simple , t-log and bulk-logged backup

[@sandeepchouhan8818]

Thanks Manoj, it helped me a lot

[@rakeshkadam958]

Thank you!

[@junaid_aslam]

Does the backup include sequence objects and triggers as well?

[@katrothravinder7279]

Thanks sir. Very clear explanation

[@ubaidqureshi1451]

well explained...!!

[@tamahesh]

Does database in the second node has to be down?

[@BillSeipel]

Excellent

[@fernandomaximotorres]

Does the label "(Restoring...)" next to database name on Object Explorer, appears also during automatic Backup?? it is very important for me to know every case that label can be shown there. Thanks

[@djamelbek7506]

Thank you Dear nice video

[@tamahesh]

how to backup and restore database when database is configured with failover clustering

[@dinujakaveeshwara867]

Thank you

[@mohamedkunle528]

thank you sir you helped me alot

[@MaheshD0351]

Thank you Sir, this is really helpful

[@maheswaranshanmugavelu6345]

thank you Manoj

[@kashmeershaik9217]

Nice video very usefull

[@lavanyak459]

Really helpful 🤩

[@sureshentertainments8845]

Very nice

[@suvendudenre1304]

very helpful

[@johnyshaik9844]

Superb

[@RajeshVerma-ud2tz]

super explain

[@shoofly9403]

If you make a back up of your SQL database, and you want to restore it to another SQL server node, do you have to have a common security user/password on this new SQL server node to be able to restore or access the new database?

[@marianocalzada6472]

doesnt anyone knows why sqlserver is not showing me the backup the log? only either differential or complete?

[@TechandArt]

Thanks for sharing good one👍 but I have created another easy way to do..... thx

[@adamalabtah8034]

Thank you Manjo, really appreciated!. is it possible to show us how we can we sit Automatic backup. for instance daily or weekly ...etc.

[@misbakhan2758]

Maintenance plan, configuring jobs

[@Priyaravind23]

Pls add more videos for AlwaysOn, performance tuning and stuffs please

[@DannyMancheno]

0:00 Backup
3:57 Restore

[@Shiva-wy4ln]

HI ,
Can I create a new db from existing file .If so , how ?
Please guide.

[@deepahosur4893]

Hello Manoj...
Have taken mysql back up and now restoring that into db through cmd. But its showing an error as the specific file cant speicified.. So can you please help me to reslove this issue? It's urgent

[@SQLwithManoj]

Hi Deepa, I've not use MySQL, but can you reply with the exact error?

[@TechandArt]

Plz have a watch on Tech & Art

[@malleshrao3243]

Very Informative sir, my Back up won't appears while I try to restore it, any suggestions sir

[@oaissiddique15]

Hi... Can u explain us how to automatically restore db and trn files through jobs in sql

[@satishmen66]

I am getting error while using "Copy Database " wizard. Can you please help me

[@mohammadjunaidshaik2664]

Is there future for sql server dba?????

[@TheArsalanali]

It give error access is denied in sql2012

[@pawe1709]

how put database from back?

[@Rackerintraining]

How do we import TestManDB...this is not included in 2014 and not part of Adventureworks

[@SQLwithManoj]

This DB was created by me in some previous video. You can create a new DB, and proceed ahead.

[@Rackerintraining]

Hi, I just started from your SQL Basics playlist and am going in order. Thank you for reply. I will create a new DB and try to follow along unless you have a way to import what is in that particular DB for people going through the playlist -Thx

[@gparekh]

hello Can you tell me how to create new database from existing database. It's kinda urgent. thanks

[@SQLwithManoj]

Do you want to create a copy of an existing Database, or create a new database?

[@gparekh]

1. so database already in access and created all empty table in sql server 2016 so now wants to add data from access.
2.How to Building a trainee database for testing.

[@SQLwithManoj]

You can create a backup of the database and restore it with different name, check my video on backup & restore czcams.com/video/mr8Lpkx5yag/video.html

[@Garhwaliladkaukwala]

Ram ram shab mere pkg me memo option hai wo double click karne se bhi open nahi ho raha hai

[@sansak9098]

is it possible to restore from one server backup to another server, pls let me know.

[@SQLwithManoj]

yes, you can.

[@mahmudurkhan5754]

Thank you so much Sir

[@vivekatnoida]

Please upload a video of diff ways of how to resolve the issue of Availability group unhealthy database in case of large database . .........If you already made such ,please give me that link .Or anyone have someone suggestions please guide me .

[@altafraza372]

Please Make a Videos MSBI.

[@devolosfombat7294]

you are just the best .straight to point

[@sagarkashid123]

Server 1 db1 backup restore on Server2 ABC database,
ABC db existing data will loss. Please make one demo here this will help for new guys in DBA

[@adaobinwofor5527]

Hi Manoj please whats the difference between Refresh and Restore?

[@SQLwithManoj]

Well, there is no such "REFRESH" term with database, at least with SQL Server that I know of. But yes, we use "Refresh Database" term while restoring PROD backup to our DEV server.

[@adaobinwofor5527]

@@SQLwithManoj but will refresh be used in terms of imp nd exp

[@SQLwithManoj]

@@adaobinwofor5527 yes, you can say that !!!

[@sunnysingh8483]

3:55 for Restoring Database

[@jaganharshachickencentre5344]

Each and every step superb sir.....

[@altafraza372]

Thank You So Much Sir .

[@ganesh86ful]

Very good explanation. Can undstd easily.

[@aboothurabc.k2303]

Thank you so much sir, i really appreciate it............ Have one request dont go toooo fast ;)