Home Forums SQL Server 2008 SQL Server 2008 - General Determine if a database is read-only when the log is not marked as read-only so DBCC SHRINKFILE may be skipped? RE: Determine if a database is read-only when the log is not marked as read-only so DBCC SHRINKFILE may be skipped?

  • Gail,

    'Prod' system for Finance what-if scenarios - which we rebuild every morning from the previous day's 'true' prod.

    They run all kinds of queries against the old data - so when we go to restore yesterday's data - we first clear out yesterday's log in case we have disk space issues.

    Don't lose sight of the actual question 😀

    Thanks,

    Doug