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.
Set rs = New ADODB.Recordset sql = "SELECT FirstName, LastName, City, St, Phone, Email, DOB, Gender, Country, FBook, Twitter, Uploaded " sql = sql & "FROM Participant WHERE ParticipantID = " & PartsToAdd(i) rs.Open sql, srvr_conn, 1, 2 For j = 0 To 10 PartArr(j) = rs(j).Value Next j rs(11).Value = "y" rs.Update rs.Close Set rs = Nothing 'check to see if this participant exists lParticipantID = 0 Set rs = New ADODB.Recordset sql = "SELECT ParticipantID FROM Participant WHERE FirstName = '" & PartArr(0) & "' AND LastName = '" & PartArr(1) sql = sql & "' AND Email = '" & PartArr(5) & "' AND Gender = '" & PartArr(7) & "'" rs.Open sql, conn, 1, 2 If rs.RecordCount > 0 Then lParticipantID = rs(0).Value rs.Close Set rs = Nothing
|Amazon RDS migrate to SQL Server||3||26|
|VB.net Duplicating a table - primary key not created||3||32|
|Migration from SQL server to oracle (XML input)||4||26|
|XML and version of MS XML Dom Document versions||5||13|