Post reply

Maintenance Plan does not kick off - pl.help

  • March 23, 2007 at 5:39 pm

    #173023

    This is a brand new install of SQL*Server on my laptop and i created a new db. I am able to insert rows into the new table. But when i schedule Maintenance plan it does not get kicked off. I donot see any entries in the log as well. I am backing up to disk and the directory exists.

    Any ideas.

    Thanks

  • March 26, 2007 at 8:29 am

    #696883

    sql server agent must be started in order for jobs to execute...is it running? on a laptop, you often do not turn on that service...

    if you go to Enterprise manager and right click>>Run, does the job run?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • March 26, 2007 at 6:02 pm

    #697024

    Hello Lowell

    You were correct in saying that. Thanks for that. Now the full database backup is running for all the databases successfully but the transaction log is getting backed up only for one database. Therefore i removed the trn.log backup from the current maintenance plan and created a new maintenance plan for backing up the transaction log only. But i am still not seeing this one getting kicked off.

    Any help would be appreciated.

    - SQL Server Newbie

  • March 27, 2007 at 5:05 pm

    #697289

    I found it.. I had to change the RECOVERY MODEL to FULL (instead of SIMPLE) under the database OPTIONS. That did it!!!.

    Thanks for all the help.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply