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\MS
SQLServer\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.
Showing posts with label master. Show all posts
Showing posts with label master. Show all posts
Friday, March 30, 2012
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.
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.
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.
tom
Hi 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.
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 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.
Wednesday, March 21, 2012
help button from EM
When open EM -> databases --> master --> tables --> when we right click on
particular table, click on 'help'. it will take us to 'SQL Server Books
Online', but NOT to the table I have question, but point to inform I was
looking for earlier from search bar. How can we solve the problem, so next
time when I right click on any table on 'help', it will take me right to that
particular table information I wanted from 'SQL Server Books Online'?
Hi Renhai,
The help doesn't work like that. It will not display the help for the
system table you are looking for. It displays help for tables because that
is what you have highlighted.
Just enter the system table name in the help index to find help on that
kind regards
Greg O
Need to document your databases. Use the first and still the best AGS SQL
Scribe
http://www.ag-software.com
"renhai" <renhai@.discussions.microsoft.com> wrote in message
news:29C7718D-1F0D-44CC-BEDA-4D3E72D2A26B@.microsoft.com...
> When open EM -> databases --> master --> tables --> when we right click on
> particular table, click on 'help'. it will take us to 'SQL Server Books
> Online', but NOT to the table I have question, but point to inform I was
> looking for earlier from search bar. How can we solve the problem, so next
> time when I right click on any table on 'help', it will take me right to
> that
> particular table information I wanted from 'SQL Server Books Online'?
particular table, click on 'help'. it will take us to 'SQL Server Books
Online', but NOT to the table I have question, but point to inform I was
looking for earlier from search bar. How can we solve the problem, so next
time when I right click on any table on 'help', it will take me right to that
particular table information I wanted from 'SQL Server Books Online'?
Hi Renhai,
The help doesn't work like that. It will not display the help for the
system table you are looking for. It displays help for tables because that
is what you have highlighted.
Just enter the system table name in the help index to find help on that
kind regards
Greg O
Need to document your databases. Use the first and still the best AGS SQL
Scribe
http://www.ag-software.com
"renhai" <renhai@.discussions.microsoft.com> wrote in message
news:29C7718D-1F0D-44CC-BEDA-4D3E72D2A26B@.microsoft.com...
> When open EM -> databases --> master --> tables --> when we right click on
> particular table, click on 'help'. it will take us to 'SQL Server Books
> Online', but NOT to the table I have question, but point to inform I was
> looking for earlier from search bar. How can we solve the problem, so next
> time when I right click on any table on 'help', it will take me right to
> that
> particular table information I wanted from 'SQL Server Books Online'?
help button from EM
When open EM -> databases --> master --> tables --> when we right click on
particular table, click on 'help'. it will take us to 'SQL Server Books
Online', but NOT to the table I have question, but point to inform I was
looking for earlier from search bar. How can we solve the problem, so next
time when I right click on any table on 'help', it will take me right to tha
t
particular table information I wanted from 'SQL Server Books Online'?Hi Renhai,
The help doesn't work like that. It will not display the help for the
system table you are looking for. It displays help for tables because that
is what you have highlighted.
Just enter the system table name in the help index to find help on that
kind regards
Greg O
Need to document your databases. Use the first and still the best AGS SQL
Scribe
http://www.ag-software.com
"renhai" <renhai@.discussions.microsoft.com> wrote in message
news:29C7718D-1F0D-44CC-BEDA-4D3E72D2A26B@.microsoft.com...
> When open EM -> databases --> master --> tables --> when we right click on
> particular table, click on 'help'. it will take us to 'SQL Server Books
> Online', but NOT to the table I have question, but point to inform I was
> looking for earlier from search bar. How can we solve the problem, so next
> time when I right click on any table on 'help', it will take me right to
> that
> particular table information I wanted from 'SQL Server Books Online'?
particular table, click on 'help'. it will take us to 'SQL Server Books
Online', but NOT to the table I have question, but point to inform I was
looking for earlier from search bar. How can we solve the problem, so next
time when I right click on any table on 'help', it will take me right to tha
t
particular table information I wanted from 'SQL Server Books Online'?Hi Renhai,
The help doesn't work like that. It will not display the help for the
system table you are looking for. It displays help for tables because that
is what you have highlighted.
Just enter the system table name in the help index to find help on that
kind regards
Greg O
Need to document your databases. Use the first and still the best AGS SQL
Scribe
http://www.ag-software.com
"renhai" <renhai@.discussions.microsoft.com> wrote in message
news:29C7718D-1F0D-44CC-BEDA-4D3E72D2A26B@.microsoft.com...
> When open EM -> databases --> master --> tables --> when we right click on
> particular table, click on 'help'. it will take us to 'SQL Server Books
> Online', but NOT to the table I have question, but point to inform I was
> looking for earlier from search bar. How can we solve the problem, so next
> time when I right click on any table on 'help', it will take me right to
> that
> particular table information I wanted from 'SQL Server Books Online'?
help button from EM
When open EM -> databases --> master --> tables --> when we right click on
particular table, click on 'help'. it will take us to 'SQL Server Books
Online', but NOT to the table I have question, but point to inform I was
looking for earlier from search bar. How can we solve the problem, so next
time when I right click on any table on 'help', it will take me right to that
particular table information I wanted from 'SQL Server Books Online'?Hi Renhai,
The help doesn't work like that. It will not display the help for the
system table you are looking for. It displays help for tables because that
is what you have highlighted.
Just enter the system table name in the help index to find help on that
kind regards
Greg O
Need to document your databases. Use the first and still the best AGS SQL
Scribe
http://www.ag-software.com
"renhai" <renhai@.discussions.microsoft.com> wrote in message
news:29C7718D-1F0D-44CC-BEDA-4D3E72D2A26B@.microsoft.com...
> When open EM -> databases --> master --> tables --> when we right click on
> particular table, click on 'help'. it will take us to 'SQL Server Books
> Online', but NOT to the table I have question, but point to inform I was
> looking for earlier from search bar. How can we solve the problem, so next
> time when I right click on any table on 'help', it will take me right to
> that
> particular table information I wanted from 'SQL Server Books Online'?
particular table, click on 'help'. it will take us to 'SQL Server Books
Online', but NOT to the table I have question, but point to inform I was
looking for earlier from search bar. How can we solve the problem, so next
time when I right click on any table on 'help', it will take me right to that
particular table information I wanted from 'SQL Server Books Online'?Hi Renhai,
The help doesn't work like that. It will not display the help for the
system table you are looking for. It displays help for tables because that
is what you have highlighted.
Just enter the system table name in the help index to find help on that
kind regards
Greg O
Need to document your databases. Use the first and still the best AGS SQL
Scribe
http://www.ag-software.com
"renhai" <renhai@.discussions.microsoft.com> wrote in message
news:29C7718D-1F0D-44CC-BEDA-4D3E72D2A26B@.microsoft.com...
> When open EM -> databases --> master --> tables --> when we right click on
> particular table, click on 'help'. it will take us to 'SQL Server Books
> Online', but NOT to the table I have question, but point to inform I was
> looking for earlier from search bar. How can we solve the problem, so next
> time when I right click on any table on 'help', it will take me right to
> that
> particular table information I wanted from 'SQL Server Books Online'?
Friday, February 24, 2012
help
Does anyone see anything wrong with this statement
CREATE FUNCTION "All Bally Games" ()
RETURNS TABLE
AS RETURN (SELECT TOP 100 PERCENT "Master List"."Tribal No", "Master List"."Stand No",
"Master List"."Serial No", "Master List".Manufacturers, "Master List".Description, "Master
List".Denomination, "Master List".Class, "Bally Main Eprom"."ID Number A", "Bally Main
Eprom"."ID Number B"
FROM "Master List" INNER JOIN "Bally Main Eprom" ON ("Master List"."Tribal No" = "Bally
Main Eprom"."Tribal No")
WHERE ((("Master List".Manufacturers) Like '5'))Unless you include a percent sign (%), the LIKE clause could just as well be an equal sign. I would much prefer the use of brackets [] over the use of quotes "" if that is acceptable.
That's all that jumps right out at me.
-PatP
CREATE FUNCTION "All Bally Games" ()
RETURNS TABLE
AS RETURN (SELECT TOP 100 PERCENT "Master List"."Tribal No", "Master List"."Stand No",
"Master List"."Serial No", "Master List".Manufacturers, "Master List".Description, "Master
List".Denomination, "Master List".Class, "Bally Main Eprom"."ID Number A", "Bally Main
Eprom"."ID Number B"
FROM "Master List" INNER JOIN "Bally Main Eprom" ON ("Master List"."Tribal No" = "Bally
Main Eprom"."Tribal No")
WHERE ((("Master List".Manufacturers) Like '5'))Unless you include a percent sign (%), the LIKE clause could just as well be an equal sign. I would much prefer the use of brackets [] over the use of quotes "" if that is acceptable.
That's all that jumps right out at me.
-PatP
Subscribe to:
Posts (Atom)