Moving Tables

I'm aware of the two methods of moving a table from one filegroup to another
:
(re)create a clustered index on the new filegroup or create the table on the
new filegroup then bcp data into new table.
Is there just a simple way to say "move from PRIMARY to whatever"?
Thanks!!Hi,
Easiest method is to re-create the clustered index in new file group. This
will move the table to the new file group automatically.
Enterprise Manager moves a table from one filegroup to another without using
an undocumented task, but T-SQL doesn't have a command that does the same
thing. The easiest way to move a table to another filegroup is to create a
clustered index on the table. If the table already has a clustered index,
you can use the CREATE INDEX command's WITH DROP_EXISTING clause to recreate
the clustered index and move it to a particular filegroup. When a table has
a clustered index, the leaf level of the index and the data pages of the
table essentially become one and the same. The table must exist where the
clustered index exists, so if you create or recreate a clustered
index-placing the index on a particular filegroup-you're moving the table to
the new filegroup as well.
Thanks
Hari
SQL Server MVP
"A. Robinson" <ARobinson@.discussions.microsoft.com> wrote in message
news:D6A7F27B-309D-40C1-9663-D28B2514673A@.microsoft.com...
> I'm aware of the two methods of moving a table from one filegroup to
> another:
> (re)create a clustered index on the new filegroup or create the table on
> the
> new filegroup then bcp data into new table.
> Is there just a simple way to say "move from PRIMARY to whatever"?
> Thanks!!
>|||I was kinda afraid of that...that's the way I've done it in the past.
Thanks!
What aboutr setting a filgroup to read only - through the gui only'
"Hari Pra" wrote:

> Hi,
> Easiest method is to re-create the clustered index in new file group. This
> will move the table to the new file group automatically.
> Enterprise Manager moves a table from one filegroup to another without usi
ng
> an undocumented task, but T-SQL doesn't have a command that does the same
> thing. The easiest way to move a table to another filegroup is to create a
> clustered index on the table. If the table already has a clustered index,
> you can use the CREATE INDEX command's WITH DROP_EXISTING clause to recrea
te
> the clustered index and move it to a particular filegroup. When a table ha
s
> a clustered index, the leaf level of the index and the data pages of the
> table essentially become one and the same. The table must exist where the
> clustered index exists, so if you create or recreate a clustered
> index-placing the index on a particular filegroup-you're moving the table
to
> the new filegroup as well.
> Thanks
> Hari
> SQL Server MVP
> "A. Robinson" <ARobinson@.discussions.microsoft.com> wrote in message
> news:D6A7F27B-309D-40C1-9663-D28B2514673A@.microsoft.com...
>
>|||Hi,
I have moved the table to different file group couple of times. But ensure
that you take a full database backup before doing this.
I have never tried setting a file group to read only from GUI, but i did
once using TSQL. But i belive to set the file group to read only first you
need to set the database to SINGLE USER Mode.
Thanks
Hari
SQL Server MVP
"A. Robinson" <ARobinson@.discussions.microsoft.com> wrote in message
news:3613F67F-6AE7-4A5A-987D-85C5269675F1@.microsoft.com...
>I was kinda afraid of that...that's the way I've done it in the past.
> Thanks!
> What aboutr setting a filgroup to read only - through the gui only'
> "Hari Pra" wrote:
>

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...
>

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...
>

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
> >
>

Moving Non-Clustered to Clustered

Hi,
I have been looking for the last few hours for how to move a non-clustered
environment to a clustered environment without having to change the
connection strings of any of our applications. I'm not finding it anywhere.
It's been a while since I did this, and I thought we could have a virtual
name for both instances that are the same as the old computer names (I.E.
Instance 1 is called "Bitter" and instance 2 is called "silver" from the
apps, even if the actual names are ClustName\Instance1 &
Clustname\Instance2).
Is this possible, and can someone point me to where I can find how to do
this, if it is?
Thanks,
Ryan S
SQL DBA
1Jn5:12
You do it by using DNS SRV records. SRV records allows for an arbitary
service to use DNS to map a name to an IP Address and Port number.
When you cut over, create a "Bitter" and "Silver" record that points to the
new clustered instance names.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Ryan S" <RyanS@.discussions.microsoft.com> wrote in message
news:EA78A067-5C48-4C17-9819-064C8399BF0F@.microsoft.com...
> Hi,
> I have been looking for the last few hours for how to move a non-clustered
> environment to a clustered environment without having to change the
> connection strings of any of our applications. I'm not finding it
> anywhere.
> It's been a while since I did this, and I thought we could have a virtual
> name for both instances that are the same as the old computer names (I.E.
> Instance 1 is called "Bitter" and instance 2 is called "silver" from the
> apps, even if the actual names are ClustName\Instance1 &
> Clustname\Instance2).
> Is this possible, and can someone point me to where I can find how to do
> this, if it is?
> Thanks,
> --
> Ryan S
> SQL DBA
> 1Jn5:12
|||Thanks for the help, but I am still having trouble finding exactly how to do
it.
Is it just as simple as redirecting the TCP/IP traffic to the correct
ip/port, like a dyn dns service or is there more to it?
Sorry if we are being obtuse, but neither I, nor my Net Admin, can seem to
find anything in BOL, or at MS or online about setting up a SQL Instance with
DNS SRV records.
Ryan S
SQL DBA
1Jn5:12
"Geoff N. Hiten" wrote:

> You do it by using DNS SRV records. SRV records allows for an arbitary
> service to use DNS to map a name to an IP Address and Port number.
> When you cut over, create a "Bitter" and "Silver" record that points to the
> new clustered instance names.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
> "Ryan S" <RyanS@.discussions.microsoft.com> wrote in message
> news:EA78A067-5C48-4C17-9819-064C8399BF0F@.microsoft.com...
>
|||That is about all there is to it. And there is no KB article or section in
BOL about abstracting the service name of a SQL server using DNS SRV
records. Maybe I should write something.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Ryan S" <RyanS@.discussions.microsoft.com> wrote in message
news:6FC957E4-8170-470A-AD57-9EC781EBFF6B@.microsoft.com...[vbcol=seagreen]
> Thanks for the help, but I am still having trouble finding exactly how to
> do
> it.
> Is it just as simple as redirecting the TCP/IP traffic to the correct
> ip/port, like a dyn dns service or is there more to it?
> Sorry if we are being obtuse, but neither I, nor my Net Admin, can seem to
> find anything in BOL, or at MS or online about setting up a SQL Instance
> with
> DNS SRV records.
> --
> Ryan S
> SQL DBA
> 1Jn5:12
>
> "Geoff N. Hiten" wrote:
|||Thanks,
If you do write it, reply to this, and I'll be notified.
Thanks again,
Ryan S
Sr SQL DBA
1Jn5:12
"Geoff N. Hiten" wrote:
[vbcol=seagreen]
> That is about all there is to it. And there is no KB article or section in
> BOL about abstracting the service name of a SQL server using DNS SRV
> records. Maybe I should write something.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
> "Ryan S" <RyanS@.discussions.microsoft.com> wrote in message
> news:6FC957E4-8170-470A-AD57-9EC781EBFF6B@.microsoft.com...

moving instance on cluster

Hi,
I have a clustered sql server with two instances. It looks like the
disk on one instance is not large enough for the db, whilst the disk
assigned to the other instance has plenty of room. I'd like to swap
disks between instances. How can i move an instance between disks?
Any ideas?
Try Moving SQL Server databases to a new location with Detach/Attach
http://support.microsoft.com/default...;en-us;224071, really
pretty easy stuff
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"jmh01" <jmh01@.dslextreme.com> wrote in message
news:1102907117.320981.103110@.c13g2000cwb.googlegr oups.com...
> Hi,
> I have a clustered sql server with two instances. It looks like the
> disk on one instance is not large enough for the db, whilst the disk
> assigned to the other instance has plenty of room. I'd like to swap
> disks between instances. How can i move an instance between disks?
> Any ideas?
>