|
Home > Archive > MS SQL Server > December 2006 > attaching to msdb db
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
attaching to msdb db
|
|
| Roy Goldhammer 2006-12-06, 7:12 pm |
| 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?
| |
| Uri Dimant 2006-12-06, 7:12 pm |
| 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?
>
| |
|
| Maybe one of the following will help you:
1. If the db has a lot of free space, see if shrinking will reduce the size.
2. Move some tables into a new database, then shrink and attach both.
3. Delete and/or move some of your older data into a new database, then
shrink and attach both.
|
|
|
|
|