C # Backup and restore operations on the database, SQL statement implementation

Source: Internet
Author: User
Tags rollback

///

Backup and restore operations on the database, SQL statement implementation

///

Implementing SQL statements for backup or recovery

Whether the operation is a backup operation, true or False

private void Bakreductsql (string cmdtext,bool isbak,string dbname)

{

String Constring=database.dbconnection.sqlnodbnameconnect ();

SqlConnection conn3 = new SqlConnection (constring);

SqlCommand Cmdbakrst = new SqlCommand ();

Try

{

if (conn3. state==connectionstate.closed)

Conn3. Open ();

Cmdbakrst.connection = CONN3;

Cmdbakrst.commandtype = CommandType.Text;

if (!isbak)//If the recovery operation

{

String setoffline = "Alter database" +dbname+ "Set Offline with rollback immediate";

String setonline = "Alter database" + dbname + "Set Online with Rollback immediate";

Cmdbakrst.commandtext = setoffline + Cmdtext + setonline;

}

Else

{

Cmdbakrst.commandtext = Cmdtext;

}

Cmdbakrst.executenonquery ();

if (!isbak)

{

MessageBox.Show ("The data is successfully restored to the state of the selected document!", "system messages");

}

Else

{

MessageBox.Show ("Congratulations, you have successfully backed up the current data!", "system Message");

}

}

catch (SqlException Sexc)

{

MessageBox.Show ("Failed, may be failed on database operation, Reason:" + sexc, "Database error message");

}

catch (Exception ex)

{

MessageBox.Show ("Sorry, operation failed, possible reason:" + ex, "system Message");

}

Finally

{

Cmdbakrst.dispose ();

Conn3. Close ();

}

}

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.