Thanks for your response Jeff.  Glad to see you are still going strong. I will have a play. Keep up the great work.

Kind Regards,

Phil.

Thank you for your replies.

I added: CAST(FileSize AS decimal(35,2)) AS FileSize,

+

WHERE Domain = @Domain AND convert(bigint, Filesize) > 50000

That worked so many thanks.

One last question...

--I added
ROUND(SUM(CAST([FileSize] AS...

Hi. Where?

Looks like you need BIGINT instead of INT.

I tried:

SUM(CAST([FileSize] AS BIGINT)/1048576.0)) + ' MB' AS [FileSizeMB]

Kind Regards,

Phil.

Hi. I guess it doesn’t make much difference but the deletes were performed in batches over a 24 hour period.

Thanks,

Phil

Hi. I will need to check. I am surprised it is 600+GB.

Phil.

Hi. I do not manage SQL I’m the tech lead on the application.

The database is in a cluster hosted in Azure. I have been advised recovery model must be set...

Hi. Yes the transaction log is that large.

Thanks,

Phil

You could well be right 🙂

Thanks,

Phil.

Hi Jeffrey. I have no concerns over the DB size however the vendor felt it might be impacting performance. Thank you for taking time to respond.

Kind Regards,

Phil.

I was only able to mark one reply as answer...

Thanks to both. I am up and running.

Phil.

Hi. Thanks to both. So I have already downloaded SSDT-Setup-ENU.exe + vs_SQL.exe. I originally installed vs_SQL.exe. I have kicked off install of SSDT-Setup-ENU.exe and have selected Database Tools and  SQL...

I just tried Joie response, results below:

C:\Windows\system32>sqlcmd -S SERVER\Instance -E
1> EXEC sp_addsrvrolemember 'DOMAIN\MyAccount', 'sysadmin';
2> go
Msg 15247, Level 16, State 1, Server SERVER\Instance , Line 1

Thanks for all your input. Rather embarrassingly (or fortunately) I decided to RDP to the server using the service account I used to install the application. Hey presto the account was a...

The error log records:
Login failed for user 'SERVER\User'. Reason: Could not find a login matching the name provided. [CLIENT: <local machine]
Error: 18456, Severity: 14, State 5.