Backup and Restore Database in SQL Server
Вставка
- Опубліковано 6 вер 2024
- 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
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.
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
Superb bro..thank u soo much..
keep going like this type of videos which is helpful to others
is it possible to restore from one server backup to another server, pls let me know.
yes, you can.
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
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.
Plz have a watch on Tech & Art
Thank you .. can you please show us an example of restoring dev database from production backup
0:00 Backup
3:57 Restore
Thank you so much for sharing your knowledge with us, Manoj This video was very helpful for me in my work!
Excellent
thank you sir you helped me alot
very helpful
That seemed very easy when you showed it like that. Thanks alot
Thank you very much. You are a life saver
Lifesaver, thank you!
Thanks for a great video on backup and restore. Brief and concise.
Plz have a watch on Tech & Art
Thanks sir. Very clear explanation
Thank you for this video, very nicely explained it.
Thanks Manoj, it helped me a lot
keep on making videos man u out here making me pass my classes hhh
Very well done. Thanks for sharing.
Thank you Dear nice video
Superb
you are just the best .straight to point
Thank you Sir, this is really helpful
Thank you, Manoj. This video was very helpful.
awesome explanation cool and neat
very clear instructions. Thank you
Manoj, thanks for this video. Concise and fat-free!
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?
Very nice
Thank you so much for sharing your knowledge with us, Manoj! This video was very helpful for me in my work!
Plz have a watch on Tech & Art
Thank You So Much Sir .
Thank You.....!!
very useful
Pls add more videos for AlwaysOn, performance tuning and stuffs please
this helped me so much, thanks!
Thank you Manjo, really appreciated!. is it possible to show us how we can we sit Automatic backup. for instance daily or weekly ...etc.
Maintenance plan, configuring jobs
Hi... Can u explain us how to automatically restore db and trn files through jobs in sql
In ur tutorial Is there difference between simple , t-log and bulk-logged backup
Very Informative sir, my Back up won't appears while I try to restore it, any suggestions sir
Thanks - a good overview
Thank you so much! It was very useful!
Is there future for sql server dba?????
Each and every step superb sir.....
Hi Manoj please whats the difference between Refresh and Restore?
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.
@@SQLwithManoj but will refresh be used in terms of imp nd exp
@@adaobinwofor5527 yes, you can say that !!!
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?
Really helpful 🤩
Thanks for sharing good one👍 but I have created another easy way to do..... thx
3:55 for Restoring Database
great video this is very helpful
Nice video very usefull
HI ,
Can I create a new db from existing file .If so , how ?
Please guide.
thank you Manoj
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
Hi Deepa, I've not use MySQL, but can you reply with the exact error?
Plz have a watch on Tech & Art
I am getting error while using "Copy Database " wizard. Can you please help me
THANK YOU
doesnt anyone knows why sqlserver is not showing me the backup the log? only either differential or complete?
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 .
super explain
Does database in the second node has to be down?
Thank you!
Does the backup include sequence objects and triggers as well?
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
well explained...!!
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
Thank you
how to backup and restore database when database is configured with failover clustering
It give error access is denied in sql2012
Ram ram shab mere pkg me memo option hai wo double click karne se bhi open nahi ho raha hai
how put database from back?
hello Can you tell me how to create new database from existing database. It's kinda urgent. thanks
Do you want to create a copy of an existing Database, or create a new database?
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.
You can create a backup of the database and restore it with different name, check my video on backup & restore ua-cam.com/video/mr8Lpkx5yag/v-deo.html
Please Make a Videos MSBI.
Thank you so much Sir
How do we import TestManDB...this is not included in 2014 and not part of Adventureworks
This DB was created by me in some previous video. You can create a new DB, and proceed ahead.
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
Very good explanation. Can undstd easily.
Thank you so much sir, i really appreciate it............ Have one request dont go toooo fast ;)