December 17, 2008 at 5:31 am
Hey all.
In my work place, we have a job running every night which does a backup of the DB's. However, it only seems to do a subset of the DB's, not all of them. I cant figure out why not!
The job running is:
EXECUTE master.dbo.xp_sqlmaint N'-PlanID BA9538A6-2D9C-4A8F-BD3F-6C45A886F897 -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpDB "E:\SQLBackup" -DelBkUps 2WEEKS -CrBkSubDir -BkExt "BAK"'
There isnt anything there which I can change. Unless the Plan ID does something.
How do I get it so that all DB's are backed up?
December 17, 2008 at 5:43 am
Paul, you've posted this in the SQL 2005 forum, but the maintenance plan you're using is from 2000. So I'm not sure which version you're actually using.
Anyway the code you posted is just the jobstep, not the maintenance plan definition. The plan definition contains which databases are part of the plan.
[font="Verdana"]Markus Bohse[/font]
December 17, 2008 at 5:48 am
ah sorry, yeah its 2000 im using. Where can i see the maintenance plan?
December 17, 2008 at 5:57 am
In Enterprise Mangaer under Management\Database Maintenance Plans
[font="Verdana"]Markus Bohse[/font]
December 17, 2008 at 5:58 am
thanks for your help, found where it is I need to change
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply