如何在Sql Express中进行数据库备份 [英] How to take backup of a database in Sql Express

问题描述

当sql将采取

推荐答案

最简单的方法:

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://stackoverflow.com/questions/728658/creating-sql-server-backup-file-bak-with-c-sharp-to-any-location[^]

看看以下已解决的讨论:计划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)[^]

这篇关于如何在Sql Express中进行数据库备份的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！