Adding New Disk

When I add a new disk and put a file on it and make it part of the primary
filegroup, how does disk space get used? Basically my current disk is 90%
full and I'd like to relieve it as much as possible.
Files within a file group get filled in a proportion fill method that is
based of the amount of free space in the file. So if you added another file
some new data would be inserted into the existing one(s) but most would go
into the new one. At least until they leveled off. If your concerned it
would be best to BCP out all the data, truncate the tables, add the new
file(s) and then BCP the data back in. That would fill them more evenly and
place more of the existing data on the new files.
Andrew J. Kelly SQL MVP
"Brad" <me@.privacy.net> wrote in message
news:MPG.1b435bcab46a01ee98bdd7@.news...
> When I add a new disk and put a file on it and make it part of the primary
> filegroup, how does disk space get used? Basically my current disk is 90%
> full and I'd like to relieve it as much as possible.

Adding New Disk

When I add a new disk and put a file on it and make it part of the primary
filegroup, how does disk space get used? Basically my current disk is 90%
full and I'd like to relieve it as much as possible.Files within a file group get filled in a proportion fill method that is
based of the amount of free space in the file. So if you added another file
some new data would be inserted into the existing one(s) but most would go
into the new one. At least until they leveled off. If your concerned it
would be best to BCP out all the data, truncate the tables, add the new
file(s) and then BCP the data back in. That would fill them more evenly and
place more of the existing data on the new files.
Andrew J. Kelly SQL MVP
"Brad" <me@.privacy.net> wrote in message
news:MPG.1b435bcab46a01ee98bdd7@.news...
> When I add a new disk and put a file on it and make it part of the primary
> filegroup, how does disk space get used? Basically my current disk is 90%
> full and I'd like to relieve it as much as possible.

Adding New Disk

When I add a new disk and put a file on it and make it part of the primary
filegroup, how does disk space get used? Basically my current disk is 90%
full and I'd like to relieve it as much as possible.Files within a file group get filled in a proportion fill method that is
based of the amount of free space in the file. So if you added another file
some new data would be inserted into the existing one(s) but most would go
into the new one. At least until they leveled off. If your concerned it
would be best to BCP out all the data, truncate the tables, add the new
file(s) and then BCP the data back in. That would fill them more evenly and
place more of the existing data on the new files.
--
Andrew J. Kelly SQL MVP
"Brad" <me@.privacy.net> wrote in message
news:MPG.1b435bcab46a01ee98bdd7@.news...
> When I add a new disk and put a file on it and make it part of the primary
> filegroup, how does disk space get used? Basically my current disk is 90%
> full and I'd like to relieve it as much as possible.

adding disk to existing clustered sql 2000 instance

hi guys
i had 2 sql instances in win2003. I uninstalled one instance. How do i add
the disks to the existing/active instance?
TIAHi
Move the disks to the SQL Server group you want to add them to. Take the
group offline, create a dependency for SQL Server on the new disks and bring
the group online again.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"rupart" wrote:

> hi guys
> i had 2 sql instances in win2003. I uninstalled one instance. How do i add
> the disks to the existing/active instance?
> TIA|||hi Mike,
i tried to create the resource(physical disk) but couldnt see the disks
under the list...
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> Move the disks to the SQL Server group you want to add them to. Take the
> group offline, create a dependency for SQL Server on the new disks and bri
ng
> the group online again.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "rupart" wrote:
>

adding disk to existing clustered sql 2000 instance

hi guys
i had 2 sql instances in win2003. I uninstalled one instance. How do i add
the disks to the existing/active instance?
TIA
Hi
Move the disks to the SQL Server group you want to add them to. Take the
group offline, create a dependency for SQL Server on the new disks and bring
the group online again.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"rupart" wrote:

> hi guys
> i had 2 sql instances in win2003. I uninstalled one instance. How do i add
> the disks to the existing/active instance?
> TIA
|||hi Mike,
i tried to create the resource(physical disk) but couldnt see the disks
under the list...
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> Move the disks to the SQL Server group you want to add them to. Take the
> group offline, create a dependency for SQL Server on the new disks and bring
> the group online again.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "rupart" wrote:

adding disk to existing clustered sql 2000 instance

hi guys
i had 2 sql instances in win2003. I uninstalled one instance. How do i add
the disks to the existing/active instance?
TIAHi
Move the disks to the SQL Server group you want to add them to. Take the
group offline, create a dependency for SQL Server on the new disks and bring
the group online again.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"rupart" wrote:
> hi guys
> i had 2 sql instances in win2003. I uninstalled one instance. How do i add
> the disks to the existing/active instance?
> TIA|||hi Mike,
i tried to create the resource(physical disk) but couldnt see the disks
under the list...
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> Move the disks to the SQL Server group you want to add them to. Take the
> group offline, create a dependency for SQL Server on the new disks and bring
> the group online again.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "rupart" wrote:
> > hi guys
> > i had 2 sql instances in win2003. I uninstalled one instance. How do i add
> > the disks to the existing/active instance?
> >
> > TIA

adding disk

I have to add SAN space to an existing cluster. what are the steps?
thanks
Create LUN on SAN
Present LUN to Host computers via SAN Masking software
On one host:
Rescan disks in Disk Administrator on host. (may require host reboot)
Partition disk (may require offsetting the start of the partition to align
LUN boundaries)
Create disk resource on temporary cluster group.
Rescan disks on remaining host nodes (again, ay require reboot of specific
nodes.
Test disk access on all nodes, shifting disk resource as necessary.
On the host for the SQL Instance you wish to add the disk to:
Using Cluster Administrator, Stop the SQL Service, leave the remaining
resources online
Make the SQL service dependent on the new disk resource (see existing disk
resource dependencies)
Start SQL Service using Cluster Administrator
Add folders and data.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"vision" <vision@.discussions.microsoft.com> wrote in message
news:192B4B9C-D1BB-4A46-9322-771B4C2F3987@.microsoft.com...
>I have to add SAN space to an existing cluster. what are the steps?
> thanks
|||thanks'
I am not sure what a temporary disk resource is.
"Geoff N. Hiten" wrote:

> Create LUN on SAN
> Present LUN to Host computers via SAN Masking software
> On one host:
> Rescan disks in Disk Administrator on host. (may require host reboot)
> Partition disk (may require offsetting the start of the partition to align
> LUN boundaries)
> Create disk resource on temporary cluster group.
> Rescan disks on remaining host nodes (again, ay require reboot of specific
> nodes.
> Test disk access on all nodes, shifting disk resource as necessary.
> On the host for the SQL Instance you wish to add the disk to:
> Using Cluster Administrator, Stop the SQL Service, leave the remaining
> resources online
> Make the SQL service dependent on the new disk resource (see existing disk
> resource dependencies)
> Start SQL Service using Cluster Administrator
> Add folders and data.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "vision" <vision@.discussions.microsoft.com> wrote in message
> news:192B4B9C-D1BB-4A46-9322-771B4C2F3987@.microsoft.com...
>
>
|||Temporary resource group, not temporary disk resource.
This is just a group you made up to hold the resource while you are testing
it. Once you have confirmed it moves between hosts as you expect, you moe
the disk resource into the SQL group before setting the dependencies.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"vision" <vision@.discussions.microsoft.com> wrote in message
news:9CDCB135-2CBF-417E-B158-FC3BA891D421@.microsoft.com...[vbcol=seagreen]
> thanks'
> I am not sure what a temporary disk resource is.
> "Geoff N. Hiten" wrote:
|||If you need to replace the disk, or want to swap it out, use the Cluster
Recovery Utility to change the resource dependencies. Then you copy the
contents of the old volume to the new and swap the drive letters.
The SQL Server resources will have to be offline during this process, but
you won't have to hack the registry to refer to a new drive letter.
The download contains a reference document.
http://www.microsoft.com/downloads/details.aspx?familyid=2BE7EBF0-A408-4232-9353-64AAFD65306D&displaylang=en
Sincerely,
Anthony Thomas

"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:eNEP0ieAHHA.4472@.TK2MSFTNGP03.phx.gbl...
> Temporary resource group, not temporary disk resource.
> This is just a group you made up to hold the resource while you are
testing
> it. Once you have confirmed it moves between hosts as you expect, you moe
> the disk resource into the SQL group before setting the dependencies.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "vision" <vision@.discussions.microsoft.com> wrote in message
> news:9CDCB135-2CBF-417E-B158-FC3BA891D421@.microsoft.com...
>