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

[@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

[@venkateswarluguditi8461]

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

[@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.

[@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

[@bernarddsilva8050]

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

[@TechandArt]

Plz have a watch on Tech & Art

[@GoogleOwnYoutube]

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

[@mohitverma-zl5iw]

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

[@suvendudenre1304]

very helpful

[@DarkWorldQ8]

Thank you very much. You are a life saver

[@sangarmuhammad4879]

thanks for this video , really it is useful for bingers

[@katrothravinder7279]

Thanks sir. Very clear explanation

[@coreyrodgers6621]

Thank you, Manoj. This video was very helpful.

[@An_Urban_monk]

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

[@danish__official5374]

Thank you for this video, very nicely explained it.

[@boris-nathanrwe9878]

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

[@sujusuresh]

very clear instructions. Thank you

[@gilbertorogel81]

Lifesaver, thank you!

[@jeffottesen143]

Very well done. Thanks for sharing.

[@DannyMancheno]

0:00 Backup
3:57 Restore

[@MaheshD0351]

Thank you Sir, this is really helpful

[@sandeepchouhan8818]

Thanks Manoj, it helped me a lot

[@mohamedkunle528]

thank you sir you helped me alot

[@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

[@samia4452]

Thank you .. can you please show us an example of restoring dev database from production backup

[@BillSeipel]

Excellent

[@Maheshreddy9010]

awesome explanation cool and neat

[@thamodaran8811]

Thank You.....!!
very useful

[@djamelbek7506]

Thank you Dear nice video

[@itsmekars4311]

this helped me so much, thanks!

[@18SANABRIA]

Thank you so much! It was very useful!

[@devolosfombat7294]

you are just the best .straight to point

[@johnyshaik9844]

Superb

[@sansak9098]

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

[@SQLwithManoj]

yes, you can.

[@johnwzimmer405]

Thanks - a good overview

[@mohammadjunaidshaik2664]

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

[@lavanyak459]

Really helpful 🤩

[@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?

[@sureshentertainments8845]

Very nice

[@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?

[@TechandArt]

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

[@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 !!!

[@dennisharris144]

great video this is very helpful

[@adikunam2093]

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

[@kashmeershaik9217]

Nice video very usefull

[@Shiva-wy4ln]

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

[@junaid_aslam]

Does the backup include sequence objects and triggers as well?

[@Priyaravind23]

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

[@RajeshVerma-ud2tz]

super explain

[@maheswaranshanmugavelu6345]

thank you Manoj

[@malleshrao3243]

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

[@satishmen66]

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

[@oaissiddique15]

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

[@tamahesh]

Does database in the second node has to be down?

[@marianocalzada6472]

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

[@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

[@altafraza372]

Thank You So Much Sir .

[@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

[@rvmyangalstar2024]

Each and every step superb sir.....

[@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

[@davaasurenjj]

THANK YOU

[@ubaidqureshi1451]

well explained...!!

[@rakeshkadam958]

Thank you!

[@Uattrakhandwala]

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

[@dinujakaveeshwara867]

Thank you

[@TheArsalanali]

It give error access is denied in sql2012

[@pawe1709]

how put database from back?

[@PunjabiKush]

3:55 for Restoring Database

[@ganesh86ful]

Very good explanation. Can undstd easily.

[@tamahesh]

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

[@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 .

[@aboothurabc.k2303]

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

[@mahmudurkhan5754]

Thank you so much Sir

[@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

[@altafraza372]

Please Make a Videos MSBI.

[@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 th-cam.com/video/mr8Lpkx5yag/w-d-xo.html

[@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