Items such as maxdop, max server memory, enable IFI and tempdb configuration are all install time configuration items not post install

@use_databasemail is an integer input with no default, it must be specified

download the Kerberos configuration manager tool and run it, it will provide a report of what it finds

you need to setup delegation between the endpoints, the account details have to be delegated to the remote endpoint, first make sure all SPNs are correct, then setup the account...

Did you authorise sql agent to use the mail profile?

Use the following script

EXEC msdb.dbo.sp_set_sqlagent_properties @email_save_in_sent_folder=1,
@databasemail_profile=yourprofilename,
@use_databasemail=1
GO

Now, nothing against Ola Hallengren's script, but I prefer something I can support and that is more targeted to my environment. I also prefer small, specific scripts over...

Oof... I would almost bet real money it was set to default... BUT glad I didn't - it is set to 7 days. That makes me feel better.

Now I...

only time you'll want to shrink a database is refreshing into a lower level env where space is limited but even that's frowned upon.

Prod data shouldn't be pushed to lower...

Good morning,

Once again, I find myself Sr. DBA for a company.  As I review this latest environment, I see something interesting.

I see one of the main production servers is...

On one of my database servers, I have a maintenance plan that includes the following tasks:

1. Check Database Integrity 2. Back Up Database Task 3. Recognize Index (includes Fragmentation...

@grant fritchey

are you feeling bored by any chance 🙂

You can backup and restore databases to a new instance of 2022 from as early as SQL 2005, depending on the compatibility level of the database, this link details the...

For log shipping, this means the secondary server now has to restore bigger log backup files, increasing replication lag. Your DR site that was just a few seconds behind...

check the number of days history retained and the number of projects\packages on the SSIS instance properties, default is 365 days for history and can lead to SSISDB becoming bloated...

As already stated, need more detail on the latency length and how the publisher, subscriber and distributor are configured.

The replication monitor usually provides good info on the current state