tsamuel0905
2 Iron

MS SQL DB Backup

Jump to solution

Hi All,

I have MS SQL on my windows host. This is new configuration.

FYI, Windows Host name is different from MS SQL DB Instance name.

Eg: Windows Host Name : wintest

       DB Instance Name : wintestsql

While running the backup, I am getting below error message.

Error "Cannot run savefs: The requested operation requires elevation. (Win32 error 0x2e4)"

Kindly advice or suggest on earliest.

Thanks,

Samuel Thomas

Tags (3)
1 Solution

Accepted Solutions
sddc_guy
2 Iron

Re: MS SQL DB Backup

Jump to solution

UAC settigs always needs a reboot.

Are you running 2012/2012R2 or 2008 ?

If running 2012 or latere there are some more settiings

The Admin Approval mode (ConsentPromptBehaviorAdmin )must be disabled as well

0 Kudos
11 Replies
sddc_guy
2 Iron

Re: MS SQL DB Backup

Jump to solution

You Need to turn of UAC when you get this message.

Also, add the User to Backup Operators

tsamuel0905
2 Iron

Re: MS SQL DB Backup

Jump to solution

Thanks for your prompt response.

I Turned off UAC as you advised. I did "gpupdate \force". No luck

Do I need to Reboot after this changes?

User already part of Backup Operators.

Thanks,

Samuel Thomas

0 Kudos
ble1
5 Iridium

Re: MS SQL DB Backup

Jump to solution

I think you need.

sddc_guy
2 Iron

Re: MS SQL DB Backup

Jump to solution

UAC settigs always needs a reboot.

Are you running 2012/2012R2 or 2008 ?

If running 2012 or latere there are some more settiings

The Admin Approval mode (ConsentPromptBehaviorAdmin )must be disabled as well

0 Kudos
Highlighted
Deb_PS
2 Iron

Re: MS SQL DB Backup

Jump to solution

Hello Samuel

Error: Cannot run savefs: The requested operation requires elevation. (Win32 error 0x2e4)

Environment : Windows Server 2012 R2 x64

Solution: Local Security Policy > Local Policies > Security Options > User Account Control: Run all Administrator in Admin Approval Mode : Disabled

Once done, Please reboot the server, You should be good to go

Thanks..

Deb | Debabrata Chakraborty

EMCISA, EMCIE - Data Domain, EMCIE - NetWorker, MCITP, MCTS, MCSA, CCNA

EMC NetWorker, EMC Data Domain, Symantec NetBackup

Please Like my Post if you liked it, Please Mark it as Helpful if it helped you, and mark it as Correct Answer if it resolved your query

tsamuel0905
2 Iron

Re: MS SQL DB Backup

Jump to solution

Thanks all reboot required for this. My issue got fixed. Thanks again.

0 Kudos
karelkunz
1 Nickel

Re: Re: MS SQL DB Backup

Jump to solution

Thank you for your post Debabrata; it solved my problem and I was able to get my client's SQL backups going.

-Karel

juanito0o980
1 Copper

Re: MS SQL DB Backup

Jump to solution

thanks a lot #Deb  have the same proble with NMM 3.0.1 And netwroker 8.1

on a WS 2012 R2 x64 and SQL ENT 2012 SP2 over Cluster active-pasive..

this solution works fine!

Solution: Local Security Policy > Local Policies > Security Options > User Account Control: Run all Administrator in Admin Approval Mode : Disabled

0 Kudos
Deb_PS
2 Iron

Re: MS SQL DB Backup

Jump to solution

Please Mark my answer as Solution, else this thread is still showing open

Thanks

Deb

Please Like my Post if you liked it, Please Mark it as Helpful if it helped you, and mark it as Correct Answer if it resolved your query