Skip to main content

Export LocalDB Database to a .BAK File

This article contains steps how to Export Your LocalDB Database to a .BAK File.

ASP.NET / .NET freehosting
If you don't already have our ASP.NET / .NET freehosting, sign up for FREE at https://MonsterASP.net/.

How to Export Your LocalDB Database to a .BAK File

Steps to Create a .BAK Backup of a LocalDB Database:

  1. Connect to LocalDB using SQL Server Management Studio (SSMS):
  • Launch SQL Server Management Studio (SSMS).
  • Connect to LocalDB using the instance name (e.g., localdb\mssqllocaldb).
  1. Check the destination folder for the backup:
  • LocalDB runs under the context of the current user, so the default backup folder might not be directly accessible. It is recommended to choose a folder where you have write permissions.

  1. Create the backup using T-SQL: Run the following command in SSMS:

     BACKUP DATABASE [YourDatabaseName]
 TO DISK = 'C:\Path\To\Folder\BackupName.bak'
 WITH FORMAT,
 INIT,
 NAME = 'LocalDB Database Backup';
  • [YourDatabaseName]: Enter the name of the database you want to back up.
  • C:\Path\To\Folder\BackupName.bak: Enter the path where you want to store the .BAK file. Make sure the folder exists and you have write access to it.
  1. Check the backup result: After successfully running the command, verify that the .BAK file was created at the specified location.
Back to top