Post reply

What is the size limit on a database to do mirroring?

  • July 5, 2010 at 7:16 am

    #237296

    Hi guys, I would like to help me determine what the size limit on a base database for me to make mirror.

    I have a 250GB database and continues to grow, and I would like to know if I can do with a mirror database:

    SQL Server 2005 Enterprise Edition, sp3 both servers

    32bit

    Windows Server 2003 r2 sp2

    enough disk space

    Thanks a million.

  • July 5, 2010 at 7:30 am

    #1188768

    There is no database size limitation for mirroring. For your 32-bit system will be limitation of maximum of about 10 databases per server instance.

    All restrictions can be found in BoL:

    http://technet.microsoft.com/en-us/library/ms366349(SQL.90).aspx

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

  • July 5, 2010 at 8:05 am

    #1188780

    Ok, Thank you my friend! 🙂

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply