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

Rank Functions in SQL SERVER

1 . ROW_NUMBER () OVER ( [PARTITION BY CLAUSE] < ORDER BY CLUASE >): Returns the sequantial number of a row within the a partition of result set at 1 for the first row of the each partition. 2. RANK () OVER ( [PARTITION BY CLAUSE] < ORDER BY CLUASE >): Returns rank for rows within the partition of result set. 3. DENSE_RANK () OVER ( [PARTITION BY CLAUSE] < ORDER BY CLUASE >): Returns rank for rows within the partition of result set.With out any gaps in the ranking. 4. NTILE ( INTEGER_EXPRESSION ) OVER ( [PARTITION BY CLAUSE] < ORDER BY CLUASE >): Distributes the rows in an ordered partition into a specified number of groups. Examples: --create Employee table create table Employee (                 EmpId int identity ( 1 , 1 ) primary key ,              ...
1 comment
Read more