Tonight, I'll be in a theatre orchestra pit for the 5th time this week.  No need for prayers - I need coffee. ...

Yup, as long as you pass @with_copy = 1 as one of the parameters, it should do just that.

As always, though - test it before you break anything!

Good luck.

Going by the documentation, when you restore a stretch database, you have to reauthenticate / reauthorise the access to the stretched data.  One of the parameters to the command that...

A couple of thoughts...

1. A job can have multiple schedules.  At one place, I had a similar problem, so I put a secondary schedule on the TLog backup schedule job...

Happy New Year

May your late-night emergency call-out bleepers be kind to you this year.

I'm back in the office after the festivities.  Nothing seems to have changed, except I think the...

Are there lots of foreign keys?  Triggers?  indexed / materialized views?

The latest documentation about this setting is at https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-min-memory-per-query-server-configuration-option?view=sql-server-ver15

Includes the warning "could lead to increased competition for memory resources"

Is your system very busy?  I assume it is, otherwise you wouldn't...

Yes, you can do it using something like VirtualBox on your PC - but you'll need to have plenty of RAM and spare disk space.  There are various tutorials...

From the documentation:

SQL Server might allocate more memory than the value specified in the max server memory setting. This behavior may occur when the Total Server Memory (KB) value has already reached...

What was your answer?  Do you know why it was wrong?

What's the job?  (I assume it's a job interview you failed...)

The problem with using the social security number as a "natural" unique ID is that, erm, it isn't.

See this: https://www.idanalytics.com/press-release/20-million-americans-multiple-social-security-numbers-associated-name/

This could be also a side-effect of what's called "Lazy Logging" in Availability Groups - there are lots of articles thrown up by a search - https://www.google.com/search?q=availability+group+lazy+logging

I would suggest reading...

I would do, except I'm playing in a show all that week.  Bad timing...

You could look at using "SET NOEXEC ON" if you detect that you're in the wrong DB.  That'll stop any further code from being executed in the batch (unless one...

Msg 5901, Level 16, State 1, Line 1

One or more recovery units belonging to database 'master' failed to generate a checkpoint. This is typically caused by lack of system...