Re: Host Operating System Disaster
- From: Sue Hoegemeier <Sue_H@xxxxxxxxxxxxx>
- Date: Mon, 07 Aug 2006 13:53:39 -0600
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.
.
- Follow-Ups:
- Re: Host Operating System Disaster
- From: Robert Black
- Re: Host Operating System Disaster
- References:
- Host Operating System Disaster
- From: Robert Black
- Host Operating System Disaster
- Prev by Date: Re: /3GB switch in 64-bit environment
- Next by Date: Re: /3GB switch in 64-bit environment
- Previous by thread: Host Operating System Disaster
- Next by thread: Re: Host Operating System Disaster
- Index(es):
Relevant Pages
|
