What should one consider when moving SQL Servers to a backened SAN ?
Hi
You will need to consider most of the normal things as you would moving to
any new hardware!
Some SAN specific requirements would cover LUN/Disc configuration/layout,
SAN replication requirements, LUN alignment. You would need to talk these
over with the SAN engineer/architect.
You may want to look at http://support.microsoft.com/kb/254321/
Your SAN vendor should also have some whitepapers specific to running SQL
Server on their hardware.
John
"Hassan" wrote:
> What should one consider when moving SQL Servers to a backened SAN ?
>
>
|||Simplest approach is to treat it just like another hard drive, and make sure
you understand its performance.
A step further and depending on how much you can get from your SAN folks,
you can go over the same RAID config issues and the file layout exercise as
you would with a convenitonal RAID set.
Linchi
"Hassan" wrote:
> What should one consider when moving SQL Servers to a backened SAN ?
>
>
sql
Showing posts with label san. Show all posts
Showing posts with label san. Show all posts
Wednesday, March 28, 2012
Moving to a SAN
What should one consider when moving SQL Servers to a backened SAN ?Hi
You will need to consider most of the normal things as you would moving to
any new hardware!
Some SAN specific requirements would cover LUN/Disc configuration/layout,
SAN replication requirements, LUN alignment. You would need to talk these
over with the SAN engineer/architect.
You may want to look at http://support.microsoft.com/kb/254321/
Your SAN vendor should also have some whitepapers specific to running SQL
Server on their hardware.
John
"Hassan" wrote:
> What should one consider when moving SQL Servers to a backened SAN ?
>
>|||Simplest approach is to treat it just like another hard drive, and make sure
you understand its performance.
A step further and depending on how much you can get from your SAN folks,
you can go over the same RAID config issues and the file layout exercise as
you would with a convenitonal RAID set.
Linchi
"Hassan" wrote:
> What should one consider when moving SQL Servers to a backened SAN ?
>
>
You will need to consider most of the normal things as you would moving to
any new hardware!
Some SAN specific requirements would cover LUN/Disc configuration/layout,
SAN replication requirements, LUN alignment. You would need to talk these
over with the SAN engineer/architect.
You may want to look at http://support.microsoft.com/kb/254321/
Your SAN vendor should also have some whitepapers specific to running SQL
Server on their hardware.
John
"Hassan" wrote:
> What should one consider when moving SQL Servers to a backened SAN ?
>
>|||Simplest approach is to treat it just like another hard drive, and make sure
you understand its performance.
A step further and depending on how much you can get from your SAN folks,
you can go over the same RAID config issues and the file layout exercise as
you would with a convenitonal RAID set.
Linchi
"Hassan" wrote:
> What should one consider when moving SQL Servers to a backened SAN ?
>
>
Moving to a SAN
What should one consider when moving SQL Servers to a backened SAN ?Hi
You will need to consider most of the normal things as you would moving to
any new hardware!
Some SAN specific requirements would cover LUN/Disc configuration/layout,
SAN replication requirements, LUN alignment. You would need to talk these
over with the SAN engineer/architect.
You may want to look at http://support.microsoft.com/kb/254321/
Your SAN vendor should also have some whitepapers specific to running SQL
Server on their hardware.
John
"Hassan" wrote:
> What should one consider when moving SQL Servers to a backened SAN ?
>
>|||Simplest approach is to treat it just like another hard drive, and make sure
you understand its performance.
A step further and depending on how much you can get from your SAN folks,
you can go over the same RAID config issues and the file layout exercise as
you would with a convenitonal RAID set.
Linchi
"Hassan" wrote:
> What should one consider when moving SQL Servers to a backened SAN ?
>
>
You will need to consider most of the normal things as you would moving to
any new hardware!
Some SAN specific requirements would cover LUN/Disc configuration/layout,
SAN replication requirements, LUN alignment. You would need to talk these
over with the SAN engineer/architect.
You may want to look at http://support.microsoft.com/kb/254321/
Your SAN vendor should also have some whitepapers specific to running SQL
Server on their hardware.
John
"Hassan" wrote:
> What should one consider when moving SQL Servers to a backened SAN ?
>
>|||Simplest approach is to treat it just like another hard drive, and make sure
you understand its performance.
A step further and depending on how much you can get from your SAN folks,
you can go over the same RAID config issues and the file layout exercise as
you would with a convenitonal RAID set.
Linchi
"Hassan" wrote:
> What should one consider when moving SQL Servers to a backened SAN ?
>
>
Monday, March 26, 2012
Moving to a new SAN
I have a established cluster that I have to move to
another SAN. Any words of wisdom?
Test, test, test. How are performing the move.
Good luck
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"cgunner" <anonymous@.discussions.microsoft.com> wrote in message
news:02d501c4abd3$ecd50890$a301280a@.phx.gbl...
>I have a established cluster that I have to move to
> another SAN. Any words of wisdom?
|||We are going to go by Q269196 but this does not address
the new LUN's that will have to be setup on the new SAN.
I am mostly concerned with the QUORUM drive. I want to
try to keep the cluster in one piece. Do you know any
other KB's to take into account?
>--Original Message--
>Test, test, test. How are performing the move.
>Good luck
>Cheers,
>Rod
>MVP - Windows Server - Clustering
>http://www.nw-america.com - Clustering
>http://msmvps.com/clustering - Blog
>"cgunner" <anonymous@.discussions.microsoft.com> wrote in
message
>news:02d501c4abd3$ecd50890$a301280a@.phx.gbl...
>
>.
>
|||Sure see
http://www.microsoft.com/resources/d...luad_pr_69.asp
to move the Quorum.
Or do it this way http://support.microsoft.com/?id=280353
Or start all over again - http://support.microsoft.com/?id=245762
More on the quorum http://support.microsoft.com/?id=280345
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"cgunner" <anonymous@.discussions.microsoft.com> wrote in message
news:0d6101c4ac8f$a8f53700$a301280a@.phx.gbl...[vbcol=seagreen]
> We are going to go by Q269196 but this does not address
> the new LUN's that will have to be setup on the new SAN.
> I am mostly concerned with the QUORUM drive. I want to
> try to keep the cluster in one piece. Do you know any
> other KB's to take into account?
> message
|||We just did this on an active / active cluster. If you are using EMC SAn,
they have tools to migrate everything, and to make sure the luns are the
same, and properly assigned to your hosts. You can alos get the data
mirrored, and in sync long before you actually cut over to the new SAN. Our
migration went very smoothly.
"Rodney R. Fournier [MVP]" wrote:
> Sure see
> http://www.microsoft.com/resources/d...luad_pr_69.asp
> to move the Quorum.
> Or do it this way http://support.microsoft.com/?id=280353
> Or start all over again - http://support.microsoft.com/?id=245762
> More on the quorum http://support.microsoft.com/?id=280345
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://msmvps.com/clustering - Blog
> "cgunner" <anonymous@.discussions.microsoft.com> wrote in message
> news:0d6101c4ac8f$a8f53700$a301280a@.phx.gbl...
>
>
sql
another SAN. Any words of wisdom?
Test, test, test. How are performing the move.
Good luck
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"cgunner" <anonymous@.discussions.microsoft.com> wrote in message
news:02d501c4abd3$ecd50890$a301280a@.phx.gbl...
>I have a established cluster that I have to move to
> another SAN. Any words of wisdom?
|||We are going to go by Q269196 but this does not address
the new LUN's that will have to be setup on the new SAN.
I am mostly concerned with the QUORUM drive. I want to
try to keep the cluster in one piece. Do you know any
other KB's to take into account?
>--Original Message--
>Test, test, test. How are performing the move.
>Good luck
>Cheers,
>Rod
>MVP - Windows Server - Clustering
>http://www.nw-america.com - Clustering
>http://msmvps.com/clustering - Blog
>"cgunner" <anonymous@.discussions.microsoft.com> wrote in
message
>news:02d501c4abd3$ecd50890$a301280a@.phx.gbl...
>
>.
>
|||Sure see
http://www.microsoft.com/resources/d...luad_pr_69.asp
to move the Quorum.
Or do it this way http://support.microsoft.com/?id=280353
Or start all over again - http://support.microsoft.com/?id=245762
More on the quorum http://support.microsoft.com/?id=280345
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"cgunner" <anonymous@.discussions.microsoft.com> wrote in message
news:0d6101c4ac8f$a8f53700$a301280a@.phx.gbl...[vbcol=seagreen]
> We are going to go by Q269196 but this does not address
> the new LUN's that will have to be setup on the new SAN.
> I am mostly concerned with the QUORUM drive. I want to
> try to keep the cluster in one piece. Do you know any
> other KB's to take into account?
> message
|||We just did this on an active / active cluster. If you are using EMC SAn,
they have tools to migrate everything, and to make sure the luns are the
same, and properly assigned to your hosts. You can alos get the data
mirrored, and in sync long before you actually cut over to the new SAN. Our
migration went very smoothly.
"Rodney R. Fournier [MVP]" wrote:
> Sure see
> http://www.microsoft.com/resources/d...luad_pr_69.asp
> to move the Quorum.
> Or do it this way http://support.microsoft.com/?id=280353
> Or start all over again - http://support.microsoft.com/?id=245762
> More on the quorum http://support.microsoft.com/?id=280345
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://msmvps.com/clustering - Blog
> "cgunner" <anonymous@.discussions.microsoft.com> wrote in message
> news:0d6101c4ac8f$a8f53700$a301280a@.phx.gbl...
>
>
sql
Friday, March 23, 2012
moving system databases
Hi all.
Long story, I have a clustered SQL Server 2005 Standard Edition that is
using a SAN. We have just added more drives to our SAN and I need to move
the system database off the current drive to another drive. I have read some
others that have too have asked the same question. And Article ID 224071
keeps coming up. Well I just tried following this article this morning on my
beta server (SQL 2005 Dev Edition) to ensure things would go smoothly on
production and after I tried changing the startup parameters and tried
starting SQL server instance backup I received the following error.
FCB::Open: Operating system error 2(The system cannot find the file
specified.) occurred while creating or opening file 'F:\Program
Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf -c -m -T3608'.
Diagnose and correct the operating system error, and retry the operation.
And after a Google search I ran across an article out on MSDN, saying that
you need to use a ';' in between the parameters.
http://msdn2.microsoft.com/en-us/library/ms190699.aspx
I had to use SQL Server Configuration Manager to change the startup
parameters because there was no 'startup parameters' under the general tab
under Enterprise Manager (I had 2 other people check the steps out too and
they couldn't find it either).
Did I do something wrong? Should there be ';' between the parameters or not?
Thanks in advance!
Kris
If it helps, my SQL 2005 startup parameters from teh Config manager:
-dC:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lC:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
Or check in the registry:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.1\MSSQLServer\Parameters
Kevin Hill
IC3 North Texas
www.ChristianCycling.com
Please support me in the 2008 MS150:
http://www.ms150.org/dallas/donate/donate.cfm?id=208000
"Kris McCarty" <Kris McCarty@.discussions.microsoft.com> wrote in message
news:AE19C53B-7F0E-4A33-AF14-85748AAF7559@.microsoft.com...
> Hi all.
> Long story, I have a clustered SQL Server 2005 Standard Edition that is
> using a SAN. We have just added more drives to our SAN and I need to move
> the system database off the current drive to another drive. I have read
> some
> others that have too have asked the same question. And Article ID 224071
> keeps coming up. Well I just tried following this article this morning on
> my
> beta server (SQL 2005 Dev Edition) to ensure things would go smoothly on
> production and after I tried changing the startup parameters and tried
> starting SQL server instance backup I received the following error.
> FCB::Open: Operating system error 2(The system cannot find the file
> specified.) occurred while creating or opening file 'F:\Program
> Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf -c -m -T3608'.
> Diagnose and correct the operating system error, and retry the operation.
> And after a Google search I ran across an article out on MSDN, saying that
> you need to use a ';' in between the parameters.
> http://msdn2.microsoft.com/en-us/library/ms190699.aspx
> I had to use SQL Server Configuration Manager to change the startup
> parameters because there was no 'startup parameters' under the general tab
> under Enterprise Manager (I had 2 other people check the steps out too and
> they couldn't find it either).
> Did I do something wrong? Should there be ';' between the parameters or
> not?
> Thanks in advance!
> Kris
>
|||OK by adding in the ';' between the parameters via Config Manager I am now
getting the following message when I try to connect to the server after I
restart the instance backup.
Cannot connect to 'servername'
Login failed for user 'sa'. Reason: Server is in single user mode. Only
one administrator can connect at this time. (Microsoft SQL Server, Error:
18461)
I even went to the length to unplugg the network cable and restart with
server off the network and I still received the same error. Only database I
was moving at the time was 'Model' using the procedures of Article ID 224071.
Doing another search I found a tech net artilce telling of another want to
move all system databases other then master and resources
http://technet.microsoft.com/en-us/library/ms345408.aspx
, which is different then 224071. Any ideas and help is great!
Thanks again!
Kris
"Tibor Karaszi" wrote:
> It depend son what tool you are using. In Config Manager: Yes.
> In RegEdit: No, since each parameter has it's own key.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Kris McCarty" <Kris McCarty@.discussions.microsoft.com> wrote in message
> news:AE19C53B-7F0E-4A33-AF14-85748AAF7559@.microsoft.com...
>
Long story, I have a clustered SQL Server 2005 Standard Edition that is
using a SAN. We have just added more drives to our SAN and I need to move
the system database off the current drive to another drive. I have read some
others that have too have asked the same question. And Article ID 224071
keeps coming up. Well I just tried following this article this morning on my
beta server (SQL 2005 Dev Edition) to ensure things would go smoothly on
production and after I tried changing the startup parameters and tried
starting SQL server instance backup I received the following error.
FCB::Open: Operating system error 2(The system cannot find the file
specified.) occurred while creating or opening file 'F:\Program
Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf -c -m -T3608'.
Diagnose and correct the operating system error, and retry the operation.
And after a Google search I ran across an article out on MSDN, saying that
you need to use a ';' in between the parameters.
http://msdn2.microsoft.com/en-us/library/ms190699.aspx
I had to use SQL Server Configuration Manager to change the startup
parameters because there was no 'startup parameters' under the general tab
under Enterprise Manager (I had 2 other people check the steps out too and
they couldn't find it either).
Did I do something wrong? Should there be ';' between the parameters or not?
Thanks in advance!
Kris
If it helps, my SQL 2005 startup parameters from teh Config manager:
-dC:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lC:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
Or check in the registry:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.1\MSSQLServer\Parameters
Kevin Hill
IC3 North Texas
www.ChristianCycling.com
Please support me in the 2008 MS150:
http://www.ms150.org/dallas/donate/donate.cfm?id=208000
"Kris McCarty" <Kris McCarty@.discussions.microsoft.com> wrote in message
news:AE19C53B-7F0E-4A33-AF14-85748AAF7559@.microsoft.com...
> Hi all.
> Long story, I have a clustered SQL Server 2005 Standard Edition that is
> using a SAN. We have just added more drives to our SAN and I need to move
> the system database off the current drive to another drive. I have read
> some
> others that have too have asked the same question. And Article ID 224071
> keeps coming up. Well I just tried following this article this morning on
> my
> beta server (SQL 2005 Dev Edition) to ensure things would go smoothly on
> production and after I tried changing the startup parameters and tried
> starting SQL server instance backup I received the following error.
> FCB::Open: Operating system error 2(The system cannot find the file
> specified.) occurred while creating or opening file 'F:\Program
> Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf -c -m -T3608'.
> Diagnose and correct the operating system error, and retry the operation.
> And after a Google search I ran across an article out on MSDN, saying that
> you need to use a ';' in between the parameters.
> http://msdn2.microsoft.com/en-us/library/ms190699.aspx
> I had to use SQL Server Configuration Manager to change the startup
> parameters because there was no 'startup parameters' under the general tab
> under Enterprise Manager (I had 2 other people check the steps out too and
> they couldn't find it either).
> Did I do something wrong? Should there be ';' between the parameters or
> not?
> Thanks in advance!
> Kris
>
|||OK by adding in the ';' between the parameters via Config Manager I am now
getting the following message when I try to connect to the server after I
restart the instance backup.
Cannot connect to 'servername'
Login failed for user 'sa'. Reason: Server is in single user mode. Only
one administrator can connect at this time. (Microsoft SQL Server, Error:
18461)
I even went to the length to unplugg the network cable and restart with
server off the network and I still received the same error. Only database I
was moving at the time was 'Model' using the procedures of Article ID 224071.
Doing another search I found a tech net artilce telling of another want to
move all system databases other then master and resources
http://technet.microsoft.com/en-us/library/ms345408.aspx
, which is different then 224071. Any ideas and help is great!
Thanks again!
Kris
"Tibor Karaszi" wrote:
> It depend son what tool you are using. In Config Manager: Yes.
> In RegEdit: No, since each parameter has it's own key.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Kris McCarty" <Kris McCarty@.discussions.microsoft.com> wrote in message
> news:AE19C53B-7F0E-4A33-AF14-85748AAF7559@.microsoft.com...
>
moving system databases
Hi all.
Long story, I have a clustered SQL Server 2005 Standard Edition that is
using a SAN. We have just added more drives to our SAN and I need to move
the system database off the current drive to another drive. I have read som
e
others that have too have asked the same question. And Article ID 224071
keeps coming up. Well I just tried following this article this morning on m
y
beta server (SQL 2005 Dev Edition) to ensure things would go smoothly on
production and after I tried changing the startup parameters and tried
starting SQL server instance backup I received the following error.
FCB::Open: Operating system error 2(The system cannot find the file
specified.) occurred while creating or opening file 'F:\Program
Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf -c -m -T3608'.
Diagnose and correct the operating system error, and retry the operation.
And after a Google search I ran across an article out on MSDN, saying that
you need to use a ';' in between the parameters.
http://msdn2.microsoft.com/en-us/library/ms190699.aspx
I had to use SQL Server Configuration Manager to change the startup
parameters because there was no 'startup parameters' under the general tab
under Enterprise Manager (I had 2 other people check the steps out too and
they couldn't find it either).
Did I do something wrong? Should there be ';' between the parameters or not
?
Thanks in advance!
KrisIf it helps, my SQL 2005 startup parameters from teh Config manager:
-dC:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lC:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
Or check in the registry:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL
Server\MSSQL.1\MSSQLServer\Parameters
Kevin Hill
IC3 North Texas
www.ChristianCycling.com
Please support me in the 2008 MS150:
http://www.ms150.org/dallas/donate/donate.cfm?id=208000
"Kris McCarty" <Kris McCarty@.discussions.microsoft.com> wrote in message
news:AE19C53B-7F0E-4A33-AF14-85748AAF7559@.microsoft.com...
> Hi all.
> Long story, I have a clustered SQL Server 2005 Standard Edition that is
> using a SAN. We have just added more drives to our SAN and I need to move
> the system database off the current drive to another drive. I have read
> some
> others that have too have asked the same question. And Article ID 224071
> keeps coming up. Well I just tried following this article this morning on
> my
> beta server (SQL 2005 Dev Edition) to ensure things would go smoothly on
> production and after I tried changing the startup parameters and tried
> starting SQL server instance backup I received the following error.
> FCB::Open: Operating system error 2(The system cannot find the file
> specified.) occurred while creating or opening file 'F:\Program
> Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf -c -m -T3608'.
> Diagnose and correct the operating system error, and retry the operation.
> And after a Google search I ran across an article out on MSDN, saying that
> you need to use a ';' in between the parameters.
> http://msdn2.microsoft.com/en-us/library/ms190699.aspx
> I had to use SQL Server Configuration Manager to change the startup
> parameters because there was no 'startup parameters' under the general tab
> under Enterprise Manager (I had 2 other people check the steps out too and
> they couldn't find it either).
> Did I do something wrong? Should there be ';' between the parameters or
> not?
> Thanks in advance!
> Kris
>|||> Should there be ';' between the parameters or not?
It depend son what tool you are using. In Config Manager: Yes.
In RegEdit: No, since each parameter has it's own key.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Kris McCarty" <Kris McCarty@.discussions.microsoft.com> wrote in message
news:AE19C53B-7F0E-4A33-AF14-85748AAF7559@.microsoft.com...
> Hi all.
> Long story, I have a clustered SQL Server 2005 Standard Edition that is
> using a SAN. We have just added more drives to our SAN and I need to move
> the system database off the current drive to another drive. I have read s
ome
> others that have too have asked the same question. And Article ID 224071
> keeps coming up. Well I just tried following this article this morning on
my
> beta server (SQL 2005 Dev Edition) to ensure things would go smoothly on
> production and after I tried changing the startup parameters and tried
> starting SQL server instance backup I received the following error.
> FCB::Open: Operating system error 2(The system cannot find the file
> specified.) occurred while creating or opening file 'F:\Program
> Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf -c -m -T3608'.
> Diagnose and correct the operating system error, and retry the operation.
> And after a Google search I ran across an article out on MSDN, saying that
> you need to use a ';' in between the parameters.
> http://msdn2.microsoft.com/en-us/library/ms190699.aspx
> I had to use SQL Server Configuration Manager to change the startup
> parameters because there was no 'startup parameters' under the general tab
> under Enterprise Manager (I had 2 other people check the steps out too and
> they couldn't find it either).
> Did I do something wrong? Should there be ';' between the parameters or n
ot?
> Thanks in advance!
> Kris
>|||OK by adding in the ';' between the parameters via Config Manager I am now
getting the following message when I try to connect to the server after I
restart the instance backup.
Cannot connect to 'servername'
Login failed for user 'sa'. Reason: Server is in single user mode. Only
one administrator can connect at this time. (Microsoft SQL Server, Error:
18461)
I even went to the length to unplugg the network cable and restart with
server off the network and I still received the same error. Only database I
was moving at the time was 'Model' using the procedures of Article ID 224071
.
Doing another search I found a tech net artilce telling of another want to
move all system databases other then master and resources
http://technet.microsoft.com/en-us/...y/ms345408.aspx
, which is different then 224071. Any ideas and help is great!
Thanks again!
Kris
"Tibor Karaszi" wrote:
> It depend son what tool you are using. In Config Manager: Yes.
> In RegEdit: No, since each parameter has it's own key.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Kris McCarty" <Kris McCarty@.discussions.microsoft.com> wrote in message
> news:AE19C53B-7F0E-4A33-AF14-85748AAF7559@.microsoft.com...
>
Long story, I have a clustered SQL Server 2005 Standard Edition that is
using a SAN. We have just added more drives to our SAN and I need to move
the system database off the current drive to another drive. I have read som
e
others that have too have asked the same question. And Article ID 224071
keeps coming up. Well I just tried following this article this morning on m
y
beta server (SQL 2005 Dev Edition) to ensure things would go smoothly on
production and after I tried changing the startup parameters and tried
starting SQL server instance backup I received the following error.
FCB::Open: Operating system error 2(The system cannot find the file
specified.) occurred while creating or opening file 'F:\Program
Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf -c -m -T3608'.
Diagnose and correct the operating system error, and retry the operation.
And after a Google search I ran across an article out on MSDN, saying that
you need to use a ';' in between the parameters.
http://msdn2.microsoft.com/en-us/library/ms190699.aspx
I had to use SQL Server Configuration Manager to change the startup
parameters because there was no 'startup parameters' under the general tab
under Enterprise Manager (I had 2 other people check the steps out too and
they couldn't find it either).
Did I do something wrong? Should there be ';' between the parameters or not
?
Thanks in advance!
KrisIf it helps, my SQL 2005 startup parameters from teh Config manager:
-dC:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lC:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
Or check in the registry:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL
Server\MSSQL.1\MSSQLServer\Parameters
Kevin Hill
IC3 North Texas
www.ChristianCycling.com
Please support me in the 2008 MS150:
http://www.ms150.org/dallas/donate/donate.cfm?id=208000
"Kris McCarty" <Kris McCarty@.discussions.microsoft.com> wrote in message
news:AE19C53B-7F0E-4A33-AF14-85748AAF7559@.microsoft.com...
> Hi all.
> Long story, I have a clustered SQL Server 2005 Standard Edition that is
> using a SAN. We have just added more drives to our SAN and I need to move
> the system database off the current drive to another drive. I have read
> some
> others that have too have asked the same question. And Article ID 224071
> keeps coming up. Well I just tried following this article this morning on
> my
> beta server (SQL 2005 Dev Edition) to ensure things would go smoothly on
> production and after I tried changing the startup parameters and tried
> starting SQL server instance backup I received the following error.
> FCB::Open: Operating system error 2(The system cannot find the file
> specified.) occurred while creating or opening file 'F:\Program
> Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf -c -m -T3608'.
> Diagnose and correct the operating system error, and retry the operation.
> And after a Google search I ran across an article out on MSDN, saying that
> you need to use a ';' in between the parameters.
> http://msdn2.microsoft.com/en-us/library/ms190699.aspx
> I had to use SQL Server Configuration Manager to change the startup
> parameters because there was no 'startup parameters' under the general tab
> under Enterprise Manager (I had 2 other people check the steps out too and
> they couldn't find it either).
> Did I do something wrong? Should there be ';' between the parameters or
> not?
> Thanks in advance!
> Kris
>|||> Should there be ';' between the parameters or not?
It depend son what tool you are using. In Config Manager: Yes.
In RegEdit: No, since each parameter has it's own key.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Kris McCarty" <Kris McCarty@.discussions.microsoft.com> wrote in message
news:AE19C53B-7F0E-4A33-AF14-85748AAF7559@.microsoft.com...
> Hi all.
> Long story, I have a clustered SQL Server 2005 Standard Edition that is
> using a SAN. We have just added more drives to our SAN and I need to move
> the system database off the current drive to another drive. I have read s
ome
> others that have too have asked the same question. And Article ID 224071
> keeps coming up. Well I just tried following this article this morning on
my
> beta server (SQL 2005 Dev Edition) to ensure things would go smoothly on
> production and after I tried changing the startup parameters and tried
> starting SQL server instance backup I received the following error.
> FCB::Open: Operating system error 2(The system cannot find the file
> specified.) occurred while creating or opening file 'F:\Program
> Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf -c -m -T3608'.
> Diagnose and correct the operating system error, and retry the operation.
> And after a Google search I ran across an article out on MSDN, saying that
> you need to use a ';' in between the parameters.
> http://msdn2.microsoft.com/en-us/library/ms190699.aspx
> I had to use SQL Server Configuration Manager to change the startup
> parameters because there was no 'startup parameters' under the general tab
> under Enterprise Manager (I had 2 other people check the steps out too and
> they couldn't find it either).
> Did I do something wrong? Should there be ';' between the parameters or n
ot?
> Thanks in advance!
> Kris
>|||OK by adding in the ';' between the parameters via Config Manager I am now
getting the following message when I try to connect to the server after I
restart the instance backup.
Cannot connect to 'servername'
Login failed for user 'sa'. Reason: Server is in single user mode. Only
one administrator can connect at this time. (Microsoft SQL Server, Error:
18461)
I even went to the length to unplugg the network cable and restart with
server off the network and I still received the same error. Only database I
was moving at the time was 'Model' using the procedures of Article ID 224071
.
Doing another search I found a tech net artilce telling of another want to
move all system databases other then master and resources
http://technet.microsoft.com/en-us/...y/ms345408.aspx
, which is different then 224071. Any ideas and help is great!
Thanks again!
Kris
"Tibor Karaszi" wrote:
> It depend son what tool you are using. In Config Manager: Yes.
> In RegEdit: No, since each parameter has it's own key.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Kris McCarty" <Kris McCarty@.discussions.microsoft.com> wrote in message
> news:AE19C53B-7F0E-4A33-AF14-85748AAF7559@.microsoft.com...
>
moving system databases
Hi all.
Long story, I have a clustered SQL Server 2005 Standard Edition that is
using a SAN. We have just added more drives to our SAN and I need to move
the system database off the current drive to another drive. I have read some
others that have too have asked the same question. And Article ID 224071
keeps coming up. Well I just tried following this article this morning on my
beta server (SQL 2005 Dev Edition) to ensure things would go smoothly on
production and after I tried changing the startup parameters and tried
starting SQL server instance backup I received the following error.
FCB::Open: Operating system error 2(The system cannot find the file
specified.) occurred while creating or opening file 'F:\Program
Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf -c -m -T3608'.
Diagnose and correct the operating system error, and retry the operation.
And after a Google search I ran across an article out on MSDN, saying that
you need to use a ';' in between the parameters.
http://msdn2.microsoft.com/en-us/library/ms190699.aspx
I had to use SQL Server Configuration Manager to change the startup
parameters because there was no 'startup parameters' under the general tab
under Enterprise Manager (I had 2 other people check the steps out too and
they couldn't find it either).
Did I do something wrong? Should there be ';' between the parameters or not?
Thanks in advance!
KrisIf it helps, my SQL 2005 startup parameters from teh Config manager:
-dC:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lC:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
Or check in the registry:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.1\MSSQLServer\Parameters
--
Kevin Hill
IC3 North Texas
www.ChristianCycling.com
Please support me in the 2008 MS150:
http://www.ms150.org/dallas/donate/donate.cfm?id=208000
"Kris McCarty" <Kris McCarty@.discussions.microsoft.com> wrote in message
news:AE19C53B-7F0E-4A33-AF14-85748AAF7559@.microsoft.com...
> Hi all.
> Long story, I have a clustered SQL Server 2005 Standard Edition that is
> using a SAN. We have just added more drives to our SAN and I need to move
> the system database off the current drive to another drive. I have read
> some
> others that have too have asked the same question. And Article ID 224071
> keeps coming up. Well I just tried following this article this morning on
> my
> beta server (SQL 2005 Dev Edition) to ensure things would go smoothly on
> production and after I tried changing the startup parameters and tried
> starting SQL server instance backup I received the following error.
> FCB::Open: Operating system error 2(The system cannot find the file
> specified.) occurred while creating or opening file 'F:\Program
> Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf -c -m -T3608'.
> Diagnose and correct the operating system error, and retry the operation.
> And after a Google search I ran across an article out on MSDN, saying that
> you need to use a ';' in between the parameters.
> http://msdn2.microsoft.com/en-us/library/ms190699.aspx
> I had to use SQL Server Configuration Manager to change the startup
> parameters because there was no 'startup parameters' under the general tab
> under Enterprise Manager (I had 2 other people check the steps out too and
> they couldn't find it either).
> Did I do something wrong? Should there be ';' between the parameters or
> not?
> Thanks in advance!
> Kris
>|||> Should there be ';' between the parameters or not?
It depend son what tool you are using. In Config Manager: Yes.
In RegEdit: No, since each parameter has it's own key.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Kris McCarty" <Kris McCarty@.discussions.microsoft.com> wrote in message
news:AE19C53B-7F0E-4A33-AF14-85748AAF7559@.microsoft.com...
> Hi all.
> Long story, I have a clustered SQL Server 2005 Standard Edition that is
> using a SAN. We have just added more drives to our SAN and I need to move
> the system database off the current drive to another drive. I have read some
> others that have too have asked the same question. And Article ID 224071
> keeps coming up. Well I just tried following this article this morning on my
> beta server (SQL 2005 Dev Edition) to ensure things would go smoothly on
> production and after I tried changing the startup parameters and tried
> starting SQL server instance backup I received the following error.
> FCB::Open: Operating system error 2(The system cannot find the file
> specified.) occurred while creating or opening file 'F:\Program
> Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf -c -m -T3608'.
> Diagnose and correct the operating system error, and retry the operation.
> And after a Google search I ran across an article out on MSDN, saying that
> you need to use a ';' in between the parameters.
> http://msdn2.microsoft.com/en-us/library/ms190699.aspx
> I had to use SQL Server Configuration Manager to change the startup
> parameters because there was no 'startup parameters' under the general tab
> under Enterprise Manager (I had 2 other people check the steps out too and
> they couldn't find it either).
> Did I do something wrong? Should there be ';' between the parameters or not?
> Thanks in advance!
> Kris
>|||OK by adding in the ';' between the parameters via Config Manager I am now
getting the following message when I try to connect to the server after I
restart the instance backup.
Cannot connect to 'servername'
Login failed for user 'sa'. Reason: Server is in single user mode. Only
one administrator can connect at this time. (Microsoft SQL Server, Error:
18461)
I even went to the length to unplugg the network cable and restart with
server off the network and I still received the same error. Only database I
was moving at the time was 'Model' using the procedures of Article ID 224071.
Doing another search I found a tech net artilce telling of another want to
move all system databases other then master and resources
http://technet.microsoft.com/en-us/library/ms345408.aspx
, which is different then 224071. Any ideas and help is great!
Thanks again!
Kris
"Tibor Karaszi" wrote:
> > Should there be ';' between the parameters or not?
> It depend son what tool you are using. In Config Manager: Yes.
> In RegEdit: No, since each parameter has it's own key.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Kris McCarty" <Kris McCarty@.discussions.microsoft.com> wrote in message
> news:AE19C53B-7F0E-4A33-AF14-85748AAF7559@.microsoft.com...
> > Hi all.
> >
> > Long story, I have a clustered SQL Server 2005 Standard Edition that is
> > using a SAN. We have just added more drives to our SAN and I need to move
> > the system database off the current drive to another drive. I have read some
> > others that have too have asked the same question. And Article ID 224071
> > keeps coming up. Well I just tried following this article this morning on my
> > beta server (SQL 2005 Dev Edition) to ensure things would go smoothly on
> > production and after I tried changing the startup parameters and tried
> > starting SQL server instance backup I received the following error.
> >
> > FCB::Open: Operating system error 2(The system cannot find the file
> > specified.) occurred while creating or opening file 'F:\Program
> > Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf -c -m -T3608'.
> > Diagnose and correct the operating system error, and retry the operation.
> >
> > And after a Google search I ran across an article out on MSDN, saying that
> > you need to use a ';' in between the parameters.
> > http://msdn2.microsoft.com/en-us/library/ms190699.aspx
> >
> > I had to use SQL Server Configuration Manager to change the startup
> > parameters because there was no 'startup parameters' under the general tab
> > under Enterprise Manager (I had 2 other people check the steps out too and
> > they couldn't find it either).
> >
> > Did I do something wrong? Should there be ';' between the parameters or not?
> >
> > Thanks in advance!
> > Kris
> >
>
Long story, I have a clustered SQL Server 2005 Standard Edition that is
using a SAN. We have just added more drives to our SAN and I need to move
the system database off the current drive to another drive. I have read some
others that have too have asked the same question. And Article ID 224071
keeps coming up. Well I just tried following this article this morning on my
beta server (SQL 2005 Dev Edition) to ensure things would go smoothly on
production and after I tried changing the startup parameters and tried
starting SQL server instance backup I received the following error.
FCB::Open: Operating system error 2(The system cannot find the file
specified.) occurred while creating or opening file 'F:\Program
Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf -c -m -T3608'.
Diagnose and correct the operating system error, and retry the operation.
And after a Google search I ran across an article out on MSDN, saying that
you need to use a ';' in between the parameters.
http://msdn2.microsoft.com/en-us/library/ms190699.aspx
I had to use SQL Server Configuration Manager to change the startup
parameters because there was no 'startup parameters' under the general tab
under Enterprise Manager (I had 2 other people check the steps out too and
they couldn't find it either).
Did I do something wrong? Should there be ';' between the parameters or not?
Thanks in advance!
KrisIf it helps, my SQL 2005 startup parameters from teh Config manager:
-dC:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lC:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
Or check in the registry:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.1\MSSQLServer\Parameters
--
Kevin Hill
IC3 North Texas
www.ChristianCycling.com
Please support me in the 2008 MS150:
http://www.ms150.org/dallas/donate/donate.cfm?id=208000
"Kris McCarty" <Kris McCarty@.discussions.microsoft.com> wrote in message
news:AE19C53B-7F0E-4A33-AF14-85748AAF7559@.microsoft.com...
> Hi all.
> Long story, I have a clustered SQL Server 2005 Standard Edition that is
> using a SAN. We have just added more drives to our SAN and I need to move
> the system database off the current drive to another drive. I have read
> some
> others that have too have asked the same question. And Article ID 224071
> keeps coming up. Well I just tried following this article this morning on
> my
> beta server (SQL 2005 Dev Edition) to ensure things would go smoothly on
> production and after I tried changing the startup parameters and tried
> starting SQL server instance backup I received the following error.
> FCB::Open: Operating system error 2(The system cannot find the file
> specified.) occurred while creating or opening file 'F:\Program
> Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf -c -m -T3608'.
> Diagnose and correct the operating system error, and retry the operation.
> And after a Google search I ran across an article out on MSDN, saying that
> you need to use a ';' in between the parameters.
> http://msdn2.microsoft.com/en-us/library/ms190699.aspx
> I had to use SQL Server Configuration Manager to change the startup
> parameters because there was no 'startup parameters' under the general tab
> under Enterprise Manager (I had 2 other people check the steps out too and
> they couldn't find it either).
> Did I do something wrong? Should there be ';' between the parameters or
> not?
> Thanks in advance!
> Kris
>|||> Should there be ';' between the parameters or not?
It depend son what tool you are using. In Config Manager: Yes.
In RegEdit: No, since each parameter has it's own key.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Kris McCarty" <Kris McCarty@.discussions.microsoft.com> wrote in message
news:AE19C53B-7F0E-4A33-AF14-85748AAF7559@.microsoft.com...
> Hi all.
> Long story, I have a clustered SQL Server 2005 Standard Edition that is
> using a SAN. We have just added more drives to our SAN and I need to move
> the system database off the current drive to another drive. I have read some
> others that have too have asked the same question. And Article ID 224071
> keeps coming up. Well I just tried following this article this morning on my
> beta server (SQL 2005 Dev Edition) to ensure things would go smoothly on
> production and after I tried changing the startup parameters and tried
> starting SQL server instance backup I received the following error.
> FCB::Open: Operating system error 2(The system cannot find the file
> specified.) occurred while creating or opening file 'F:\Program
> Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf -c -m -T3608'.
> Diagnose and correct the operating system error, and retry the operation.
> And after a Google search I ran across an article out on MSDN, saying that
> you need to use a ';' in between the parameters.
> http://msdn2.microsoft.com/en-us/library/ms190699.aspx
> I had to use SQL Server Configuration Manager to change the startup
> parameters because there was no 'startup parameters' under the general tab
> under Enterprise Manager (I had 2 other people check the steps out too and
> they couldn't find it either).
> Did I do something wrong? Should there be ';' between the parameters or not?
> Thanks in advance!
> Kris
>|||OK by adding in the ';' between the parameters via Config Manager I am now
getting the following message when I try to connect to the server after I
restart the instance backup.
Cannot connect to 'servername'
Login failed for user 'sa'. Reason: Server is in single user mode. Only
one administrator can connect at this time. (Microsoft SQL Server, Error:
18461)
I even went to the length to unplugg the network cable and restart with
server off the network and I still received the same error. Only database I
was moving at the time was 'Model' using the procedures of Article ID 224071.
Doing another search I found a tech net artilce telling of another want to
move all system databases other then master and resources
http://technet.microsoft.com/en-us/library/ms345408.aspx
, which is different then 224071. Any ideas and help is great!
Thanks again!
Kris
"Tibor Karaszi" wrote:
> > Should there be ';' between the parameters or not?
> It depend son what tool you are using. In Config Manager: Yes.
> In RegEdit: No, since each parameter has it's own key.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Kris McCarty" <Kris McCarty@.discussions.microsoft.com> wrote in message
> news:AE19C53B-7F0E-4A33-AF14-85748AAF7559@.microsoft.com...
> > Hi all.
> >
> > Long story, I have a clustered SQL Server 2005 Standard Edition that is
> > using a SAN. We have just added more drives to our SAN and I need to move
> > the system database off the current drive to another drive. I have read some
> > others that have too have asked the same question. And Article ID 224071
> > keeps coming up. Well I just tried following this article this morning on my
> > beta server (SQL 2005 Dev Edition) to ensure things would go smoothly on
> > production and after I tried changing the startup parameters and tried
> > starting SQL server instance backup I received the following error.
> >
> > FCB::Open: Operating system error 2(The system cannot find the file
> > specified.) occurred while creating or opening file 'F:\Program
> > Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf -c -m -T3608'.
> > Diagnose and correct the operating system error, and retry the operation.
> >
> > And after a Google search I ran across an article out on MSDN, saying that
> > you need to use a ';' in between the parameters.
> > http://msdn2.microsoft.com/en-us/library/ms190699.aspx
> >
> > I had to use SQL Server Configuration Manager to change the startup
> > parameters because there was no 'startup parameters' under the general tab
> > under Enterprise Manager (I had 2 other people check the steps out too and
> > they couldn't find it either).
> >
> > Did I do something wrong? Should there be ';' between the parameters or not?
> >
> > Thanks in advance!
> > Kris
> >
>
Monday, March 12, 2012
Moving SQl cluster to new SAN...
We have two Microsoft Windows 2000/SQL 2000 clusters that need to move from
one SAN to another. The old SAN is going away.
Does anyone know of a procedures or white papers on how to accomplish this.
Dave
Read this excellent blog post -
http://msmvps.com/blogs/clusterhelp/archive/2005/08/05/61741.aspx
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:BDD48A84-20BD-4A29-87DF-94889805A3BB@.microsoft.com...
> We have two Microsoft Windows 2000/SQL 2000 clusters that need to move
> from
> one SAN to another. The old SAN is going away.
> Does anyone know of a procedures or white papers on how to accomplish
> this.
> --
> Dave
one SAN to another. The old SAN is going away.
Does anyone know of a procedures or white papers on how to accomplish this.
Dave
Read this excellent blog post -
http://msmvps.com/blogs/clusterhelp/archive/2005/08/05/61741.aspx
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:BDD48A84-20BD-4A29-87DF-94889805A3BB@.microsoft.com...
> We have two Microsoft Windows 2000/SQL 2000 clusters that need to move
> from
> one SAN to another. The old SAN is going away.
> Does anyone know of a procedures or white papers on how to accomplish
> this.
> --
> Dave
Friday, March 9, 2012
Moving resources to SATA storage temporarily
We are planning to move all resources to some SATA drives so we can
reconfigure the SAN. This includes the Quorum and all data resources.
Does anyone have any advice or can anyone think of any "gotchas" that we
should be watching for or preparing for?
This is unsupported and won't work. SCSI, SAN's, and iSCSI are supported. If
you SAN can handle SATA drives, go for it!
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"Wayne" <watkinson@.sd43.bc.ca> wrote in message
news:eDrXTar$GHA.3308@.TK2MSFTNGP03.phx.gbl...
> We are planning to move all resources to some SATA drives so we can
> reconfigure the SAN. This includes the Quorum and all data resources.
> Does anyone have any advice or can anyone think of any "gotchas" that we
> should be watching for or preparing for?
>
|||"Wayne" <watkinson@.sd43.bc.ca> wrote in message
news:eDrXTar$GHA.3308@.TK2MSFTNGP03.phx.gbl...
> We are planning to move all resources to some SATA drives so we can
> reconfigure the SAN. This includes the Quorum and all data resources.
> Does anyone have any advice or can anyone think of any "gotchas" that we
> should be watching for or preparing for?
As Rodney said, SATA won't cut it.
Something you might consider would be to utilize a Majority Node Set quorum
so that way you can at least start with a reconfiguration of the quorum
disk.
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp
reconfigure the SAN. This includes the Quorum and all data resources.
Does anyone have any advice or can anyone think of any "gotchas" that we
should be watching for or preparing for?
This is unsupported and won't work. SCSI, SAN's, and iSCSI are supported. If
you SAN can handle SATA drives, go for it!
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"Wayne" <watkinson@.sd43.bc.ca> wrote in message
news:eDrXTar$GHA.3308@.TK2MSFTNGP03.phx.gbl...
> We are planning to move all resources to some SATA drives so we can
> reconfigure the SAN. This includes the Quorum and all data resources.
> Does anyone have any advice or can anyone think of any "gotchas" that we
> should be watching for or preparing for?
>
|||"Wayne" <watkinson@.sd43.bc.ca> wrote in message
news:eDrXTar$GHA.3308@.TK2MSFTNGP03.phx.gbl...
> We are planning to move all resources to some SATA drives so we can
> reconfigure the SAN. This includes the Quorum and all data resources.
> Does anyone have any advice or can anyone think of any "gotchas" that we
> should be watching for or preparing for?
As Rodney said, SATA won't cut it.
Something you might consider would be to utilize a Majority Node Set quorum
so that way you can at least start with a reconfiguration of the quorum
disk.
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp
Subscribe to:
Posts (Atom)