You can perform the backup and restore using the Microsoft SQL Server Management Studio. In this activity, the full backup is executed onto disk using MSSQL Server 2008 R2.
Backup
1. Open your Microsoft SQL Server Management Studio and connect to the database instance which you want to back up. In the Object Explorer, expand the Databases tree and you will see the list of database instance.
2. Right click on the database instance, select Tasks > Back Up. The back up database dialog will appear.
General
• Source / Database: Confirm the database instance to back up.
• Source / Backup type: Full.
• Source / Backup component: Database.
• Backup Set / Backup Name: Enter the name.
• Backup Set / Description: Enter the description.
• Backup Set / Backup set will expire / After: 0.
• Destination / Back up to: Disk.
Options
• Overwrite media / Backup up to the existing media set / Append to the existing backup set.
• Compression / Set backup compression / Use the default server setting.
You can monitor the progress of backup completion on the left panel of the back up dialog. You can also terminate the back up during the execution.
Restore
1. As per backup steps, select Tasks > Restore > Database.
General
• Destination for restore / To database: Database Name
• Destination for restore / To a point in time: Most recent possible
• Source for restore / From device: Enter the location
Options
• Restore options / Overwrite the existing database (WITH REPLACE)
• Recovery state / Leave the database ready to use by rolling back uncommitted transactions. Additional transaction logs cannot be restored. (RESTORE WITH RECOVERY)
On Restore the database files as, you need to allocate the space, location of the each data. Example, the source database data is PRD and the target source database is DEV.
Original File Name Restore As
PRDDATA1 C:\DEV\DEVDATA1.mdf
PRDDATA2 C:\DEV\DEVDATA2.ndf
PRDDATA3 C:\DEV\DEVDATA3.ndf
PRDLOG1 C:\DEV\DEVLOG1.ldf
As per backup execution progress, you can anytime stop the restoration process. The restore may take a while and it depends on size and hardware efficiency.
