SQL Server Database Stuck in Restoring Stat
In this tip we look at different reasons why a SQL Server database will be in a restoring state and things that can be done to access the database.
2021-11-15
In this tip we look at different reasons why a SQL Server database will be in a restoring state and things that can be done to access the database.
2021-11-15
In this article we look at solving SQL Server database restore issue when backup file does not show up in SSMS restore GUI as well as other permissions issues with backup and restore.
2021-08-23
Once upon a time, you had one job, well actually two jobs. The first SQL Server agent job was important, the other was a test. You have decided you do not need the test agent job. Quick right-click on a job name, remove, confirm, done. When you refreshed the list, the test job was still […]
2021-02-02
395 reads
Once upon a time, you had one job, well actually two jobs. The first SQL Server agent job was important, the other was a test. You have decided you do not need the test agent job. Quick right-click on a job name, remove, confirm, done. When you refreshed the list, the test job was still […]
2021-02-02
5,021 reads
In the technologically driven world of 2024, more individuals are finding themselves drawn towards the...
By Steve Jones
I’m heading to Boston next week for SQL Saturday Boston 2023. I went to...
By Steve Jones
We’ve been doing some events as part of the Redgate Roadshow, and at one...
Hello, I have come across this peculiar problem. This stp is called every begin...
I'm trying to script out an availability group in SQL and found this neat...
Hi all We've got some tables where the field order is .... odd....