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

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,
TomTom,
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.ph
x.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 star
t
> 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 i
n
> 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...
>

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

Recover database with multiple filegroups?

Hi,
I'm running SQL2000 Standard on W2K Server.
I have a large database that spreads multiple physical drives and file
groups. The database failed earlier today because one of the filegroups is
bad. This filegroup is located on a bad drive and the database is now in
(suspect) mode, complaining about torn page I/O error.
I'm wondering if it's possible to DELETE this one filegroup from the
database and bring the database back online with other remaining filegroups.
Because this filegroup is bad and is causing the entire database to be in
Suspect Mode. Or is it possible to re-create a new database by attaching all
good filegroups back?
What are my options for bringing this database back online without having to
trash all the data and reload them? It'd be nice if I only lose this one
filegroup.
Thanks!
HHHi
If I understood you correctly you need to use DBCC SHRINKFILE with EMPTYFILE
argument.
For more details please refer to BOL.
"Hung Huynh" <hungh@.wi.rr.com> wrote in message
news:er8g2TSjDHA.360@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I'm running SQL2000 Standard on W2K Server.
> I have a large database that spreads multiple physical drives and file
> groups. The database failed earlier today because one of the filegroups is
> bad. This filegroup is located on a bad drive and the database is now in
> (suspect) mode, complaining about torn page I/O error.
> I'm wondering if it's possible to DELETE this one filegroup from the
> database and bring the database back online with other remaining
filegroups.
> Because this filegroup is bad and is causing the entire database to be in
> Suspect Mode. Or is it possible to re-create a new database by attaching
all
> good filegroups back?
> What are my options for bringing this database back online without having
to
> trash all the data and reload them? It'd be nice if I only lose this one
> filegroup.
> Thanks!
> HH
>|||No. The database is not functional right now. It's in Suspect Mode and need
to be restored/recovered.
Thanks!
HH
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ufLhsQWjDHA.2652@.TK2MSFTNGP09.phx.gbl...
> Hi
> If I understood you correctly you need to use DBCC SHRINKFILE with
EMPTYFILE
> argument.
> For more details please refer to BOL.
>
>
> "Hung Huynh" <hungh@.wi.rr.com> wrote in message
> news:er8g2TSjDHA.360@.TK2MSFTNGP10.phx.gbl...
> > Hi,
> >
> > I'm running SQL2000 Standard on W2K Server.
> >
> > I have a large database that spreads multiple physical drives and file
> > groups. The database failed earlier today because one of the filegroups
is
> > bad. This filegroup is located on a bad drive and the database is now in
> > (suspect) mode, complaining about torn page I/O error.
> >
> > I'm wondering if it's possible to DELETE this one filegroup from the
> > database and bring the database back online with other remaining
> filegroups.
> > Because this filegroup is bad and is causing the entire database to be
in
> > Suspect Mode. Or is it possible to re-create a new database by attaching
> all
> > good filegroups back?
> >
> > What are my options for bringing this database back online without
having
> to
> > trash all the data and reload them? It'd be nice if I only lose this one
> > filegroup.
> >
> > Thanks!
> >
> > HH
> >
> >
>