Re: Host Operating System Disaster

Glad it worked - thanks for posting back.

-Sue

On Mon, 7 Aug 2006 15:17:03 -0700, "Robert Black"
<someone@xxxxxxxxxxxxx> wrote:

I was successful in the re-installation/restore of my databases, that was
never a concern to me. The system MSDB database was what I was sweating
about.
I did stop the sql server and file copy the MSDB, brought it back up and
whaalaa! I have my DTS packages and agents!
Now I'm going out for a long needed beer (or two)...

"Sue Hoegemeier" <Sue_H@xxxxxxxxxxxxx> wrote in message
news:i66fd21q0hvqcionoj3ic688v16nj8nve2@xxxxxxxxxx
Without backups, there is no guarantee.
One thing to try is to reinstall SQL Server to the same
original directory location, same service pack levels, same
locations for all data and log files. Stop the SQL Server
services. Then copy (replace the existing ones) all of the
original data and log files from when the drive died to the
location they were at originally before the drives went out.
Basically, it should all be setup just as it was when the
drive went out. Then try starting the services.
If you don't remember how it was configured, you'd need to
try what Arnie suggested. However, even in that case,
sp_attach_db isn't guaranteed to work if you didn't
explicitly detach the database first using sp_detach_db.

-Sue

On Mon, 7 Aug 2006 09:25:41 -0700, "Robert Black"
<someone@xxxxxxxxxxxxx> wrote:

I am without a backup of my MSDB and Master databases. My host operating
system disk failed, my SQL database files all exist on another raid array.
I
have rebuilt the host operating system on this same machine using the same
server name.

How can I go about the re-installation of SQL 2000 with out damaging the
existing disk files? I am most concerned with the system Master and MSDB
databases.

Any help would be appreciated.




.

Relevant Pages
Loading