Recovering SQL server

Hello all,
Last night we had 2 drives die on our test machine. The data (all our
databases)has been regretably lost. My question is;
How can I use the Production box and copy all the databases over to the
newly installed drives? At this point, I am unable to even start the sql
server service. SQL 7 on NT4 both machines.
Any advice on how to recover this nightmare would be appreciated.
Thanks in advance,
Tom
Tom,
Use your backups instead of trying to move the database files. On case you, for some reason, don't want to use
the backups, you can try to copy the mdf, ndf and ldf files that constitutes each database and attach them to
the working SQL Server using sp_attach_db.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"TLF" <T_DONOTSPAM_Furness@.simon.com> wrote in message news:uz2pqp5YEHA.1448@.TK2MSFTNGP12.phx.gbl...
> Hello all,
> Last night we had 2 drives die on our test machine. The data (all our
> databases)has been regretably lost. My question is;
> How can I use the Production box and copy all the databases over to the
> newly installed drives? At this point, I am unable to even start the sql
> server service. SQL 7 on NT4 both machines.
> Any advice on how to recover this nightmare would be appreciated.
> Thanks in advance,
> Tom
>
|||Tibor,
Thanks for the fast response, but I think the problem is deeper that that.
I can not even get the instance of SQL server to start. When I try to start
the service I get an NT internal error. Could this be because I lost both
master and msdb databases as well as my user databases? I do have
backups(master,msdb,...), but without having SQL running , I cant restore
them. Any other suggestions?
Thanks for your time.
Tom
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uEzBcW6YEHA.3128@.TK2MSFTNGP09.phx.gbl...
> Tom,
> Use your backups instead of trying to move the database files. On case
you, for some reason, don't want to use
> the backups, you can try to copy the mdf, ndf and ldf files that
constitutes each database and attach them to
> the working SQL Server using sp_attach_db.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "TLF" <T_DONOTSPAM_Furness@.simon.com> wrote in message
news:uz2pqp5YEHA.1448@.TK2MSFTNGP12.phx.gbl...
>
|||Check out the SQL Server errorlog.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"TLF" <T_DONOTSPAM_Furness@.simon.com> wrote in message news:ui%23Zs4FZEHA.2388@.TK2MSFTNGP09.phx.gbl...
> Tibor,
> Thanks for the fast response, but I think the problem is deeper that that.
> I can not even get the instance of SQL server to start. When I try to start
> the service I get an NT internal error. Could this be because I lost both
> master and msdb databases as well as my user databases? I do have
> backups(master,msdb,...), but without having SQL running , I cant restore
> them. Any other suggestions?
> Thanks for your time.
> Tom
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:uEzBcW6YEHA.3128@.TK2MSFTNGP09.phx.gbl...
> you, for some reason, don't want to use
> constitutes each database and attach them to
> news:uz2pqp5YEHA.1448@.TK2MSFTNGP12.phx.gbl...
>