Results 1 to 10 of 10
  1. #1
    Join Date
    Nov 2003
    Posts
    68

    Exclamation Unanswered: Backup transaction log

    Hi,
    I have error when i backup the transaction log of master and msdb database.
    I think there is an error because the model of this database is simple.
    can i modify the model and write full ?

    I have another question,
    I have a db with 1 db file of 11Go, i have to create secondary files or not.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    No, you can't change the Model database.

    No, you don't need to add secondary files, but it might be a good idea.

    -PatP

  3. #3
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Red face Backup transaction Log

    Are you using the enterprise manager?

  4. #4
    Join Date
    Feb 2004
    Location
    PAKISTAN
    Posts
    106
    Master database doesn't allow Differential or log backups.
    Post the error message that u get while backing up the transaction log for msdb.


    Howdy!

  5. #5
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Cool Backup transaction Log

    From the tool list go to shrink database; File; change shrink to transaction log. before implentation. Go out to network and very the log size. Then go back to EM and shrink log. Again go for verifaction.

    Live from Dodge City USA, Washington DC

  6. #6
    Join Date
    Nov 2003
    Posts
    68

    Backup ...

    Yes i using entreprise manager


    the error i get for msdb is the following :

    "La sauvegarde ne peut être effectuée sur cette base de données. Cette sous-tâche est ignorée"

  7. #7
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Unhappy Backup transaction Log

    Sorry, I need to see that in English

  8. #8
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    viola

    "the safeguard cannot be carried out on this basis of data. This sub-task is ignored "
    Google...yeah baby....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  9. #9
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by garrydawkins
    Sorry, I need to see that in English
    To quote W.C. Fields "Go away kid, ya bother me!"

    The nickel translation is something like: "That option can't be used for this database. It will be ignored."

    -PatP

  10. #10
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Thumbs up Backup transaction Log

    Again, I'm working with lots of data. about 290,000,000 records. In the cleanup process backups of the data is most important. After each batch run I shrink the transaction log. With that amount of data soon the log will be as big as the data file. At least that's what I was running into. Please follow the instruction above.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •