Data Restore on Elm Street!

Hi all, a bit of a nasty one here!

Ive inherited a server that has just collapsed. It contains SQL Server
and has a fair amount of data on it.

The server would only boot into a BSOD Stop Error. I suspected that
one of the hives in the registry was corrupt so I used the Win2K
Recovery Console to restore the registry to its original settings (So
Windows can not see the SQL stuff now). There is no restore points
from which to take recent registry settings.

My Question is this...

We have a spare server (just lying about you know!!!) which we plan to
install Win2K and MS SQL Server onto... How can I transfer the data,
in a nice easy manner, from the old server to the new server?

Is it possible to move just the data files into the new install?

Remember I inherited this server! (I dont have Backups!!!)
Please... No email's about how important backups are... I know how
important backups are.

Any help/ideas would be appreciated.

Thanks, John T.You can certainly try

Exec sp_attach_db (details in BOL)

There are times when this will only work if you have explicitly used
sp_detach_db (details in BOL)

Failing that and no backups then you may want to give the boys and girls in
PSS a bell.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"John Tear" <johntear@.hotmail.com> wrote in message
news:92ae3244.0404150027.72b19847@.posting.google.c om...
> Hi all, a bit of a nasty one here!
> Ive inherited a server that has just collapsed. It contains SQL Server
> and has a fair amount of data on it.
> The server would only boot into a BSOD Stop Error. I suspected that
> one of the hives in the registry was corrupt so I used the Win2K
> Recovery Console to restore the registry to its original settings (So
> Windows can not see the SQL stuff now). There is no restore points
> from which to take recent registry settings.
> My Question is this...
> We have a spare server (just lying about you know!!!) which we plan to
> install Win2K and MS SQL Server onto... How can I transfer the data,
> in a nice easy manner, from the old server to the new server?
> Is it possible to move just the data files into the new install?
> Remember I inherited this server! (I dont have Backups!!!)
> Please... No email's about how important backups are... I know how
> important backups are.
> Any help/ideas would be appreciated.
> Thanks, John T.