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

Coalesce function

Coalesce function returns the first non-null value among the arguments. Syntax: Coalesce (expression [,..n]) Here is example using Coalesce function Example 1 DECLARE @Str1 varchar ( 10 ), @str2 varchar ( 20 ), @Str3 varchar ( 20 ) SET @Str2 = 'Sql' , @Str3 = 'Server' SELECT COALESCE ( @Str1 , @str2 , @Str3 ) As [Coalesce] In above example @Str2 value is ‘Sql’ , @str3 value is ‘Server’  and @str1 values is Null because it not assigned any value . Output: It return’s “Sql” because Coalesce function return’s first non null value. Example 2: Coalesce in select statement. IF OBJECT_ID ( 'Employee' , 'U' ) IS NOT NULL DROP TABLE Employee CREATE TABLE Employee (   ID INT IDENTITY ( 1 , 1 ) PRIMARY KEY ,   NAME VARCHAR ( 20 ),   SALARY INT ) INSERT INTO Employee   ( NAME , SALARY ) VALUES ( 'Rakesh' , 5000 ),(NULL, 6000 ),( 'Naresh...
1 comment
Read more