问一个简单的SQL的句子，怎么备份SQLServer2000的一个数据库到文件

[大雨仔]

很简单哦

[canyqf]

USE master
BACKUP DATABASE { database_name | @database_name_var }
TO DISK= 'path'
WITH ...

[孟子E章]

public class BackupDB
{

public bool BackupDatabase()
{
// Create Instance of Connection and Command Object
SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["connectionString"].ToString());
string sBackup = "BACKUP DATABASE " + myConnection.Database + " TO DISK = 'c:\\sql.bak' WITH NOINIT";
SqlCommand myCommand = new SqlCommand(sBackup, myConnection);

// Open the database connection and execute the command
myConnection.Open();
myCommand.ExecuteNonQuery();
myConnection.Close();

return true;
}
}