• 1 Production Environment

    3 Full Backups + 12 Differentials + 36 Transaction log backups on the production server

    1 Staging Environment

    1 Full Backup copied from Production at some ponit

    1 Development Environment

    1 Full Backup copied from Production at some point

    1 Product Research Environment (SQL 2012)

    1 Full Backup copied from Production at some point

    Each environment has a copy of the database on the instamce.

    All backups are compressed if that matters.



    --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]