• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 434
  • Last Modified:

How to backup database in SQL Server 2008 Express Edition

Hi, how is database backup done in SQL Server 2008 Express Edition? Thanks in advance.
0
0nepiece
Asked:
0nepiece
  • 2
2 Solutions
 
zadeveloperCommented:
USING COMMAND: BACKUP DATABASE %DBNAME% to disk = 'c:\myfilename.bak'
optionally you can add
BACKUP DATABASE %DBNAME% to disk = 'c:\myfilename.bak' with password = '123456'
0
 
zadeveloperCommented:
check out: ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_6tsql/html/89a4658a-62f1-4289-8982-f072229720a1.htm for more options
 
0
 
0nepieceAuthor Commented:
Thanks!
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now