How to Backup and Restore SQLServer 2005

1          Backup Database

 

l      Open SQLServer2005 “SQL Server Management Studio”

l      Select a database and right click and select backup operation

 

 

l      Select backup destination file

Highlight: This file locates at server side. Not you local machine directory.

l      Select backup type

Highlight: Firstly select ‘Full’ and Click ‘OK’ button, then you must select ‘Transaction Log’ and Click ‘OK’ button again. (Need backup database and log at the same time)

 

l      If backup successfully, it will create a backup file on server side selected directory.

 

2          Restore Database

 

l      Open SQLServer2005 “SQL Server Management Studio”

l      Select a database and right click and select restore operation

 

 

l      Select backup source file

Highlight: This source file is created by backup operation. And you need put this file on server side firstly.

 

 

l      Click ‘Option’ Menu

Highlight:

(1) Must select ‘Overwrite current database’

(2)  If restore file don’t create by itself, you must select correct database file and log file.

 

l      Click ‘OK’ button to restore.