writing a trigger is always a option for me but wanted to check if we have something else than trigger.

thanks John for all your help and suggestions

thanks for the suggestion John,i will talk to the user but coming back to my initial question, is it possible to stop dbowner from droping the DB?

can you suggest me what all permission i need to give him if requestor is saying they can do anything in and with database except dropping it.

No i can'nt do that, to explain a bit more what i need is.

we have few database created by few logins, the login which created the database is assigned DBowner...

Hi,

Need your Help!!!!!

i have installed MYSQL Connector and created New Data Source but when i a try to create new linked server i am not seeing the "OLE DB Provider...

as you strongly think this could be the issue i will check it today that way and let you know.

hope you reply to me tomorrow.

Its Native backup size, lite speed backup size close to 240 GB. timing is npot fixed, it sometime fails in 1 hours and sometime takes 9 hours.

@john-2:

Just ran...

close to 650 GB, and takes around 13 Hour to complete

if its a permission issue how my Tlog backup is running successfully?

its only full backup thats increasing my headache.

when i ran it manually it ran successfully so network issue should...

its already unchecked, any other idea?

UNC Path has Space and the Login hasfull access on that location.

Do anybody have any idea?

i am getting the same error, did creating subdirectory resolved the issue?

please reply. need your help.

No, i am taking backup on UNC path