Adding a version 7 DB to SQL2000

I would like to add a version 7 DB to my SQL 2000 Server. I was wondering if there was a way to add and upgrade it to version 2000 without installing version 7 on the machine? If I have to install 7, what is the best procedure with an existing install of 2000? Any help would be greatly appreciated.You can use either BACKUP/RESTORE or sp_attach_db
SQL Server 2K will automatically upgrade your database during restore or
attach process.
After you will restore or attach your database it is suggested to make
update statistic and if it is possible database re-indexation.
Regards
---
All information provided above AS IS.
"TonyHeuft" <theuft@.cha.ab.ca> wrote in message
news:2AE0F362-5E3A-496C-A0B6-D1B8237BF92C@.microsoft.com...
> I would like to add a version 7 DB to my SQL 2000 Server. I was wondering
if there was a way to add and upgrade it to version 2000 without installing
version 7 on the machine? If I have to install 7, what is the best procedure
with an existing install of 2000? Any help would be greatly appreciated.|||Hi Tony
Can you elaborate on what you mean? Do you have backups of a SQL 7 db or the
actual .mdf and .ldf files?
If you have a backup, you can restore a SQL 7 backup to a SQL 2000 server,
if you have the files, you can use sp_attach_db.
Please read about the appropriate topic RESTORE or sp_attach_db in the Books
Online.
You do not need to install SQL 7.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"TonyHeuft" <theuft@.cha.ab.ca> wrote in message
news:2AE0F362-5E3A-496C-A0B6-D1B8237BF92C@.microsoft.com...
> I would like to add a version 7 DB to my SQL 2000 Server. I was wondering
if there was a way to add and upgrade it to version 2000 without installing
version 7 on the machine? If I have to install 7, what is the best procedure
with an existing install of 2000? Any help would be greatly appreciated.|||What is it you have exactly? Is it a backup or just the detached files? In
either case it should not be a problem as the upgrade happens automatically
when you attach or restore it.
--
Andrew J. Kelly
SQL Server MVP
"TonyHeuft" <theuft@.cha.ab.ca> wrote in message
news:2AE0F362-5E3A-496C-A0B6-D1B8237BF92C@.microsoft.com...
> I would like to add a version 7 DB to my SQL 2000 Server. I was wondering
if there was a way to add and upgrade it to version 2000 without installing
version 7 on the machine? If I have to install 7, what is the best procedure
with an existing install of 2000? Any help would be greatly appreciated.