January 25, 2011 at 7:57 am
Hi,
Is there a way to run the job with windows login id beacuse i have to push the backup on 1st day of every month to a shared drive which i only have given access.
kindly help how can i proceed with this.
Regards
Durai Nagarajan
January 25, 2011 at 8:02 am
Assuming the backup is run by SQL Agent, it's run under the security context of the SQL Agent service account.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 25, 2011 at 8:44 am
Hi,
you mean to say it is not possible.
if not, is there any other way to push it to that share drive in my windows login id.
thanks in advance.
Regards
Durai Nagarajan
January 25, 2011 at 8:51 am
durai nagarajan (1/25/2011)
you mean to say it is not possible.
Err, no that's not what I said at all.
SQL agent runs under a specific windows service account (check the SQL Server Configuration manager to see which account it is).
The backup job will, as a SQL Agent job, run under that security account. It's a windows account and hence can have permissions granted to it like every other windows account. If it's not a domain account (something like local system or network service), it will be necessary to change it to a proper domain account (created specifically for SQL Agent, do NOT use your domain account) in order to grant it permission to network resources.
You should not be the one with access to the shared drive (what happens if your account is locked because of incorrect password or you leave?). The SQL Agent service account should be granted permission to that drive.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 25, 2011 at 9:00 am
Hi,
sorry for misunderstanding.
My IT team is not ready to give access (as per policy) that is why i want to run this job only in my domain login.
i left out with a manual job of copying it from backup folder to the specified netword drive every month.
is there any way to run this specific job only in my domain login (sorry for giving information on part basis).
if its out side sql like bat file to copy the backup file to share drive is also fine.
thanks again in advance.
Regards
Durai Nagarajan
January 25, 2011 at 11:19 am
I would suggest you speak to the IT team about that policy. It's an appallingly bad security practice for an individual's domain login to be used for scheduled tasks (password changes, account lockouts, resignations, etc)
Normally it's the other way around, only the service accounts have access and individual domain accounts don't.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 28, 2011 at 12:17 am
another thing you can do is:
1. backup the database like you are doing now
2. use windows task schedule to fire off a .bat file that will copy the files over to the share.
-----------------------------
www.cbtr.net
.: SQL Backup Admin Tool[/url] :.
January 28, 2011 at 4:01 pm
hi,
how to do this with my windows login, kindly help.
Regards
Durai Nagarajan
January 28, 2011 at 4:12 pm
check here
http://www.iopus.com/guides/winscheduler.htm
-----------------------------
www.cbtr.net
.: SQL Backup Admin Tool[/url] :.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply