Tuesday, March 27, 2012

Attach DB > 2 GB

I understand that there is a 2GB limit in MSDE so that
databases can't be created or expanded past 2GB. However,
if the database has come from SQL Server 2000 and is over
2GB (15GB)and is for reference only, is it possible to use
within MSDE?
Thanks for your help.
Hi Jake,
I haven't tried it but have heard from others that it will attach. However,
they had a variety of problems later. Wouldn't recommend it except to
perhaps extract some data.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Jake Levington" <anonymous@.discussions.microsoft.com> wrote in message
news:1fda01c47d34$abde4ae0$a301280a@.phx.gbl...
> I understand that there is a 2GB limit in MSDE so that
> databases can't be created or expanded past 2GB. However,
> if the database has come from SQL Server 2000 and is over
> 2GB (15GB)and is for reference only, is it possible to use
> within MSDE?
> Thanks for your help.
|||Or use SQLExpress which has a 4GB limit.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
news:%23J9cnfTfEHA.632@.TK2MSFTNGP12.phx.gbl...
> Hi Jake,
> I haven't tried it but have heard from others that it will attach.
However,
> they had a variety of problems later. Wouldn't recommend it except to
> perhaps extract some data.
> HTH,
> --
> Greg Low [MVP]
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
> "Jake Levington" <anonymous@.discussions.microsoft.com> wrote in message
> news:1fda01c47d34$abde4ae0$a301280a@.phx.gbl...
>

No comments:

Post a Comment