Register Now

Login

Lost Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Backup and Restore SQL Server Databases

Backup and Restore SQL Server Databases

Sometimes, developers need to Backup and Restore SQL Server Databases. This video is useful for those who willing to to backup and restore database. This will teach how to restore database and how to take backup from sql server. The backup database stores in .SQL format, In the server it stores in .mdf and .ldf format.

The SQL Server backup and restore component which provides an essential safeguard for protecting your SQL Server databases. To minimize the risk of data loss, you need to back up your SQL databases. The following video tutorial explains you the backing up and restoration of your Microsoft SQL Server 2008 Database using the Microsoft SQL Server Management Studio.  The examples are from MS SQL Server 2008 however it applies to MS SQL Server 2000 and MS SQL Server 2005.

Please Open your Microsoft SQL Server Management Studio, whichever you prefer, standard or express edition.  Login to your MS SQL server by entering username and password.


How to Make Database Backup in SQL Server 2008

This video introduces the concepts of the backup for SQL Server.   To backup your database, follow these steps:

Note: .bak is the extension of MS SQL backup file.

Select the database from SQL >> Right-click >> Tasks >> Select Back Up


Restore database in SQL Server 2008

This video introduces the concepts of the restore for SQL Server. To restore your database, follow these steps:

Select the database >> Right-click >> Tasks >> Restore >> Select Database


There are some other database versions available. Here we showed demonstration of SQL Server 2008 version. The Database restore and backup steps may vary little bit.


We have made youtube channel which helps students to learn about project. Kindly check VB.NETprojects channel for VB.NET and SQL server based projects.

Comments ( 2 )

  1. It’s nice & it’s very useful……..Hope so we will get more stuff…….

  2. hello sir i am a new progamming practice and i dont really know how to be a good programer .. can you please help us …

Leave a reply

About StudentProjects.Live

A collection of source codes that I wrote in VB 6.0, ASP.NET, PHP, C#.NET, VB.NET and JAVA in a course of my career as web developer and software engineer that I would like to share to my fellow programmers. Some of the codes here is not my original work that I found over the Internet and Books while I'm learning how to program. I hope you find my work useful in your learning in programming. Please share my work to other people also who interested to learn the basics of web development and programming. Thank you very much and Happy Productive Programming Everyone.

Follow Me