Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2004
    Posts
    191

    Unanswered: Primary Filegroup is Full

    I have encounting this problem:

    DESCRIPTION: Error: 1105, Severity: 17, State: 2
    Could not allocate space for object 'iislog' in database 'IISLOG' because the 'PRIMARY' filegroup is full.

    I have check to see if the file is autogrow and it is. Is there a way to solve this problem?

    Thanks

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Can the file grow? Is there enough room on the disk drive?

    -PatP

  3. #3
    Join Date
    Jul 2004
    Posts
    191
    Yes the file can automatically grow at 10%. The space allocated is 13789MB and the actual file is 15707MB. I raise the automatically grow to 25% and that stop the SQL Messenger from sending me the email. I know it's a quick fix and that there is a major problem that is coming down the pike. Here are the configurations for the disk drive that the file is located on.

    Capicity: 67.8 GB
    Used: 64.9GB
    Free: 2.83 GB

    What would I need to do to solve this problem.

    The name of the database is IISLOG which will only keep on growing. Because it logs all of the transactions from the intranet.

    Please Help!!

    Thanks

    Lystra

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    You need to offload data to another drive...you should be out of space.....just.....about.......now.....

    It's probably 1 log table.......which probably has a date....

    You should schedule a nightly process to do this... I think I would bcp out the data...

    There's another problem though....the transaction log will have to handle the deletes....
    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.

  5. #5
    Join Date
    Jul 2004
    Posts
    191
    How would I go about doing this.

    Is it possible for me to copy and paste the database file to another drive in order to free up space? Or would I need to write code to do this?

    As for the transaction logs they are truncating the logs.

    Currently we are using the code below to remove the data, however the code is not removing all of the data and archiving it. It's causing major problem mostly on the weekend.

    CREATE PROCEDURE sp_cleanupLOG AS
    declare @Today varchar(10)
    select @Today = convert(varchar(10),getdate(),101)
    --select @Today = '2002-03-30'
    /*
    delete rows from current iislog table
    */
    delete from IISLOG..iislog
    where ( LogTime >= DateAdd(day, -1, @Today) AND LogTime < @Today )

    GO

    Also if I use BCP to get the data out, can I schedule it as a job?

    Thanks

    Lystra

  6. #6
    Join Date
    Sep 2004
    Posts
    15
    Dont know whether it is suitable for you!

    can you Dump the transaction log (Dump tran <databaseName>) everyday and take a back up of your database to another disk.

    regards
    Rohit

Posting Permissions

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