Rebuild SQL server 7 db

Our NT 4.0 server machine's motherboard burned out. After placed the hard
disk drives in a new box, we got a video issue and disk I/O error. Therefore
I installed SQL server 7 on a new Win2K server box. The hard disk drives on
the NT server are fine and placed in the new box. I can't use detach or
attach sp from the new box. How can I restore the db to the new box?
Thanks,
Eli>> I can't use detach or attach sp from the new box.
You mean, you are getting some errors while trying to attach the databases?
If so, what are they?
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Eli Feng" <efeng@.kerisys.com> wrote in message
news:uVLY7pbkFHA.2444@.tk2msftngp13.phx.gbl...
Our NT 4.0 server machine's motherboard burned out. After placed the hard
disk drives in a new box, we got a video issue and disk I/O error. Therefore
I installed SQL server 7 on a new Win2K server box. The hard disk drives on
the NT server are fine and placed in the new box. I can't use detach or
attach sp from the new box. How can I restore the db to the new box?
Thanks,
Eli|||Hi,
If you have all the physical files (MDF, NDF and LDF) belongs to SYSTEM and
User databases then you can do below:-
1. Install SQL Server 7 in the same folder as old installation
2. Apply the same service pack as old
3. Stop SQL Server service
4. COpy the new physical files to a new folder
5. Copy the physical files (MDF, NDF and LDF) from the old server to the
exact folders as old
6. Start the SQL Server service
7. Open enterprise manager and see if all the databases are ok.
Incase if this step fails then you need to:-
Restore the databases from last good backup.
Thanks
Hari
SQL Server MVP
"Eli Feng" <efeng@.kerisys.com> wrote in message
news:uVLY7pbkFHA.2444@.tk2msftngp13.phx.gbl...
> Our NT 4.0 server machine's motherboard burned out. After placed the hard
> disk drives in a new box, we got a video issue and disk I/O error.
> Therefore
> I installed SQL server 7 on a new Win2K server box. The hard disk drives
> on
> the NT server are fine and placed in the new box. I can't use detach or
> attach sp from the new box. How can I restore the db to the new box?
> Thanks,
> Eli
>|||Hi Narayana & Hai,
Thank you so much for your replies. Because the db was not normally
detached, therefore I didn't know how to attach it to a new SQL serverl.
I'll try Hai's instructions to see how it works. Thanks again, really
apreciate it.
Eli
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:ursSf8gkFHA.3828@.TK2MSFTNGP12.phx.gbl...
> Hi,
> If you have all the physical files (MDF, NDF and LDF) belongs to SYSTEM
and
> User databases then you can do below:-
> 1. Install SQL Server 7 in the same folder as old installation
> 2. Apply the same service pack as old
> 3. Stop SQL Server service
> 4. COpy the new physical files to a new folder
> 5. Copy the physical files (MDF, NDF and LDF) from the old server to the
> exact folders as old
> 6. Start the SQL Server service
> 7. Open enterprise manager and see if all the databases are ok.
> Incase if this step fails then you need to:-
> Restore the databases from last good backup.
> Thanks
> Hari
> SQL Server MVP
>
> "Eli Feng" <efeng@.kerisys.com> wrote in message
> news:uVLY7pbkFHA.2444@.tk2msftngp13.phx.gbl...
hard[vbcol=seagreen]
>sql