Data Restore on Elm Street!

[John Tear]

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.

[Allan Mitchell]

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" <jo******@hotmail.com> wrote in message
news:92**************************@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.

[John Tear]

Hi Allan

Thanks for your reply. I got this sorted, basically I took the data
files and transfered them accross to the new server then I attached
them in the management console for MS SQL. Pretty lucky I think!

I have advised that a backup solution is the VERY next step!!!

John T.

"Allan Mitchell" <al***@no-spam.sqldts.com> wrote in message news:<40***********************@lovejoy.zen.co.uk> ...

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" <jo******@hotmail.com> wrote in message
news:92**************************@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.

[John Tear]

Hi Allan

Thanks for your reply. I got this sorted, basically I took the data
files and transfered them accross to the new server then I attached
them in the management console for MS SQL. Pretty lucky I think!

I have advised that a backup solution is the VERY next step!!!

John T.

"Allan Mitchell" <al***@no-spam.sqldts.com> wrote in message news:<40***********************@lovejoy.zen.co.uk> ...

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" <jo******@hotmail.com> wrote in message
news:92**************************@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.