Please help me to backup my database from sqlexpress.
请帮我从sqlexpress备份我的数据库。
4 个解决方案
#1
2
There are a few options that you can use:
你可以使用以下几个选项:
Using Sql Management Studio you can simply back up the database through the GUI there.
使用Sql Management Studio，您可以简单地通过那里的GUI备份数据库。
You can automate backups for SQL Express using a combination of this tool,
您可以使用这个工具的组合来自动执行SQL Express的备份，
ExpressMaint
and by using either user fired SQL Commands, or the sqlcmd command line interface, you can schedule the tasks however you want.
通过使用用户触发的SQL命令或sqlcmd命令行界面，您可以按自己的意愿安排任务。
Another tool that I have used before, for doing remote backups
我以前用过的另一个工具，用来做远程备份
Sql备份和FTP
It's nice because it provides a simple to use GUI for doing local and/or remote backups and scheduling them.
这很好，因为它提供了使用GUI进行本地和/或远程备份和调度的简单方法。
Redgate also provides some options for SQL backup, but I haven't used them before but I'm sure if they are like the rest of their tools they are great.
Redgate还为SQL备份提供了一些选项，但我以前从未使用过它们，但我确信，如果它们与其他工具类似，那么它们是非常棒的。
Redgate
#2
1
Do you mean as a DBA ? You need SQL Express Advanced Edition which includes a version of Management Studio.
你是说作为一名DBA吗?您需要SQL Express高级版本，其中包含一个Management Studio版本。
Do you mean as a developer (which would explain the tags) ? Create a SqlConnection and a SqlCommand with the "Backup database" as the command text (see Books online for the exact syntax) and use SqlCommand.ExecuteNoResult (or NoValue, can't remember).
您的意思是作为一个开发人员(这将解释标签)吗?创建一个SqlConnection和一个SqlCommand，并使用“Backup database”作为命令文本(具体语法请参阅Books online)，并使用SqlCommand。执行力(或无价值，记不住)。
#3
1
backup database MyDatabase to disk='C:\PathToBackup\BackupFileName.bak'
#4
0
You can also use the sqlcmd console app. Check out this link (on the samples sections you will find how to perform a backup using this tool).
您还可以使用sqlcmd控制台应用程序。
#1
2
There are a few options that you can use:
你可以使用以下几个选项:
Using Sql Management Studio you can simply back up the database through the GUI there.
使用Sql Management Studio，您可以简单地通过那里的GUI备份数据库。
You can automate backups for SQL Express using a combination of this tool,
您可以使用这个工具的组合来自动执行SQL Express的备份，
ExpressMaint
and by using either user fired SQL Commands, or the sqlcmd command line interface, you can schedule the tasks however you want.
通过使用用户触发的SQL命令或sqlcmd命令行界面，您可以按自己的意愿安排任务。
Another tool that I have used before, for doing remote backups
我以前用过的另一个工具，用来做远程备份
Sql备份和FTP
It's nice because it provides a simple to use GUI for doing local and/or remote backups and scheduling them.
这很好，因为它提供了使用GUI进行本地和/或远程备份和调度的简单方法。
Redgate also provides some options for SQL backup, but I haven't used them before but I'm sure if they are like the rest of their tools they are great.
Redgate还为SQL备份提供了一些选项，但我以前从未使用过它们，但我确信，如果它们与其他工具类似，那么它们是非常棒的。
Redgate
#2
1
Do you mean as a DBA ? You need SQL Express Advanced Edition which includes a version of Management Studio.
你是说作为一名DBA吗?您需要SQL Express高级版本，其中包含一个Management Studio版本。
Do you mean as a developer (which would explain the tags) ? Create a SqlConnection and a SqlCommand with the "Backup database" as the command text (see Books online for the exact syntax) and use SqlCommand.ExecuteNoResult (or NoValue, can't remember).
您的意思是作为一个开发人员(这将解释标签)吗?创建一个SqlConnection和一个SqlCommand，并使用“Backup database”作为命令文本(具体语法请参阅Books online)，并使用SqlCommand。执行力(或无价值，记不住)。
#3
1
backup database MyDatabase to disk='C:\PathToBackup\BackupFileName.bak'
#4
0
You can also use the sqlcmd console app. Check out this link (on the samples sections you will find how to perform a backup using this tool).
您还可以使用sqlcmd控制台应用程序。