SQL Backup & database Maintenance Plan

For Taking SQL backup Backup Database ( Single Database ) Start -> programes -> Microsoft SQL Server -> Enterprise Manager -> Se...

For Taking SQL backup
Backup Database ( Single Database )

Start -> programes -> Microsoft SQL Server -> Enterprise Manager ->
Server -> Database -> ( Select Database) All Task -> Backup Database -> Add -> Give Backup Path & filename -> Ok ->
----------------------------------------------------------
Restore Database ( Single Database Eg. Database Name as xxx )
Start -> programes -> Microsoft SQL Server -> Enterprise Manager -> Server -> Database ->
(Due to Security Problem it is not explained here)
Ok
----------------------------------------------------------
Database Maintenance Plan (Database Backup)
Management -> Database Maintenance Plan ->
New Maintenance Plan -> Select Databases
( All or user or Selected )
Next -> Next -> Next ->
Specify the database Backup Plan (Apply Tick )
Specify the Transaction log Backup Plan (Remove Tick)
Change the Job Time
Specify the DB Backup Disk Directory
Option : Use This Directory
( eg. E:\BACKUP for Local Backup
(eg file://CLIENT/BACKUP for Network Backup )
Next -> Next -> Next -> Next -> Plan Name
( eg. SERVER DAILY 16.00 HRS )
Finish

The Schedule has Starts in the correct time if the system is in ON condition

Database Maintenance Plan ( Transaction log File Backup )

Management -> Database Maintenance Plan ->
New Maintenance Plan -> Select Databases
( All or user or Selected )
Next -> Next -> Next ->

Specify the database Backup Plan (Remove Tick )
Specify the Transaction log Backup Plan (Apply Tick)

Change the Job Time
Specify the DB Backup Disk Directory
Option : Use This Directory
( eg. E:\BACKUP OR file://CLIENT/BACKUP)

Next -> Next -> Next -> Next -> Plan Name
( eg. SERVER DAILY 16.00 HRS )
Finish