Hi there

I want to do a bulk back up nightly of all my databases running on SQL server - does anyone have a script to do it?

I'm using this:

EXECUTE master.dbo.xp_sqlmaint N'-PlanID 3460376E-CAEE-42EB-B2FD-1B8C70293FEA -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpDB "F:\SQL Server Data\MSSQL\BACKUP" -DelBkUps 4DAYS -CrBkSubDir -BkExt "BAK"'

but when I check the history, the error it gives is:

sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.

Any help greatly appreciated

Many thanks

Adam

Why don't you just set up a maintenance plan in EM and let SQL Server agent execute it for you on whatever schedule you choose?

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

Thanks Jeff

That's alot easier!