X

Backing Up a Microsoft SQL Server 2008 Express Edition Database

Explains how to back up an SQL 2008 Express database.

You have two options for backing up a Microsoft SQL Server 2008 Express Edition database. You can download Microsoft SQL Server 2008 Management Studio Express from the Microsoft web site if you prefer to back up your database using a graphical interface. Alternately, you can use the sqlcmd utility included with Microsoft SQL Server 2008 Express Edition:

  1. Open a command prompt and navigate to the sqlcmd subdirectory in the Microsoft SQL Server 2008 Express Edition installation directory. By default, sqlcmd is located in the \Program Files\Microsoft SQL Server\90\Tools\Binn directory.
  2. Enter squelch.
  3. Enter BACKUP DATABASE database name where database name is the name of the SQL Server 2008 database.
  4. Enter TO DISK = 'pathname\database name.bak' where database name is the name of the SQL Server 2008 database and pathname is the fully qualified path to the directory where you will create the database backup.
  5. Enter WITH FORMAT;
  6. Enter GO

Was this topic helpful? Send feedback.