how to backup database from sqlexpress

Question

Hi all

Please help me to backup my database from sqlexpress.

Answer 1

Do you mean as a DBA ? You need SQL Express Advanced Edition which includes a version of 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).

Answer 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.

You can automate backups for SQL Express using a combination of this tool,

ExpressMaint

and by using either user fired SQL Commands, or the sqlcmd command line interface, you can schedule the tasks however you want.

Another tool that I have used before, for doing remote backups

Sql Backup and FTP

It's nice because it provides a simple to use GUI for doing local and/or remote backups and scheduling them.

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

Answer 3

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).

Answer 4

backup database MyDatabase to disk='C:\PathToBackup\BackupFileName.bak'