Online Learning

Online Learning

Why Welight?

It is imperative to make right decisions at right time. It is also essential to provide meaning to our lives, be it professional or pers...


  • Byatarayanapura, Mys Rd
  • K S Townn Mys Rd
  • Muneshwara Block
  • Opp Gopalan Legacy Mall
  • Saraswathinagar

Most Viewed

Register Now, Limited Seats Only!! or Contact Office

Login for Online Test - Welight Academy Exclusive

Backup and Restore SQL Server Databases

Back Up and Restore of SQL Server Databases
Sometimes, developers need to Backup and Restore SQL Server Databases. 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