Post reply

Data files/log files

  • October 22, 2003 at 10:47 am

    #65430

    We have a maintenance plan that backups the transaction log files and it has never ran. It says "Backup can not be performed on this database. This sub task is ignored".

    Also, I looked at the .mdf and .ldf files and the modified date is quite old.

    Can somebody give me some insight?

    I am quite new to SQl Server.

    Thanks!!

  • October 22, 2003 at 11:16 am

    #479146

    Check the DB recovery mode.

  • October 22, 2003 at 11:59 am

    #479154

    What database?

    The Transaction Log (TL) for the Master database CANNOT be backed up. It's 'locked' into SIMPLE Recovery mode.

    For other databases, in Enterprise Manager, right click on the database, select Properties, go to OPTIONS tab and check the Recovery Mode as Simon suggested. If it's SIMPLE, you can't backup the transaction log.

    Again, first thing we need to know is which database are you talking about.

    Some system databases aren't used much, if at all.

    -SQLBill

  • October 22, 2003 at 12:36 pm

    #479165

    The default databases except exceptionally used may not benefit from transaction log backups.

    Tempdb cleared every time sql server is stopped and started.I do not back it up

    Pubs and Northwind -I back them up once since They are meant for you to play with.

    master msdb record job history system changes ,store configurations ...

    I back them up once a week and whenever sp_configure is run master is manually backed up(not too big)

    Model database One one time copy just in case

    Mike

  • October 23, 2003 at 6:51 am

    #479274

    The database that I'm trying to backup is our production and transactional database. The recovery mode is set to Full.

  • October 23, 2003 at 6:51 am

    #479273

    The database that I'm trying to backup is our production and transactional database. The recovery mode is set to Full.

  • October 23, 2003 at 7:12 am

    #479279

    For the db that has a failed TLog backup,

    has the full backup run with success?

    You must have a full backup completed before

    the TLog backup can run with success.

    Also, to be explicit, you can not backup the master log file, so don't include master

    in any transaction log backup job or maintenance plan.

  • October 23, 2003 at 7:25 am

    #479285

    It seems to be working now..

    Thanks for all your help!

Viewing 8 posts - 1 through 7 (of 7 total)

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