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.