Database backup and restore - Copying a database from one system to another.

There may be situations when we need to copy a data base that contain many tables stored procedures etc.

First we have to create the back-up of the existing database in SQL SERVER.

·         Right click on the database, select TASKS, and click BACKUP...........

·         Select backup type FULL.

·         Select the destination for storing database.

Copy the backup file to the system to which it is restored..Open the SQL SERVER

·         Right click on the database, select TASKS, and click RESTORE, DATABASE...........

·         Select Restore file from DEVICE...

·         In general properties, Tick the restore check-box..

·         In options, select the .mdf and .ldf file of new database from C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\DATA.

·         Click ok.