By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,419 Members | 1,584 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,419 IT Pros & Developers. It's quick & easy.

SQL Server 2000 service not running in local machine

P: n/a
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
Jul 23 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a

"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

Jul 23 '05 #2

P: n/a
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

Jul 23 '05 #3

P: n/a

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


Jul 23 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.