• We're not losing data doing this.

    If the database is in a transactionally inconsistent state, sql won't attach it and we retrieve the logs as necessary. Out of the last 4000 databases we did this to, this meant we had to copy 3 log files and attach 3 databases manually.

    I'm not doing this in emergency mode or forcing the attach, if there's an error on the attach we retrieve the logs, this is an expediency measure, nothing more.

    We also take full backups before we do this task. In case we need them. So far we're 4002 out of 4002.



    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]