How To Backup SQL Server 2005 Express Database?
Top : General Technical Support : Microsoft SQL Server
| Article ID: |
 |
000099 |
| Rating: |
|
2.6 / 5.0 (5 votes)
|
| Views: |
|
2768 |
|
|
How To Backup SQL Server 2005 Express Database?
|
There are two ways to backup your SQL Server 2005 Express database.
1) Download SQL Server Management Studio Express from http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en and connect to the desired instance. Navigate to the database you are want to backup and right click on the database name and select tasks > backup.
2) Open an DOS window in your Windows and run the following script.
BACKUP DATABASE yourdatabase TO DISK = 'c:\yourdatabase.bak' WITH INIT
|
