Nearly...

You need to enable XP_cmdshell beforehand

I've also done a bit of tidying up

---- enable these jobs

---- show advanced options

sp_configure 'show advanced options', 1;

GO

RECONFIGURE;

GO

---- enable xp_cmdshell

sp_configure 'xp_cmdshell', 1;

GO

RECONFIGURE;

GO

----...

I have a database where the initial size was larger than required at 1500Mb

I tried this code:

USE master;

GO

ALTER DATABASE [dbname]

MODIFY FILE

(NAME = [logicalfilename],

...

I entirely agree with Andy's original idea - build your network before you need it. It helps enormously when you need to change. Out of the blue in...

When I started my current job, I had a single monitor. Company policy is for everyone to have a single monitor. But there was a spare monitor sitting...