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.
ALTER PROC [dbo].[InsertPhone] ( @EmployeeNo int , @PhoneNumber char(24) ) as begin declare @CONTEXT_INFO varchar(100) select @CONTEXT_INFO = COALESCE(CONVERT(VARCHAR(128), CONTEXT_INFO()), CURRENT_USER) UPDATE o SET o.employeeno = c.employeeno , o.PhoneNumber =c.PhoneNumber ,o.DateUpdated=getdate() , o.CreatedBy=@CONTEXT_INFO , O.UpdatedBy=@CONTEXT_INFOT FROM Phone o JOIN ADUser c ON c.EmployeeNo = o.EmployeeNo WHERE c.EmployeeNo = @EmployeeNo IF @@ROWCOUNT = 0 BEGIN INSERT INTO [Phone] ( employeeno , PhoneNumber , CreatedBy , UpdatedBy ) SELECT Ad.employeeno , Ad.PhoneNo , @CONTEXT_INFO , @CONTEXT_INFO FROM ADUser AD WHERE Ad.employeeno=@EmployeeNo END
|Using a hta file with MSSQL agent to schedule a script job||4||39|
|AD permissions required to allow computer objects and service accounts to register SPNs||1||28|
|Start Stop time - SQL looking to create a table with just the time a vehicle started moving and stopped||7||18|