Sunday, February 19, 2012

attaching to msdb db

Hello there
On the business i;m working on, I've installed MSDE on my client computer.
So far i've worked with SQL sever 2000
now i transfered to sql server 2005.
and i tried to attach one of my files. It gave me Error because my DB i;m
trying to attach is bigger then 2GB (which is not possible according to
microsoft Licence)
now what can i do,
if i instead of detach and attach i do backup and restore it allow me to do
that?Roy
SQL Server 2005 Express Edition has 4GB limited .Or do you try to attach
SQL Server 2005 to MSDE database?
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:umkvw3UGHHA.4116@.TK2MSFTNGP05.phx.gbl...
> Hello there
> On the business i;m working on, I've installed MSDE on my client computer.
> So far i've worked with SQL sever 2000
> now i transfered to sql server 2005.
> and i tried to attach one of my files. It gave me Error because my DB i;m
> trying to attach is bigger then 2GB (which is not possible according to
> microsoft Licence)
> now what can i do,
> if i instead of detach and attach i do backup and restore it allow me to
> do that?
>

No comments:

Post a Comment