MS SQL 2008 Manually Backup & Restore

1. Open Microsoft SQL Server Management Studio
2. Select database_name, right click, select Tasks --> Backup





3.Select backup type and Destination







4. Restore Flow