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[vbcol=seagreen]
> 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
>

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...
> > 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
> >
> >
>

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

Re-boot is OK

Hi,
Rebooting is not a permanent solution.
Poor coding techniques & H/W resources not being planned
well for a SQL Box and Insufficient Hardware. Start
working on...
1. Application Tuning .
2. SQL Server Tuning ( not needed in most cases)
3. hardware Tuning
There is a good book from Microsoft press titled " SQL
Server 2000 Performance Tuning Tech Reference" by Whalen.
Also refer to Refer www.sql-server-performance.com . They
have loads of stuff on performance tuning.
HTH
Regards
THIRUMAL REDDY MARAM
Sys Admin / SQL DBA

quote:

---

>--Original Message--
>Does anyone know ehrn my SQL server is slow then I re-
>boot it. Onces I re-boot it, the SQL server performance
>become OK(normal). Does anyone know what is the problem
>and how to solve it.
>.
>

---

Hi,
During a problem situation do,
1. Use performance monitor to check the hardware usage,
1. CPU Usage
2. Memory Usage
3. Disk I/o
2. From query analyzer use sp_who to verify any blocked process.
3. Execute a select statment in sysprocess table to identify the
process/user using the resource
select substring(loginame,1,20) as login,cpu ,physical_io ,
memusage from sysprocesses
identify the user and execute a dbcc inputbuffer(spid) to check the
backend procedure / SQL he is executing.
Thanks
Hari
MCDBA
"Thirumal" <anonymous@.discussions.microsoft.com> wrote in message
news:115301c3df4b$ab6a0860$a601280a@.phx.gbl...[QUOTE]
> Hi,
> Rebooting is not a permanent solution.
> Poor coding techniques & H/W resources not being planned
> well for a SQL Box and Insufficient Hardware. Start
> working on...
> 1. Application Tuning .
> 2. SQL Server Tuning ( not needed in most cases)
> 3. hardware Tuning
> There is a good book from Microsoft press titled " SQL
> Server 2000 Performance Tuning Tech Reference" by Whalen.
> Also refer to Refer www.sql-server-performance.com . They
> have loads of stuff on performance tuning.
> HTH
> --
> Regards
> THIRUMAL REDDY MARAM
> Sys Admin / SQL DBA