如何在Sql Express中进行数据库备份

最简单的方法:

1)打开SQL Server Management Studio.
2)展开数据库"分支.
3)右键单击要备份的数据库.
4)从上下文菜单中选择任务".
5)选择备份..."，然后按照说明进行操作.

要在代码中完成此操作，这里有一些解决方案: ^ ]

Easiest way:

1) Open SQL Server Management studio.
2) Expand the "Databases" branch.
3) Right click the database you want to backup.
4) Select "Tasks" from the context menu.
5) Select "Backup..." and follow the instructions.

To do it in code, there are a couple of solutions here: http://*.com/questions/728658/creating-sql-server-backup-file-bak-with-c-sharp-to-any-location[^]

看看以下已解决的讨论: ^ ]

此查询查询备份，然后转换为SP以计划备份:计划SQL Server 2005 Express的备份 [

Have a look at this resolved discussion: How do you backup a database using sql server 2005 express?[^]

This one, query to backup and then convert into SP for scheduling backup: Scheduling Backups for SQL Server 2005 Express[^]

如果您要安排备份，那么CP中还有一篇很好的文章:SQL代理:作业调度程序框架 [ BACKUP(事务) -SQL) [ ^ ]

If you want to schedule a backup, then there''s also an excellent article in CP: SQL Agent: A Job Scheduler Framework[^]

If you want to take a backup using T-SQL, see: BACKUP (Transact-SQL)[^]