• p.brat.23 (11/6/2010)


    Thanks for the update.

    In our case, data file is 96% used and we are getting alerts as it crossed the threshold.

    So I tried to increase the datafile size but with out success.

    So in and all, we can't increase/decrease the datafile size of a snapshot database..right!

    When was the snapshot created? Normally, you would create a database snapshot for a short period of time and then drop it.

    What is the purpose of this snapshot - and why do you still need it?

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs