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.
please comment on this post
ReplyDelete