Video size: 1280 X 720853 X 480640 X 360
Show player controls
it can't restore stored procedures
thankyou, very useful, very clear
Wow it's very easy
the option transaction log in backup type is missing for some of our databases any help please
Your database Recovery model must be Simple.
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
the querys is also restored ???
The .MDF file and .BAK files were Corrupt and, we fixed the backup file by SQL backup recovery software. This backup recovery software is the part of Stellar SQL database Toolkit. by this incident, we learnt to maintain the backup of the database. More details about the toolkit is available here: www.stellarinfo.com/sql-database-toolkit.php
Hello Dazy, Stellar's SQL recovery software also worked for me.
Hi Miss Parker, Good to know that the software fixed your problem. I am SQL database administrator having 15 years of experience. Well, in my position, the organisation do not expect any mistake for the database and its related things. We maintained the proper backup plan and fixed the corruption so many times without any software. This time, your mentioned software saved my job. We repaired our company’s database with the help of it. So, thanks for sharing it.
How do i restore a .backup file using commands
Thank you this video!
Great video. Thank you for help. I found another informative blog regarding this:www.sqlserverlogexplorer.com/restore-full-database-backup/You can go through to this. Keep Reading.
where did u click ok to start the restore????
one of the best video thank u
t h a n k y o u !!!
Awesome work bro. . . Thank you . . .
Thanks it was helpful....
very helpful. cool
Thank you so much from Baku
in this video, we will start by saying 'in this video' like we do in every in this video :)
thank you, this helped me alot
Awesome video!!! :D Thanks!!! :D
It's very helpful for me. Thanks
I am trying to figure out how to move SCCM 2012 db files to another drive on the same server. has anyone seen any tutorials on this?
thank u buddy... so much..
thank you.it is useful for me a lot.
Thank you so much. I am trying to learn how to work with SQL servers, so this is very very helpful.
thank you very much! exactly what i was looking for :)
Thank you so much for this.
sir, I enjoy all of your videos on ms sql, these are absolutely perfect...please make more ms sql videos. Thank you and God bless you.
Can I just save this file to, say dropbox, then put it on another computer without any previous databases or access or whatever. And just add it there? I just want to save my database somewhere. How?
wow, you are a LIFE-SAVER bro.. i was struggling to restore a .bak file.. thank you for showing me how to do it.. THANK YOU SO MUCH BRO
Disgusting!!! I want to know about restoring in existing database without change database name!!!
You clearly arent getting it.
I don't get an OK or RESTORE button. Mine just says VERIFY BACKUP MEDIA or something like that. Can only do a verify media operation, but can't restore.
+Zazzle Delacruz yep, that worked for me!
+Felipe Reis I found my solution. My screen resolution was too low and the OK and RESTORE buttons were out of view off the bottom of the screen. Try increasing your screen resolution and the buttons will be visible.
Thanks for putting this together. I know the backup isn't difficult however I don't have sql server 2012 installed yet so it was nice to see you walk through the steps. Question, can you set your backup to a networked drive? I'm thinking I'll throw a DROBO on the network and place that in a separate building on the same LAN.
Hi how i do for create a new bd with a backup of other bd
Sounds like your backup file may be corrupt. Did the backup come from a 2008 R2 server and are you restoring it to 2008 R2?
hi, i tried to restore one backup put i got this error:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)ADDITIONAL INFORMATION:The media family on device 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\Sports Management (2).bak' is incorrectly formed. SQL Server cannot process this media family.RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)pls help!!
Hi try to do the backup but when I try to restore in another sql server server I get an error
great video thank you very much
For an external hard disk, it should have a drive letter assigned to it when it's connected. Just point the backup to that drive. For example, if your external drive is drive D, the command is:backup database TestDB1 to disk = 'D:\TestDB.bak'