Friday, March 9, 2012

How can revert a SQL2K DB back to SQL7?

Hello. I have a SQL2K DB that needs to go on an SQL 7.0 Server. How can I
make it restore to the 7.0 Server?
Any help appreciated!
Thanks,
Tom
You could use DTS and copy Database. Unfortunately you cannot just do a
restore or an attach.
Jeff Duncan
MCDBA, MCSE+I
"Tom" <none@.none.com> wrote in message
news:OiUcI%23VWEHA.2716@.tk2msftngp13.phx.gbl...
> Hello. I have a SQL2K DB that needs to go on an SQL 7.0 Server. How can
> I
> make it restore to the 7.0 Server?
> Any help appreciated!
> Thanks,
>
> Tom
>
|||: (
Okay.. Thanks Jeff!
"Jeff Duncan" <jduncan@.gtefcu.org> wrote in message
news:%23C7ZAHWWEHA.3012@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> You could use DTS and copy Database. Unfortunately you cannot just do a
> restore or an attach.
> --
> Jeff Duncan
> MCDBA, MCSE+I
> "Tom" <none@.none.com> wrote in message
> news:OiUcI%23VWEHA.2716@.tk2msftngp13.phx.gbl...
can
>

No comments:

Post a Comment