June 8, 2007 at 1:04 am
We have a SQL database that will not backup if you try to backup it up inside Enterprise Manager. However if you run a backup job using SQL Agent the database will back up. Has anyone seen this before?
Thanks
June 8, 2007 at 10:04 am
What happens? check the Windows and SQL logs when it fails.
June 11, 2007 at 8:24 am
What credentials is the SQL Agent using ?
What credentials is the SQL Job using ?
What credentials is the EM using ?
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
June 13, 2007 at 12:49 pm
Thanks for the replies, I will double check what you both mentioned. Would have replied sooner but the notifications that you both replied to my post were stuck in the spam filter for our mail. Let you know what I find out.
Thanks Again
June 13, 2007 at 1:01 pm
The EM and SQL Agent are configured to use the Local System Account and the Backup Job is configured to use the local admin account.
June 15, 2007 at 9:41 am
Another question ... are you performing the backup to a local drive or a mapped drive ?
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply