数据库备份命令 [英] command for database Backup

问题描述

大家好，

您能指导我使用SQL Server 2005数据库备份命令吗?

在此先感谢.

问候，
Ganesh.S

Hi All,

Can you please guide me for SQL Server 2005 DataBase Backup command.

Thanks in Advance.

Regards,
Ganesh.S

推荐答案

将数据库数据库名称备份到磁盘"C:/databasename.bak"

backup database databasename to disk "C:/databasename.bak"

请参见

您可以通过两种方式备份数据库:

1.使用Management Studio Express(可从此下载页面单独购买或作为Express Advanced的一部分购买)，该工具在任务"下的每个数据库的右键单击菜单上均具有备份"选项.

2.使用T-SQL手动编写备份脚本.您可以在此BOL主题中了解T-SQL备份命令.

如果要计划备份，则可以编写一个T-SQL脚本，然后使用Windows Task Schedule调用SQLCmd以按照每个计划运行脚本.

You can backup your database in two ways:

1.Use Management Studio Express (available separately or as part of Express advanced from this download page) which has the Backup option on the right click menu for each database under Tasks.

2.Use T-SQL to manually write your backup script. You can learn about the T-SQL backup command in this BOL topic.

If you want to schedule your backups, you would write a T-SQL script and then use Windows Task Schedule to call SQLCmd to run the script on what every schedule.

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