Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-10-03 : 09:48:16
|
| Meik writes "Hello,like I've already experienced and like it's also written down in KB ArticleQ295022, the SQLMAINT utility is missing in the standard installation of theMicrosoft SQL Server 2000 Desktop Enginge;after having SP2 installed I tried to create a maintenance plan that shouldsimply backup one database every minute (just for testing), BUT the jobhistory gives me following error:<snip>Executed as user: NT AUTHORITY\SYSTEM. sqlmaint.exe failed. [SQLSTATE 42000](Error 22029). The step failed.andThe job failed. The Job was invoked by Schedule 43 (??????). The laststep to run was step 1 (Step 1).</snip>furthermore....1st) the dialog for editing the maintenance plan gives some strange errorsafter trying to store the modified schedule; something like "errorconverting int to tinyint" or a message with special characters...2nd) the dialog for editing the schedule does not store the set informationcorrectly; if I setup the schedule to every day and every minute it shows me(after closing & re-opening) every 366 days and every 716432 hours.3rd) the checkbox "Verify integrity of the backup upon completion" in thetab "Transaction Log Backup" is active, even the checkbox "Backup theDatabase as part of the Maintenance Plan" is NOT checked. Unchecking thisoption, confirming the dialog and re-opening it will activate this checkboxagain.4th) the schedule name, in the SQL Server Agent Job List, that is associatedto the Maintenance Plan, contains special characters (see error messageabove).can anybody help out here? the most recent Anti Virus Software is runninghere and when I use a SQL Server Instance everything goes fine...Kind regards & many thanksMeik Schuetz" |
|
|
|
|
|
MSDE 2000 SP2 and Maintenance Plans do not work !?