Post reply

Drop a column from a table without logging?

  • March 10, 2004 at 1:32 pm

    #107937

    Whoops! Sorry just noticed I posted in the wrong forum ...Just ignore me!

    Hi-

    We have a database that has grow too large for comfort (SQL Server 2000). 66G on a 68 G drive. One of the columns in the main table is a blob holding all the data + that makes up the other columns. We have decided that we can do without the blob in order to allow ourselves more time to deal with the expanding data.

    That one table is almost 48 G and I figure that the blob column is at least half of that.

    My question is - can I drop that column without logging it? Or perhaps the correct question is - does dropping a column get logged? I fear that we would run out of room for the log file if it has to log the transactions.

    Thank you in advance!

    Kari Storm

    NewsBank, inc.

    Kindest Regards,

    Kari Storm
    NewsBank, inc.

  • March 15, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • March 15, 2004 at 9:21 am

    #498789

    No- It's OK - I realized I posted in the wrong place and didn't see a way to delete the post? I have gotten answers down in the "SQL SERVER - Administration" forum.

    Thanks though!

    Kindest Regards,

    Kari Storm
    NewsBank, inc.

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

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