Start from the inside and work your way out:

DECLARE

@minutes int = 17562

,@minportion int

,@hours int

,@hourportion int

,@days int

,@ddhhmm char(8)

SET @minportion = @minutes%60

SET @hours = (@minutes - @minportion)/60

SET @hourportion = @hours%24

SET @days =...

You need to do regular (more than daily log backups) not just to control the size of your log, but also to enable point-in-time recovery should it be needed. ...

You need to find some way of enumerating the files in the folder and then processing them one by one. That may be by running a dir command via...

Not sure what you don't understand. Say you have 17562 minutes. Then the minute portion of that period is 17562 % 60, or 42. Now subtract that...

It's not clear exactly what you're struggling with. Have you tried adding a new job step with CmdExec subsytem, with a command something like this:

C:\exes\EncryptBackup.exe C:\DBBackup\FolderA Encypt filenameA.bak

C:\exes\EncryptBackup.exe C:\DBBackup\FolderB...

You might consider having your presentation layer doing the formatting. If that's not practical, use the modulo (%) operator, which gives the remainder when one number is divided by...

Please will you configure the job step that runs the package to output to a file, and then post the contents of the file. Don't forget to obfuscate any...

I don't know whether it's possible through the GUI, but you can generate your own scripts from sys.database_permissions. It's a little bit of work for you to do, but...

I see. I didn't realise that was referred to as "indirect configuration". But anyway, "not working" is not a good way to describe any problem. What happens...

What are the exact statements you're running, and what error message are you getting? Feel free to obfuscate security details before posting.

John

Stop applications and anything else that may connect to SQL Server

Stop the SQL Server service

Edit the startup parameters for the SQL Server service to add -m

Start the SQL Server service

From...

That's because you didn't put a space before the "-m". But in any case, you don't need that option for sqlcmd, just for sqlservr. You should only need...

Are you saying you want to give access to every user in the domain? I'm not sure it's a great idea from a security point of view, but if...

Oh, I see what you're saying - you haven't even been able to log in to make the changes. Make sure that no other services are connecting to the...

If you edited the startup parameters in SQL Server Configuration Manager to add the -m, you need to edit again to remove it before you restart.

John