Skip to main content

Backup Database in Sql Server

Backup data base :
Backup is data base the one of the most use full task for the data base administrator’s
Simple script for back up the database to disk drives:

I have Adventureworks2008 data base in my sql server 2008













Syntax for backup data base:

BACKUP DATABASE << Databasename >> TO DISK =<<Filename>>

Script for backup data base:

BACKUP DATABASE AdventureWorks2008 TO DISK='C:/AdventureWorks2008.BAK’

When we run above query database is back up in C drive with the AdventureWorks2008.BAK file name .

When we observe the C drive

Backup the data base with object explorer:

Step 1:

ü           Rigth click on database. go for tasks and click on Back up































Step 2:




When we observe above screen shot is

Database :Adventureworks2008 this the name of the database which you bakup.

Bakup type: backup type is the type of backup you backup (above screen shot is the Full Is the type of backup).

Name: Name of the backup of databse.

Destiation: where the database backup is stored into disk drives

















Step 3: Click on “Ok” Button 

After Click on Ok button Databse is backed up into C drive with 100% Success ExecUting.

Comments

Post a Comment

Popular posts from this blog

How to Use Merge Statement Using XML Data

We now that merge statement in SQL SERVER. With Merge statement we can merge the data from Source table into Target table. In the Last article we have already seen about Merge Statement .   These articles we will work around merge statement over xml data type. We know that xml data type SQL SERVER. XML Data type is used to storing xml data used Bulk Insert Data into SQL Tables. Example: --Create Student Table if object_id ( 'Student' ) is null create table Student ( id int identity ( 1 , 1 ) , Name varchar ( 20 ), Marks int ) Declare Xml Data Type and Assign Some Xml Data. Declare @Data xml set @Data = '<Root> <Student> <Name>Rakesh</Name> <Marks>80</Marks> </Student> <Student> <Name>Mahesh</Name> <Marks>90</Marks> </Student> <Student> <Name>Gowtham</Name...
Post a Comment
Read more

SP_MSForeachtable

Some times we need to query on the all the tables in one data base single statement. We use SP_MSForeachtable this is known as undocumented stored procedures . These all are system stored procedures. These stored procedures is place in Master database. NOTE: Please do not run all these queries in Production environment Example: create database UnDocumentedStoredProcedure use UnDocumentedStoredProcedure create table Emp ( ID int identity ( 1 , 1 ), Name varchar ( 50 ), Salary int ) insert into Emp ( Name , Salary ) values ( 'rakesh' , 8000 ),( 'raju' , 9000 ) create table Dept ( ID int identity ( 1 , 1 ), DeptName varchar ( 100 ) ) insert into Dept ( DeptName ) values ( 'CSE' ),( 'IT' ) We are created new database and also created some table with some dummy data. Select all tables data: exec sp_MSForeachtable 'select * from ?...
1 comment
Read more