You need to allow SQL Server Agent to use tokens (option available in SQL Server Agent properties). There is security risk associated with this: http://msdn.microsoft.com/en-us/library/ms175575.aspx.

Hi,

By default job owner is login that created job and this is in most cases member of sysadmin role. Later the owner could be changed to the login that is...

Before you detach database check which login mapped to dbo user in database, also run DBCC CHECKDB. When you detach database use @skipchecks = 'false' option to make sure statistics...

It looks like tables (or schemas) ownership issue. I have never had this issue, but you can try to transfer ownership to another user http://technet.microsoft.com/en-us/library/ms187359.aspx%5B/url%5D.

You can use SSIS Transfer Jobs Task to copy jobs from one server to another:

http://www.sql-server-performance.com/articles/dba/ssis_transfer_jobs_task_p1.aspx

Try MSDB stored procedure:

sp_update_job @job_name = 'job_name', @owner_login_name ='login'

Make sure new login has permissions on SQL Server.

Do you backup to the local disk or network location? Does SQL Server service account has access to the backup location?

Also, make sure that you update databases statistics regularly.

Don't drop the log file! There could be transactions that are not saved to the database. Try to query these DMVs to see if there are any active transactions: sys.dm_tran_locks,...

Hi Juanita,

Does your table have any datetime columns that track when records have been created?

You can compare the time of the largest transaction logs' backup with index optimization jobs schedules. For some of my databases log grows dramatically during index rebuild tasks.

We've tried CommVault SQL Server agent backups, but decided to go back to the SQL Server native backups which backed up later as .bak files using CommVault.

The main reason was...

There are no really rules about transaction log's sizing. It depends on too many factors. The best answer is the latest Paul Randal's Q&A publication in SQL Server Magazine: http://www.sqlmag.com/blogs/sql-server-questions-answered/sql-server-questions-answered/tabid/1977/entryid/12625/Default.aspx

Sorry, I misstyped it:

FOR /F %a IN (srvList.txt) DO osql -S %a -E -d master -Q "EXEC sp_helpsrvrolemember 'sysadmin' " -n -h-1 -s , -w 1000 >> "output_SrvRoleMember.txt"

Backup existing DB and restore it as NewNameDB. You will have to use MOVE option on restore to rename database files:

RESTORE DATABASE NewNameDB

FROM OldDB

WITH...