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 Sub Drop_SQL_Relationships(ByVal sTable As String, ByVal sRelationship_Name As String) On Error GoTo EH Set con = New ADODB.Connection con.Open "Provider=SQLOLEDB;Data Source=22.214.171.124,1444;Network Library=DBMSSOCN;Initial Catalog=psql;User ID=Gxxxx;Password=mcc4;" Set cmd = New ADODB.Command Dim sSQL As String sSQL = "ALTER TABLE [" & sTable & "] DROP CONSTRAINT " & sRelationship_Name With cmd .CommandText = sSQL .CommandType = adCmdText .ActiveConnection = con .Execute End With Set cmd = Nothing Set con = Nothing Exit Sub EH: MsgBox Err.Description End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.