Are you certain that SQL2005 EE will allow you the rights to do that function? We had some developers install SQL 2005 Express and some tasks and functions were not...

Thanks for the script Cowboy. It also helped show me that a job that I thought was running was not scheduled! Oops! With over 200 jobs scheduled it was hard...

Thanks Bob! great script!

Is both the server and your management studio instance on service pack2 and have you also applied kb933508? You should be at release 9.0.3050 at the very least for the...

sorry but I see in my reply that the mapping declaration is missing

\\ipaddress or dns name\shared folder

is what should have shown up

Why not just have the log backup go directly to the destination server?

Within the backup task and the create backup file -> folder value could be

\\

Firewalls may need to...

We do two types of backups.

As DBA, I schedule my backups of the SQL2005 servers using SQLbackup routines for time that are best for the databases and save to...

YES! I am tired of picking and choosing hotfixes that are recommended to wait for a service patch that isnt here( and may not come). Just release a full Patch...

Thanks Ash! All good info and great that all of you are willing to help your fellow DBA's in need! 😀

My understanding of the issue is not to have the Tempdb files on the C drive. What I have done is to move the Ldf file to the log drive...

THANK YOU! JEFF! That is what I was looking for! I can now use this and do some testing with my databases, the sizing statistics just add to my already...

Message

Non-SysAdmins have been denied permission to run CmdExec job steps without a proxy account. The step failed.

Sorry though I posted the last to the general list... Will be doing that! Sorry again!

I am struggling to lock down security for the sql2005 production system. For ssis users I have set up the group of developers to have in msdb db_dtsadmin, db_dtsltduser, db_dtsoperator...

Chappy, if you are doing one trans backup nightly between your weekly full, why not do a diff backup nightly instead? Also if you are only doing the trans backup...