How to Backup SQL Express

There are several ways to backup a SQL Server database. Here are just a few:

  1. Use SQL Server Management Studio Express
  2. Use a free utility such as Sql Backup and FTP ( https://sqlbackupandftp.com/)
  3. Use a script to backup the database
sqlcmd -E -S YourServerName -Q "BACKUP DATABASE [YourDatabaseName] TO DISK='C:\Backups\YourDatabaseName.bak'"
Revised: 2010-10-07