备份数据库:
backup database MyDatabase to disk='D:\MyDatabase.bak' --备份MyDatabase到D:\MyDatabase.bak这个文件里面去
还原数据库:
use master restore database MyDatabase from disk='D:\MyDatabase.bak' with replace --还原MyDatabase数据从D:\MyDatabase.bak文件还原
备份日志
backup log MyDatabase to disk = 'D:\MyDatabase_log.bak' --备份日志
判断数据库是否备份成功:
try
{
数据库连接
数据库语句
数据库命令
弹出信息
}
catch (Exception ee)
{
MessageBox.Show(ee.ToString());
}