Gail - your script works like a charm. Thanks! Really appreciate all the help and I definately learned a lot more about transaction logs. Have a great...

GilaMonster (7/7/2011)

---

dso808 (7/7/2011)

---

Hi Gail and thanks so much for your response. OK, the disk where our transaction log file is stored only has about 13GB of space available. ...

What happened there is that the delete ran, filled the log and rolled back. By the time you checked sys.databases, the delete had rolled back and a checkpoint had run...

Hi and so sorry about the delay in response. Looks like Powershell is the next new skillset I'll have to acquire. Thanks to everyone for their input!

Hi Ray - not exactly speeding up the backups per se, but just which disk is best to store the backups without it impacting overall database performance. Thanks.

Thanks very much George and Steve! Much appreciated. Have a great weekend.

Hi Jeff - OK, I've made some progress and found out through the Reporting Services Configuration Manager that the ReportServer and ReportServerTempDB databases are being stored on another server! ...

Hi Jeff and thanks for the reply! OK, both old and new servers only have the Report Server services installed. No database engine.

This is where I'm stuck. ...

Thanks Perry!

hoembrew01 - this is pretty embarassing 🙂 Thanks very much for pointing out the obvious. The variable was declared as '@name' (varchar(50) of course) where as in the...

Thanks Jim! OK, I gave our proxy account 'backupoperator' rights to msdb but then came up with this error:

Executed as user: afh\sqlbackupadmin. Microsoft (R) SQL Server Execute Package Utility...

Thanks opc.three. Much appreciated.

Hi Gianluca and thanks again for the reply. My apologies - I was worried about creating a proxy account because I thought that I'd have to jump through hoops...

Hi again Gianluca. Sorry, I spoke too soon. My backup job failed with an error stating that 'Non-SysAdmins have been denied permission to run DTS Execution job steps...

Thanks Gianluca! Sounds great. Appreciate the help and have a great week.