Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
Public Function Open() As Boolean Try If Not Me.ConnPath = String.Empty Then 'If Me.Conn.State.Closed Then 'Create connection if non-existant Conn = New SqlConnection(ConnPath) 'End If Conn.Open() 'Successful Return True Else MessageBox.Show("The connection could not be opened because the application did not set the SQL connection path before trying to open a connection to the SQL Database.", "SQL Connection Failed", MessageBoxButtons.OK, MessageBoxIcon.Error) Return False End If Catch ex As Exception MessageBox.Show("Unable to open a connection to the SQL database." & vbCrLf & "Detail:" & vbCrLf & ex.ToString, "SQL Connection Error", MessageBoxButtons.OK, MessageBoxIcon.Error) 'Failed Return False End Try End Function 'Where ConnPath = "Data Source=SQLTEST\SQLTEST;Initial Catalog=CDH;Persist Security Info=True;User ID=XXXXX;Password=XXXXX"
|Query group by data in SQL Server - cursor?||3||49|
|How to duplicate form in Visual Studio 2015||2||62|
|VB.NET Textbox input validation||4||40|
|how to hit button in form and close application from main()||4||22|