HELP HELP!..............................

Hi All,
I'm trying to move the master database data and log files
to the new location. I did follow the following
instruction with no luck. I can NOT start SQLServices I
make the changes. Please help me to fix this or pointing
me to the right direction on how to fix this.
1. Remove the current entries for the Master.mdf and
Mastlog.ldf files.
2. Add new entries specifying the new location:
-dE:\SQLDATA\master.mdf
-lE:\SQLDATA\mastlog.ldf
3. Stop SQL Server.
4. Copy the Master.mdf and Mastlog.ldf files to the new
location (E:\Sqldata).
5. Restart SQL Server.
tomHi Tom,
I tried the steps directed by you, and guess what, I was able to restart
the SQL Services on my machine.
IMPORTANT: This article contains information about editing the registry.
Before you edit the registry, you should first make a backup copy of the
registry files (System.dat and User.dat). Both are hidden files in the
Windows folder.
WARNING: Using Registry Editor incorrectly can cause serious problems that
may require you to reinstall Operating System. Microsoft cannot guarantee
that problems resulting from the incorrect use of Registry Editor can be
solved. Use Registry Editor at your own risk.
Anyways, you can find the entry related to the SQL Server Parameters in the
registry at the following location
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\Parameters
Please verify the value of the parameters, for any misspells.
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.|||The best way to do this is to use the enterprise manager. Detach the
database, move the files and attach. (VERY simple)
"tuand2001@.yahoo.com" <anonymous@.discussions.microsoft.com> schreef in
bericht news:1b7e701c420cf$3e076e50$a501280a@.phx.gbl...
> Hi All,
> I'm trying to move the master database data and log files
> to the new location. I did follow the following
> instruction with no luck. I can NOT start SQLServices I
> make the changes. Please help me to fix this or pointing
> me to the right direction on how to fix this.
>
> 1. Remove the current entries for the Master.mdf and
> Mastlog.ldf files.
> 2. Add new entries specifying the new location:
> -dE:\SQLDATA\master.mdf
> -lE:\SQLDATA\mastlog.ldf
> 3. Stop SQL Server.
> 4. Copy the Master.mdf and Mastlog.ldf files to the new
> location (E:\Sqldata).
> 5. Restart SQL Server.
> tom|||Hi,
I am sorry but the Master Database, being a System Database, cannot be
detached when the SQL Server Service is running.
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.