Viewing 15 posts - 1 through 15 (of 711 total)
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!
November 26, 2019 at 9:54 am
@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...
November 26, 2019 at 9:33 am
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),...
November 26, 2019 at 8:28 am
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...
September 27, 2017 at 2:31 am
@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...
March 21, 2017 at 2:38 am
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?!...
March 19, 2017 at 7:04 am
Meaning limiting the CPU to 25% with MAX_CPU_PERCENT has no effect & was ignored somehow!
May 15, 2016 at 12:15 am
Ed Wagner (3/16/2016)
Not being an SSIS guy at all, I learned something new. Thanks.
+ 1 🙂
March 20, 2016 at 12:13 am
Good 2 know this, thanx 4 the question.
March 12, 2016 at 11:48 pm
Never had the opportunity to test this before, NULL < -1, interesting, thanx for the question.
March 12, 2016 at 11:41 pm
As I didn`t use that function before, so I googled it; found some confusing web links made me think it is useing DES algorithn as well.
February 28, 2016 at 3:51 am
Viewing 15 posts - 1 through 15 (of 711 total)