SQL Server 2000 service not running in local machine

[Bob]

Hi all,

After merged two partitions into one (C:\ and D:\ into one C:\) by
using Partition Magic, I can't start SQL Server 2000 which was
previously installed in both C:\Program Files\Microsoft SQL Server\80
and D:\Program Files\Microsoft SQL Server\MSSQL

The original files in D:\ (every thing in D:\ actually) are now copyed
in C:\Data folder.

Other than re-install SQL Server in C:\, is it possible to restore
data(files) from D:\Data ?

Mank thanks to any suggestions/hints.

Kind Regards,

Bob

[Greg D. Moore \(Strider\)]

"Bob" <au********@hotmail.com> wrote in message
news:b0**************************@posting.google.c om...

Hi all,

After merged two partitions into one (C:\ and D:\ into one C:\) by
using Partition Magic, I can't start SQL Server 2000 which was
previously installed in both C:\Program Files\Microsoft SQL Server\80
and D:\Program Files\Microsoft SQL Server\MSSQL

The original files in D:\ (every thing in D:\ actually) are now copyed
in C:\Data folder.

Other than re-install SQL Server in C:\, is it possible to restore
data(files) from D:\Data ?
You'll have to reinstall SQL Server to make sure your registry is right.

As for the data, as long as you don't overwrite the files (so back them up
first!!!) sp_attach_db is your friend.


Mank thanks to any suggestions/hints.

Kind Regards,

Bob

[John Bell]

Hi

I have not tried this but try starting SQL Server from the command prompt
and specify the 3608 trace flag on startup and also specify the new master
database locations with the -d -l and the error log with -e.
http://support.microsoft.com/kb/224071/EN-US/

John

"Bob" <au********@hotmail.com> wrote in message
news:b0**************************@posting.google.c om...

Hi all,

After merged two partitions into one (C:\ and D:\ into one C:\) by
using Partition Magic, I can't start SQL Server 2000 which was
previously installed in both C:\Program Files\Microsoft SQL Server\80
and D:\Program Files\Microsoft SQL Server\MSSQL

The original files in D:\ (every thing in D:\ actually) are now copyed
in C:\Data folder.

Other than re-install SQL Server in C:\, is it possible to restore
data(files) from D:\Data ?

Mank thanks to any suggestions/hints.

Kind Regards,

Bob

[ausgoodman]

John Bell wrote:

Hi

I have not tried this but try starting SQL Server from the command prompt and specify the 3608 trace flag on startup and also specify the new master database locations with the -d -l and the error log with -e.
http://support.microsoft.com/kb/224071/EN-US/

John

"Bob" <au********@hotmail.com> wrote in message
news:b0**************************@posting.google.c om...

Hi all,

After merged two partitions into one (C:\ and D:\ into one C:\) by
using Partition Magic, I can't start SQL Server 2000 which was
previously installed in both C:\Program Files\Microsoft SQL Server\80 and D:\Program Files\Microsoft SQL Server\MSSQL

The original files in D:\ (every thing in D:\ actually) are now copyed in C:\Data folder.

Other than re-install SQL Server in C:\, is it possible to restore
data(files) from D:\Data ?

Mank thanks to any suggestions/hints.

Kind Regards,

Bob