Post reply

no space in db

  • June 7, 2016 at 1:42 pm

    #317106

    this is sql server 2012 with McAfree 5.3

    I have a 10gb db that is out of space. As in 0 mb free.

    I am trying to delete from EPOProductEvents and I get the

    " can not do this operation as the Primary file is full..."

    Same thing happened when trying to delete from OrionAuditLog.

    Is there something I can drop and recreate later to get around this?

    How is this handled in SQL Server?

    thanks.

  • June 7, 2016 at 1:51 pm

    #1883730

    What version of SQL are you using? Express?

    If you aren't using express do you have space on the hard drive in order to increase the size of the database? If so check this link out https://msdn.microsoft.com/en-us/library/ms175890(v=sql.110).aspx

  • June 7, 2016 at 1:55 pm

    #1883732

    I think it is Express. How do I tell?

    I wil try expanding the db as per the note.

    thanks.

  • June 7, 2016 at 1:59 pm

    #1883733

    SELECT @@VERSION will give you the SQL version

    if it is express there is a 10GB limit per database

  • June 8, 2016 at 8:13 am

    #1883884

    Microsoft SQL Server 2012 ( SP1 ) - 11.0.3156.0 (X64) May 4 2015 Express Edition 64-bit

    what is the difference between tables like:

    OrionAuditLog

    OrionAuditLogMT?

    Seems the only thing to do is drop objects ( i.e. indexes ). I am reading KB79561 "ePolicy Orch 5.x database size warning during upgrade".

    the tables:

    EPOEvents

    EPOProductEvents

    EPORollup_Events

    EPORollup_ProductEvents

    OrionSchedulerTaskLogDetail

    OrionAuditLog

    are listed in the article and can be purged.

    Can I drop indexes aossocaited with these tables and later recreate the indexes?

    This will create space?

    If so how do I do this? Create the ddl to later recreate and the proper way to drop the indexes?

    thanks.

  • June 8, 2016 at 9:00 am

    #1883895

    This is ePolicy Orchestrator, right? If you have a support contract, I think you should make a call.

    If your database is out of space through normal day-to-day usage, then you need to find a long-term solution because it's just going to happen again.

    If it's related to an upgrade, then get help from the vendor.

Viewing 6 posts - 1 through 5 (of 5 total)

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