Showing posts with label strange. Show all posts
Showing posts with label strange. Show all posts

Wednesday, March 28, 2012

Maintenance plan does not run

Hi - I have a strange situation where the Maintenance plan on a SQL 7, build 961 will not generate .BAK and .TRN files based on the maintenance plan (or at all). I have tried deleteing and recreating the maintenance plan, but, according to the system log, and to maintenance plan logs, the entire maintenance plan is not launching any tasks. However the application log whoes all the jobs as failing, but gives no furhter details.

However I have another server running build 623 that is working fine.

Any ideas from anyone? All help appreciated.Why use a maintenance plan - they give lots of problems.
Just schedule a backup job or jobs.
Have them call a stored procedure and put the backup statement in that.|||Here's the error from Eventlog:

SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan 'Webmon1'' (0x42E6C45B360CD611935D0002B330ABF9) - Status: Failed - Invoked on: 2/8/02 4:10:46 PM - Message: The job failed. The Job was invoked by User XXXXXX\Administrator. The last step to run was step 1 (Step 1).|||What happens if you try the same backup using a backup command?

Maintenance Plan bug on SQL Server 2005

Hello, everyone:

I have a strange trouble on SQL Server 2005 on XP/local and Win 2003/server. When I connect local database and create a backup plan named by "backup plan", I can see the name under "maintenance plan" and "Jobs" under SQL Server Agent. But if I connect to server database and do the samething, I cannot see the name under "maintenance plan". I can see the name under "Jobs" under SQL Server Agent. But cannot delete this job, and message:

Drop failed for job "Backup Plan".(Microsoft.SqlServer.Smo).

Did someone meet this bug and have suggestions?

Thanks

ZYTPermissions? Do you have the same permissions to the server as you do to your local SQL Server?|||Hi, Pootle:

Thanks for reply.

I have sysadmin permissions to the server.

ZYT

Permissions? Do you have the same permissions to the server as you do to your local SQL Server?|||Hi, Pootle:

The server is the remote one that our company just got from someone else. I login by "Remote Desktop Connection" and check SQL Server. From Start - Programs - SQL Server 2005, there is only "Configuration Tools" available, no other componences like "SQL Server Management Stadio". This is first time I sam and confused. What was happened?

When I connect server from SQL Server, I can all tables and stored procedrues.

Thanks

ZYT

Permissions? Do you have the same permissions to the server as you do to your local SQL Server?|||As I remember, there was a bug in SQL 2005 SP2 that affected Maintenance plans. Check to see what hotfixes are available.