Can I create multiple MSDE DBs to counteract the 2gb limit?

  • Can I create 1.5 or 2gb slices of my database, put them all on one system, and query the appropriate DB using a filter?  It seems like it would work.

    Same thing if I had multiple access DB files on a computer, right?

    Basically, my group wants to go around IT and therefore SQL EE.  I think we can do that by splitting our 25g-50g need into multiple files/db instances.

    Doable?

  • Is this about the same topic in another post (the post was a lot longer but asking essentially the same thing)...

    See http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=229905#bm229935

  • Actually, the problem was I was describing the situation I thought was funny, but forgot to ask the question.  Should have just edited or put a reply.  =(

  • Yes, the other post was quite funny in comparison

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

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