Skip to main content

Backup and Restore SQL Server Databases

By Prof Emperor
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
More video tutorials available in this link:
Labels:

Comments

Post a Comment

Popular posts from this blog

Cashew Industry Management System

By Prof Emperor
This Cashew Industry Management System is developed for managing the industry’s daily production details, stock maintenance, salary details and employee details, managed by office workers and administrator. This software system allows administrator to control the entire system including database maintenance for adding a new employee, employee wage payment, supplier details. As well as this software keeps track of work done by each employee in each section & inventory maintenance. LANGUAGES TO BE USED: Front end:    VB.NET Back end:     SQL server SOFTWARE REQUIREMENTS: Windows XP or above. Visual Studio 2010. SQL server 2008. STRUCTURE OF THE PROGRAM: The project contains the following modules: Admin module : This module includes the login module and sub modules. Supplier modules:  To manage suppliers, such as add new supplier or remove an existing one. Employee module:  To manage employees, such as...
Post a Comment
Read more

Analog Clock using VB.NET

By Prof Emperor
Here we created Analog Clock using VB.NET coding. This is the mini student project and you can learn some coding techniques in this project. this analog clock works in Visual studio 2008 version or Visual Studio 2012 version. No database required to created this analog clock. This mini project created in single form , 12 labels , 3 shapes, and 2 timers used to develop this project code. Analog Clock using VB.NET Programming Language:  VB.NET (This mini student project is for diploma, BCA and ITI students. This download link has source code of this project and it has exe file of this project. Kindly install winrar to extract this project code.) Share this:
Post a Comment
Read more

PHP Guestbook Script

By
PHP Guestbook Script is developed using PHP and MySQL database.  Guestbook script allows you to put a  guestbook  option on your website which is helpful to visitors of the website. Using this script website visitor can send comments and feedback on your site. All the records of the guest book stores in MySQL database. The admin is the master user and he has the right to edit and delete the records. Features of PHP Guestbook Script: This script allows you to put a guestbook script on your website. This file is is free software and you can redistribute or modify according to your requirements. It is fully Customizable look, Easy Navigation and usefull for blog site. This is the professional PHP and MySQL based object oriented programming(OOP) fully customizable guestbook. Using this visitors can leave message on your website. The script allows the visitors to enter name, E mail, Title and comment. Admin page to view all recor...
Post a Comment
Read more