sorry about that. my mind went blank for a min when i posted that....i found that script below...but we dont want to schedule that to do our daily backup...only do...

hello,

could you please explain or point me in the right direction when you says "Ola Hallengren's procedure" ?

Thank you Grant, that did the trick for me.

Sorry i guess i should have given some background.

This is just the procedure that was created when i am using the tool called "hammerDB", i am sure you...

Hello all,

When i try to run the procedure i get below error...any ideas why? SOrry i am very new to SQL Server.

Msg 139, Level 15, State 1,...