It's all about Information, tricks and knowledge..

How to backup Database in SQL Server 2008 R2 Management Studio

No comments

1.   Right click on your database and hover on Tasks, you got another drop-down, Select Back Up.
2.   You will get a pop-up like this. 
3.   Click on OK button.
4.   Navigate to path on your local PC or another path (C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup\your database)
5.   You got your backup database.

No comments :

Post a Comment