MS SQL Server

I have implemented windows server 2019 clustering by using the below methods,Installed windows 2019 standard evaluation edition on 3 machines.SRVRDC (will act as a domain controller), SRVR1, and SRVR2...

 we have use below TSQL script to take all database backup jobs DECLARE @name VARCHAR(50) -- database name  DECLARE @path VARCHAR(256) -- path for backup files  DECLARE @...

 we can use below script to get last database name and date by executing below scriptSELECT bus.database_name Org_DBName,       restored_to_dbname,       l...

 we can use the below script to check database backup restore percentage details and many more.use master;SELECT r.session_id,r.command,CONVERT(NUMERIC(6,2),r.percent_complete) AS ,CONVERT(V...

It is very important to take a database users and the respective privileges backup while you perform a database restore, as once the database restore complete we must replace the same access rights be...