Wednesday, March 21, 2012

Restoring SQL 6.5 backup into SQL 2000 on Server 2000

Hi,
Does anyone know of the best method to restore a SQL 6.5 backup into SQL
2000?
Thanks.Can't do that. Get a 6.5 installation, restore it there and use the Upgrading Wizard that comes with
SQL Server 2000 to get the data into your 2000 installation. Or use script, BCP, DTS or similar
method.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Millie" <Millie@.discussions.microsoft.com> wrote in message
news:C3B5CF7D-8515-4B48-B351-6865A5CBBA03@.microsoft.com...
> Hi,
> Does anyone know of the best method to restore a SQL 6.5 backup into SQL
> 2000?
> Thanks.|||However you can restore the backup to a SQL 7 install ( if you have one.)
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Millie" <Millie@.discussions.microsoft.com> wrote in message
news:C3B5CF7D-8515-4B48-B351-6865A5CBBA03@.microsoft.com...
> Hi,
> Does anyone know of the best method to restore a SQL 6.5 backup into SQL
> 2000?
> Thanks.sql

No comments:

Post a Comment