SQL Server 2012 - How To Backup and Restore

This video walks you through how to backup and restore a database in SQL Server 2012.

[pvnpsychosinner]

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

[ofc]

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.

[asadzafar]

thank you very much! exactly what i was looking for :)

[askadba]

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'

[askadba]

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?

[MyChannel-hiwk]

Nice and clear video explanation - thank you

[Ranz]

Hi how i do for create a new bd with a backup of other bd

[bobwilson]

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.

[nikkuammannaidu]

How do i restore a .backup file using commands

[ashleyn]

where did u click ok to start the restore????

[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

[yasilvalmeida]

Hi try to do the backup but when I try to restore in another sql server server I get an error

[omegapointsingularity]

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?

[geojohnson]

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?

[jeannotm.ngweji]

Simple and Straight to the point. Cool Stuff. #iLikeIt

[SuperKoda]

hi, i tried to restore one backup put i got this error:

An exception occurred while executing a Transact-SQL statement or batch.
ADDITIONAL INFORMATION:
The media family on device 'C:\Program Files (x86)\Microsoft SQL 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!!

[zazzledelacruz]

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.

[hanadijoueidi]

the option transaction log in backup type is missing for some of our databases
 any help please

[rajpalkaur]

Hlo sir i have problem in sql assignment i wanna make the assignment can you do it for me i can pay for that

[jahanzaibshahid]

it can't restore stored procedures