1. Open the Microsoft SQL
Server Management Studio
· Click on start type Here SQL Server Management
Studio........image(1)
 |
| image(1) |
· Press Window + R Type in Box SSMS..............image(2)
 |
| image(2) |
Opened Microsoft SQL Management
Studio..........................Image(3)
·
Enter the Server Name
·
Authenticate Mode which is authenticated mode you are using SQL like window authenticate or SQL server
authenticate
·
Enter Login Name: sa
·
Enter your password: 12345
Right Click on that's the database you want to take the backup
· Right Click-Task-Back Up
Click on Backup – ok
Default Path Showing for you Below
Default path - C:\Program Files\Microsoft SQL
Server\MSSQL13.MSSQLSERVER\MSSQL\Backup
Note: If you want to Backup in another Location you can get it, click on Add then select your location.
0 Comments