Got a message from the Operation team as below Hi Harsha, I'm seeing a larger than normal rate of change for a week day on the backups for the SQL2000 servers. Did anything run differently yesterday compared to Monday? I have 22 sql servers and all the Weekend and Monthly backups goes to the location […]
2021-12-03
465 reads
2018-07-09 (first published: 2018-07-04)
463 reads
With high transactions table the sys.syscommittab table does not gets deleted properly. Millions of backdated row remains. To delete the sys.syscommittab table below is the script.
2017-11-13 (first published: 2017-10-27)
758 reads
2016-10-04 (first published: 2016-09-19)
431 reads
The script will restore the all the transaction logs files generated by Red Gate after extracting into .trn files.
2016-02-16 (first published: 2016-02-02)
475 reads
Today I have uploaded SQL Server Quickie #46 to YouTube. This time I’m talking...
By Brian Kelley
If you haven’t already signed up, on November 29, 2023, at 11 AM Eastern...
Picture this, you’re happily backing up your database to a Azure blob storage until...
I'm having an issue trying to drop a service. When I issue the drop...
This is strange, any SQL job that sends out Emails via 'msdb.dbo.sp_send_dbmail ' are...
hi so i have a really old application that is used to process data...
Ask SSC