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.
