Sorry, but the answer is wrong! I ran the code in SQL 2022 got below error:

Msg 102, Level 15, State 1, Line 15

Incorrect syntax near 'WINDOW'.

I think the correct answer should be DMA, from BOL:

The Data Migration Assistant (DMA) helps you upgrade to a modern data platform by detecting compatibility issues.

https://www.brentozar.com/archive/2020/10/what-is-the-sql-server-ceip-service/#:~:text=Can%20you%20disable,or%20Enterprise%20Edition

Change the database context to msdb, the query will work fine, tested myself.

db_backupoperator

Members of the db_backupoperator fixed database role can back up the database.

I guess that would be enough privilege to perform the backup but CANNOT DO RESTORES!

@john-2 Mitchell, Thanks for the reply! The accidental restore was done by a 3rd party powerful tool not SSMS, even worse the REPLACE & drop current connections options...

I have the same problem (almost), but it`s not about permission, I need to stop everyone from doing a restore operation in production server (business requirement after an accidental restore),...

Hi,

Hi,
Please note that when xp_cmdshell is called by a user that is not a member of the sysadmin fixed server role, it connects to Windows by using the account name and password...

@perry Whittle

I need to configure 2 different Mirroring instances for a single database?! in other words can I Mirror database 1 to instance B and then...

Ok, I know it`s a 7 years old post, but I am stuck with some issue related to that post:

"Can I configure 2 different instances for a single database?!...

Meaning limiting the CPU to 25% with MAX_CPU_PERCENT has no effect & was ignored somehow!

Nice question, thanx.

+ 1 🙂