SQL Server 2012 - How To Backup and Restore

  • Published on Jul 17, 2012
  • This video walks you through how to backup and restore a database in SQL Server 2012.

Comments • 52

  • Jahanzaib Shahid
    Jahanzaib Shahid 6 months ago

    it can't restore stored procedures

  • Suldaan Said
    Suldaan Said 6 months ago

    Thanks 👏🏻👏🏻👏🏻👏🏻

  • snorewak
    snorewak 6 months ago +1

    thankyou, very useful, very clear

  • meegie mashru
    meegie mashru 6 months ago

    Wow it's very easy

  • Csoregi Eda
    Csoregi Eda 9 months ago

    Very helpful

  • Hanadi Joueidi
    Hanadi Joueidi 9 months ago

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

    • Shreya Gupta
      Shreya Gupta 5 months ago

      Your database Recovery model must be Simple.

  • Fernando Máximo Torres
    Fernando Máximo Torres 11 months ago

    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

  • Niv Ben Avat
    Niv Ben Avat 11 months ago

    the querys is also restored ???

  • Dazy Parker
    Dazy Parker Year ago

    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

    • Sean Smith
      Sean Smith 9 months ago

      Hello Dazy, Stellar's SQL recovery software also worked for me.

    • Aron Chappel
      Aron Chappel 9 months ago

      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.

  • nikku ammannaidu
    nikku ammannaidu Year ago

    How do i restore a .backup file using commands

  • nadivideo
    nadivideo Year ago

    Thank you this video!

  • John Walker
    John Walker Year ago

    Great video. Thank you for help. I found another informative blog regarding this:
    You can go through to this. Keep Reading.

  • Ashley
    Ashley Year ago

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

  • Jagadish B
    Jagadish B Year ago

    one of the best video
    thank u

  • Thushan Chathuranga
    Thushan Chathuranga 2 years ago


  • tubeneminem
    tubeneminem 2 years ago

    t h a n k y o u !!!

  • Richard Banda
    Richard Banda 2 years ago

    Awesome work bro. . . Thank you . . .

  • Fawad Ali
    Fawad Ali 2 years ago

    Thanks it was helpful....

  • Ahaiziah Shako
    Ahaiziah Shako 2 years ago

    very helpful. cool

  • Samir aka Mudrec Salimkhanov

    Thank you so much from Baku

  • The Other Side
    The Other Side 3 years ago

    in this video, we will start by saying 'in this video' like we do in every in this video :)

  • Abbas Khan
    Abbas Khan 3 years ago

    thank you, this helped me alot

  • Sita Sowjanya
    Sita Sowjanya 3 years ago

    Very helpful.Thanks....

  • javielitostanley
    javielitostanley 3 years ago

    Awesome video!!! :D Thanks!!! :D

  • ranjit sawant
    ranjit sawant 3 years ago

    It's very helpful for me. Thanks

  • Murat Atasoy
    Murat Atasoy 3 years ago


  • Geo Johnson
    Geo Johnson 3 years ago

    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?

  • Vivian Dsouza
    Vivian Dsouza 3 years ago

    thank u buddy... so much..

  • sandy hrk
    sandy hrk 3 years ago

    thank you.it is useful for me a lot.

  • Roxanne Reyes
    Roxanne Reyes 4 years ago

    Thank you so much. I am trying to learn how to work with SQL servers, so this is very very helpful.

  • Asad Zafar
    Asad Zafar 4 years ago

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

  • misterpastorius
    misterpastorius 4 years ago

    Thank you so much for this.

  • Adnan Chy
    Adnan Chy 4 years ago

    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.

  • Omega Point Singularity

    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?

  • pvnTruthSeeker
    pvnTruthSeeker 4 years ago

    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

  • Sydur Rahman
    Sydur Rahman 4 years ago

    Disgusting!!! I want to know about restoring in existing database without change database name!!!

  • Zazzle Delacruz
    Zazzle Delacruz 5 years ago +2

    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.

    • Duyên Nguyễn
      Duyên Nguyễn Year ago +1

      thank you

    • Felipe Reis
      Felipe Reis 5 years ago +1

      @Zazzle Delacruz yep, that worked for me!

    • Zazzle Delacruz
      Zazzle Delacruz 5 years ago +2

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

    • Felipe Reis
      Felipe Reis 5 years ago +1

      same here....

  • Bobby Wilson
    Bobby Wilson 5 years ago

    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.

  • 020Ranz
    020Ranz 5 years ago

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

  • askadba
    askadba  6 years ago

    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?

  • SuperKoda92
    SuperKoda92 6 years ago

    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)
    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!!

  • Yasser Silveira Vaz D'Almeida

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

  • Tolga Oncel
    Tolga Oncel 6 years ago

    great video thank you very much

  • askadba
    askadba  6 years ago

    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'