Article

Database Backup .bak


Step 1: Open the sql server management studio then click on the databases then you can see all the databases in sql server management studio . you can see i have created the new database name BakFileDemo


Step 2: Right click on the database which you want to make the .bak file. then click on the tasks then you can see the backup then click on the backup you can see the new popup window will appear
Step 3: Click on ok. then .bak file will generated in given directory

Step 4: Open the file explorer then search the location "C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Backup\"  or you can direct type