Tag Info

New answers tagged


As you have stated, your backup strategy can be viewed as below : The reasoning for this type of plan is due to HDD size restrictions on the Azure environment I am working with. Two imporatant things that you can do Enable Instant file initialization (do follow other best practices when runing SQL Server on Azure VM) Enable backup compression and ...


In order to identify where this is coming from (because who knows which step in your maintenance plan is actually tripping on this), I recommend running the following tedious code, which will identify views that show the database name even if it is a database that no longer exists in sys.databases (dropped, renamed, what have you): DECLARE @db SYSNAME = ...

Top 50 recent answers are included