SQL set up maintenance plan ??
Posted on 2010-08-12
We have a program to track donations to our non-profit. The engine is SQL.
The donors program works fine , I never have to fool with it. However I want to assure myself that what I think is the backup really will work if needed.
I'm trying to get the Maintenance Plan Wizard to come up. It says, select the db, expand the Management folder and right click on Maintenance Plan Wizard
Well, "Maintenance Plan Wizard" isn't there.
In the help for SQL 2005,iIt says 'you must be a member of the sysadmin fixed server role'. Near as I can figure both users I logged in as are in that role.
I think a backup is alrady running: I see the folder it should be in and files with appropriate dates. But I can't figure out what the schedule is (or is it backing up in real time?)
You may have guessed I'm a noobie at SQL. Sorry.
I think I'm using MS SQL Server 2005 Express, on a Windows 2000 Server.
The donor program is SAGE 50 Fundraising