SQL Server Performance

Log in or Sign up

Search Results

SQL Agent Job - Problem trying to select user to "Run As"

Post by: dso808, Apr 13, 2011 in forum: SQL Server 2005 General DBA Questions

Hi Luis and thanks for replying! Agh - finally found out what to do! You just go to login account properties > User Mapping and map the account to...
SQL Agent Job - Problem trying to select user to "Run As"

Thread by: dso808, Apr 11, 2011, 2 replies, in forum: SQL Server 2005 General DBA Questions

I have a job that runs a script. I want the script to "RUN AS" a login account that has been added to the instance. The problem is, in the window...
SQL Server Backup Job Maintenance Plan - Problem with Proxy Account and Permissions

Post by: dso808, Apr 5, 2011 in forum: SQL Server 2005 General DBA Questions

Hi satya - OK, I think I found an easy way out of this. I'm keeping the maintenance plan to do the cleanup in the beginning of old backup files....
SQL Server Backup Job Maintenance Plan - Problem with Proxy Account and Permissions

Post by: dso808, Apr 4, 2011 in forum: SQL Server 2005 General DBA Questions

Hi satya and thanks for replying. I gave the proxy account 'db_backupoperator' rights in the msdb database which also gives the proxy account...
SQL Server Backup Job Maintenance Plan - Problem with Proxy Account and Permissions

Thread by: dso808, Apr 1, 2011, 6 replies, in forum: SQL Server 2005 General DBA Questions

I created a SQL Server Maintenance plan to backup all our databases and store the files on a share. The job owner is "SA" but the job step is set to...

Showing results 1 to 5 of 5