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

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

Difference between LEN and DATALENGTH

LEN: LEN function returns the number of characters in a variable .it also removes the trailing spaces and then then return the length. Example-1: DECLARE @Name VARCHAR ( 20 )= 'rakesh' SELECT LEN ( @Name ) as [len] Output: Example-2: DECLARE @Name VARCHAR ( 20 )= 'rakesh ' SELECT LEN ( @Name ) as [len] Output: When we observe above variable assigned 'rakesh ' string after that added 3 spaces . Len function removes trailing spaces not leading spaces. DATALENGTH : DATALENG function returns the number of bytes occupy in a variable .it also considered the spaces also. Example-1: DECLARE @Name VARCHAR ( 20 )= 'rakesh' SELECT DATALENGTH ( @Name ) as [DataLength] Output: Example-2: DECLARE @Name VARCHAR ( 20 )= ' rakesh ' SELECT DATALENGTH ( @Name ) as [DataLength] Output: In above example before ' r ' and after ...
Post a Comment
Read more