totally correct - a procedure would be a quite good approach - you could check if any databases already exist with an option to replace them or generate more database...

Hi,
great - if I ever run into this error and I only have a small maintenance window for a physical machine I will give it a try. Reinstalling the...

Hi,
we are using a procedure for Log Backups and to clean the folder using xp_cmdshell when the given timeframe is reached.
1st step: get the folder content into a table

I use my own snippets since abt. three years now and I can't imagine what a waste a time it would be to work without them. Its frustrating enough to...

hi,

you also might need to replace all child permissions with the folders permissions. Permission inheritance is different on move and copy :
https://support.microsoft.com/en-us/help/310316/how-permissions-are-handled-when-you-copy-and-move-files-and-folders

BR
Gerald

hi,
what about this solution:
Query you CMS for the instance names.
Paste the result into a text-file
Make a batch file using the text-file as input for a for...

Hi,
with minimum downtime I would have done it this way (same solution testet with alwayson ag's)
1 break mirror and restore mirror partner DB with norecovery moving the files...

Hi,
I  would recommend to stop using out-of-the-box maintenance tasks anyway. Deploying and monitoring on a higher number of sql instances is no fun at all. Just write your own...

Here's a query which I use to find out which sessions are using tempdb - original auhtor unknown - I only made a reformating:

USE [tempdb];

WITH [task_space_usage] AS (

Hi,
wouldnt it be nicer to do this without the "for xml path" stuff -

SELECT @column_list =...