• I would think you could get a handle on the sizes simply by querying the backup history tables.

    For me, much of this is simply ease of administration. As stated, it's easier to juggle the multiple small files. Then again, the dbs here aren't horrifically large. So our backups aren't that big either. They're compressed, so they're only around 5-10gb.

    Our biggest db is only 256 gb. Which make me ask, in the community's experience, what is average size of the dbs? Understood that size is only part of the question (xactions/sec is equally important). But our transactional dbs are split into multiple small (<20gb) dbs. The "big" one is a consolidated reporting db.

    Honor Super Omnia-
    Jason Miller