Updating a record

SELECT TOP 1000 [Index]
,[Action]
,[AcNumber]
,[FromNumber]
,[CustomerCode]
,[PolicyCode]
,[FromCode]
,[Amount]
,[EntryDate]
,[EntryTime]
,[RegNo]
,[Status]
,[FromDate]
,[ToDate]
,[SumInsured]
,[Branch]
FROM [SQLDB].[dbo].[Customers]
where Code='Profilenumber'
order by [Index] desc

---

• Update the record:

UPDATE [SQLDB].[dbo].[Customers]
SET [OldCustomer] = '0'
,[password]=''
WHERE Code='Profilenumber'
GO

Deleting a record

SELECT TOP 100 [Index]
,[Customer]
,[CustomerCode]
,[Type]
,[TypeCode]
,[Approved]
,[DecisionDate]
,[DecisionUser]
,[User]
,[Branch]
,[Dates]
,[Resend]
,[LockedBy]
,[LockedTime]
,[SSMA_TimeStamp]
FROM [SQLDB].[dbo].[Authorization]
Where [Customer]= 'MICHAEL MARIANNA'

*Then you should note down the index value of this record so you will use to delete it as below:

---

DELETE FROM [SQLDB].[dbo].[Authorization]
WHERE[index]='225972'
GO

Database restore

  

Edit FAQ 

Put backup database on secondary server 

Solution: After performing a fresh backup of the original database,  Login to the secondary SQL Server Management Studio. Check if a user is logged in via task manager (If the service is in use but no user is logged in, restart the service)




Restarting the service






After performing the steps shown in the above screenshot 
--> Select from device 
--> From file  
--> Add 
 --> SQL Backup 
--> Select a fresh .bak file previously backed up from original server
--> Tick on Restore 
--> Options 
--> Restore options 
--> Tick overwrite 
--> Click on OK.

Adding a secondary DNS

See how to add a secondary DNS here: https://www.youtube.com/watch?v=UlVuF9jogm4

Also you need to add your ISP's DNS forwarders: