SQL

If you have forgot your ‘sa’ account password and do not have any other account with admin privileges available. Also as a best practice yo...

Today I ran consistency check on a database and it throw below error: DBCC checkdb on msdb database failed with errors:- Msg 1823, Level ...

Our backup log job failed with following error:  Executed the below query:  "BACKUP LOG [DemoData] TO  DISK = N'C:\Backup\xxx\...

Sometime backup job failed with the following error: Alert description: BackupDiskFile::CreateMedia: Backup device 'xxx.bak' fai...

You can convert seconds to HH:MM:SS in various method.  Method 1   DECLARE @Seconds INT  SET @Seconds = 7600 SELECT CONVERT(VarChar(...