Sunday, February 12, 2012

Attaching 2000 dbs to 2005

I installed ss2005 on a new machine. I try to attach a 2000 db and it found
an error (something in a view that it didn't like) and aborted the import.
I think it aborted on finding the first error but I'm not sure.
So, am I dead in the water? Do I have to take my db back to ss2000, deal
with the error and try a ss2005 atach again? If there are a thousand errors
would I have to do this a thousand times?
What If I just tried a restore' What's the best way to approach this
problem?
Many thanks, Tinn ManTinn
If I remember well , there is na upgrade advisor to make sure that sql
server 2005 'likes' everything
Also, I'd recommend you to backup database first and then restore it on sql
server 2005
"Tinn Man" <tm@.nospammeexcite.com> wrote in message
news:Oao7332hGHA.4404@.TK2MSFTNGP05.phx.gbl...
>I installed ss2005 on a new machine. I try to attach a 2000 db and it
>found an error (something in a view that it didn't like) and aborted the
>import. I think it aborted on finding the first error but I'm not sure.
> So, am I dead in the water? Do I have to take my db back to ss2000, deal
> with the error and try a ss2005 atach again? If there are a thousand
> errors would I have to do this a thousand times?
> What If I just tried a restore' What's the best way to approach this
> problem?
> Many thanks, Tinn Man
>

No comments:

Post a Comment