Disks

I need additional disk space for storing my backups on SQL server 2000. Any
ideas on the latest and greatest discs I can purchase. Thanks
What disks you can buy probably depends on your hardware. Are you running
IDE? SATA? SCSI? Buy whatever disks work with your current hardware,
provide enough storage, and are cost effective for your environment. Don't
forget about growth...you probably don't want to buy drives in another
month or two.
Keith
"Niles" <Niles@.discussions.microsoft.com> wrote in message
news:8A8A8D80-7E98-43DA-B78C-3EC3232DB8FF@.microsoft.com...
> I need additional disk space for storing my backups on SQL server 2000.
Any
> ideas on the latest and greatest discs I can purchase. Thanks
|||Any limits that sql server has as far as how many discs you can add? I still
have 4 slots open. We have SCSI discs some are 72.8 GB others are 36.4GB
Thanks
"Keith Kratochvil" wrote:

> What disks you can buy probably depends on your hardware. Are you running
> IDE? SATA? SCSI? Buy whatever disks work with your current hardware,
> provide enough storage, and are cost effective for your environment. Don't
> forget about growth...you probably don't want to buy drives in another
> month or two.
> --
> Keith
>
> "Niles" <Niles@.discussions.microsoft.com> wrote in message
> news:8A8A8D80-7E98-43DA-B78C-3EC3232DB8FF@.microsoft.com...
> Any
>
|||SQL Server will use what the OS provides.
Keith
"Niles" <Niles@.discussions.microsoft.com> wrote in message
news:0044BB2C-7897-4DA6-9237-AED43D7F35AE@.microsoft.com...
> Any limits that sql server has as far as how many discs you can add? I
still[vbcol=seagreen]
> have 4 slots open. We have SCSI discs some are 72.8 GB others are 36.4GB
> Thanks
> "Keith Kratochvil" wrote:
running[vbcol=seagreen]
Don't[vbcol=seagreen]
2000.[vbcol=seagreen]

Disks

I need additional disk space for storing my backups on SQL server 2000. Any
ideas on the latest and greatest discs I can purchase. ThanksWhat disks you can buy probably depends on your hardware. Are you running
IDE? SATA? SCSI? Buy whatever disks work with your current hardware,
provide enough storage, and are cost effective for your environment. Don't
forget about growth...you probably don't want to buy drives in another
month or two.
Keith
"Niles" <Niles@.discussions.microsoft.com> wrote in message
news:8A8A8D80-7E98-43DA-B78C-3EC3232DB8FF@.microsoft.com...
> I need additional disk space for storing my backups on SQL server 2000.
Any
> ideas on the latest and greatest discs I can purchase. Thanks|||Any limits that sql server has as far as how many discs you can add? I stil
l
have 4 slots open. We have SCSI discs some are 72.8 GB others are 36.4GB
Thanks
"Keith Kratochvil" wrote:

> What disks you can buy probably depends on your hardware. Are you running
> IDE? SATA? SCSI? Buy whatever disks work with your current hardware,
> provide enough storage, and are cost effective for your environment. Don'
t
> forget about growth...you probably don't want to buy drives in another
> month or two.
> --
> Keith
>
> "Niles" <Niles@.discussions.microsoft.com> wrote in message
> news:8A8A8D80-7E98-43DA-B78C-3EC3232DB8FF@.microsoft.com...
> Any
>|||SQL Server will use what the OS provides.
Keith
"Niles" <Niles@.discussions.microsoft.com> wrote in message
news:0044BB2C-7897-4DA6-9237-AED43D7F35AE@.microsoft.com...
> Any limits that sql server has as far as how many discs you can add? I
still[vbcol=seagreen]
> have 4 slots open. We have SCSI discs some are 72.8 GB others are 36.4GB
> Thanks
> "Keith Kratochvil" wrote:
>
running[vbcol=seagreen]
Don't[vbcol=seagreen]
2000.[vbcol=seagreen]sql

Disk writes/sec value

I picked up the disk writes/sec for a particular physical
disk and noticed it shoot to 2800 at times..
What does that mean ? There are 2800 writes to that array
that may comprise of 6 disks or so..
Jamie,
Check out these for more details on the proper counters:
http://www.microsoft.com/sql/techinf...perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.co...ance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.co...mance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/de...rfmon_24u1.asp
Disk Monitoring
But what exactly is it your trying to determine? The best counter(s) to
view for an overall indication of how busy your disks are is the current
(and average) disk queues.
Andrew J. Kelly SQL MVP
"Jamie" <anonymous@.discussions.microsoft.com> wrote in message
news:23a6401c45ecc$d9104d00$a301280a@.phx.gbl...
> I picked up the disk writes/sec for a particular physical
> disk and noticed it shoot to 2800 at times..
> What does that mean ? There are 2800 writes to that array
> that may comprise of 6 disks or so..

Disk writes/sec value

I picked up the disk writes/sec for a particular physical
disk and noticed it shoot to 2800 at times..
What does that mean ? There are 2800 writes to that array
that may comprise of 6 disks or so..Jamie,
Check out these for more details on the proper counters:
http://www.microsoft.com/sql/techin.../perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.c...mance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.c...rmance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
on_24u1.asp" target="_blank">http://msdn.microsoft.com/library/d.../>
on_24u1.asp
Disk Monitoring
But what exactly is it your trying to determine? The best counter(s) to
view for an overall indication of how busy your disks are is the current
(and average) disk queues.
Andrew J. Kelly SQL MVP
"Jamie" <anonymous@.discussions.microsoft.com> wrote in message
news:23a6401c45ecc$d9104d00$a301280a@.phx
.gbl...
> I picked up the disk writes/sec for a particular physical
> disk and noticed it shoot to 2800 at times..
> What does that mean ? There are 2800 writes to that array
> that may comprise of 6 disks or so..

Disk writes/sec value

I picked up the disk writes/sec for a particular physical
disk and noticed it shoot to 2800 at times..
What does that mean ? There are 2800 writes to that array
that may comprise of 6 disks or so..Jamie,
Check out these for more details on the proper counters:
http://www.microsoft.com/sql/techinfo/administration/2000/perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.com/sql_server_performance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.com/best_sql_server_performance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_perfmon_24u1.asp
Disk Monitoring
But what exactly is it your trying to determine? The best counter(s) to
view for an overall indication of how busy your disks are is the current
(and average) disk queues.
--
Andrew J. Kelly SQL MVP
"Jamie" <anonymous@.discussions.microsoft.com> wrote in message
news:23a6401c45ecc$d9104d00$a301280a@.phx.gbl...
> I picked up the disk writes/sec for a particular physical
> disk and noticed it shoot to 2800 at times..
> What does that mean ? There are 2800 writes to that array
> that may comprise of 6 disks or so..sql

Disk usage Report

There needs to be two levels of disk usage reports, one that just reads the meta data (similar to 2000 functionality), and displays the pretty graphs, and then the one that is currently available that does the index analysis and so on. I have a 1.2 TB database on 2005 and it takes forever to pull up that report (which my client has decided they love)...

Also, I do not know how hard it would be to keep a running analysis of database/index fragmentation, but that would be a nice feature also, even if it was an enterprise only feature.

Just a thought.

Hi Jake,

Thanks for the feedback. I'll pass it along to the PM who owns the reports in SSMS.

Cheers,
Dan

Disk Time 100% during Insert Data

Hi ,
I am using SQL 2000 SP3 2 CPU (Intel II ~1230) with 4 GB RAM .
The server is data warehouse server that load data and served reports.

I am loading data every 15 minute with Balk Insert command into temporarty tables and than insert the data to two fact tables with logic implemented by store procedure.

Each time I am insert new data ( every 15 minutes , for around ~ 4 minute of ~ 250,000 lines) the Disk time is 100% .

I am using RAID 5 with logical partitions for system ,SQL Data file and SQL transaction log file .

In order to solve the Disk Time bottleneck ( the CPU is normal during the insert ~ 40 % but still the duration is too long due to the disk time problem) I though to create separate file group to each fact table and change the Disk configuration from RAID 5 to double RAID 1 ,each one for each File group ( and other disks for the transaction log and system ) .I though that in this way I will be able to use each of the physical disks rather than current RAID 5 .

Any idea ? do you know other option to solve this problem ? what is the reaon for the fact that the Data file that store on RAID 5 do not use the 5 physical Disk headers ?

Thanks in advance
EyalYou didn't mention the "C" word...but I imagine it's in play...where's the data coming from? INSERTS are a logged operation...and 250k of rows, every 15 minutes...is a lot of data...

I would try to figure out a way to perform a nonlogged operation (bulk insert?) and apply the logic against the database...

My own opinion (MOO)

What type of data is this?|||Howdy

Worth removing any indexes on the load tables & then recreating the indexes once data has been loaded?

FWIW

Cheers,

SG.|||Hi no one response regard the Disk configuration .This is my best solution to the Disk time - separate the two Fact table to different phiscal disk means working with two disk header in parallel . !!??|||And you mentioned that you're interested in speed...if you're doing insert a row at a time then that'll be slow, if you're using a cursor, that'll be slow, if your modifying data on import, that'll be slow...

If you want to split the data across attached drives, go ahead, make a patitioned view and go nuts...

Is that the root cause of your problem?

Hard for us to tell until the mind reading machine comes back online...|||I agree with Brett 100%...more info required please

Cheers,

SG

Disk Subsystem Problem during snapshot

We have set up a new SQL environment that has to replace our current SQL
environment. On our current environment we apply a snapshot every night from
our production database (the production database is hosted on another
environment). This means every night approximately 15GB is being copied to
the subscriber. It takes a long time to do this (3+ hours), but is not a
problem in our environment.
Exactly the same snapshot has to be applied on our new SQL environment. In
this environment we are having serious problems with our Disk Subsystem when
applying the snapshot. In the new environment we use a shared HP MSA1000 Disk
System. When applying the snapshot, the load is so high on the MSA1000 that
it can’t handle all the requests no more. This results in a crash of SQL
server (SQL can’t find the tempdb anymore) and other systems that use the
MSA1000 (two more servers, so three in total) are having problems with the
disks also (event id 51).
We’ve contacted HP and Microsoft and the conclusion will probably be that
the load generated by applying the snapshot is to high for the MSA1000.
Microsoft’s explanation about how this can be, knowing that the exact same
process runs on an old environment, is very reasonable (although it’s still
hard to believe that old hardware operates better under high load than new
advanced hardware).
I’d like to know what the opinion from you all is about applying a snapshot
every night to a subscriber, which involves copying approximately 15GB of
data. Should it be no problem to this, or is it very uncommon to do this
because of hardware limitations? Is it normal that the MSA1000 has problems
of this kind with this, or should it be able to handle the load (should it
result in disks that cannot be contacted anymore or should it just perform
very slow)?
Your opinion is very much appreciated!
Kind regards,
Jan Martijn Schuur
"Martijn" schrieb:
...
> I’d like to know what the opinion from you all is about applying a snapshot
> every night to a subscriber, which involves copying approximately 15GB of
> data. Should it be no problem to this, or is it very uncommon to do this
> because of hardware limitations?
15 GB is a large amount of data for a nightly snapshot. Why don't you use
the incremental transactional replication?
Your other problems with this are not familiar to me. Sorry.

Disk Stats

I'm relatively new to Perf Mon and am trying to figure out
the best disk objects to use. I've been watching our
servers and I've noticed that sometimes in the evening the
Avg Disk Q Length goes over acceptable levels. But during
the entire night (or most of it) the Total MBytes/Second
is very high due to backups apparently.
How can I interpret these two numbers? One says the
server is getting slammed all night and the ohter says
it's only having troubles occasionally? Which do I go by?
Dan,
Having high values for Total MBytes/Second is not necessarily bad, all it
indicates is that you're getting good I/O throughput.
However, Avg Disk Queue Length can be a sign of problems, especially when it
gets into the hundreds, because it is indicating that the I/O system cannot
keep up with requests.
For advice on the best SQL Server PerfMon counters for disk I/O, see Tom
Davidson's articles in SQL Magazine.
Hope this helps,
Ron
Ron Talmage
SQL Server MVP
"Dan" <anonymous@.discussions.microsoft.com> wrote in message
news:017601c4a00a$51af0c00$a401280a@.phx.gbl...
> I'm relatively new to Perf Mon and am trying to figure out
> the best disk objects to use. I've been watching our
> servers and I've noticed that sometimes in the evening the
> Avg Disk Q Length goes over acceptable levels. But during
> the entire night (or most of it) the Total MBytes/Second
> is very high due to backups apparently.
> How can I interpret these two numbers? One says the
> server is getting slammed all night and the ohter says
> it's only having troubles occasionally? Which do I go by?

Disk Stats

I'm relatively new to Perf Mon and am trying to figure out
the best disk objects to use. I've been watching our
servers and I've noticed that sometimes in the evening the
Avg Disk Q Length goes over acceptable levels. But during
the entire night (or most of it) the Total MBytes/Second
is very high due to backups apparently.
How can I interpret these two numbers? One says the
server is getting slammed all night and the ohter says
it's only having troubles occasionally? Which do I go by?Dan,
Having high values for Total MBytes/Second is not necessarily bad, all it
indicates is that you're getting good I/O throughput.
However, Avg Disk Queue Length can be a sign of problems, especially when it
gets into the hundreds, because it is indicating that the I/O system cannot
keep up with requests.
For advice on the best SQL Server PerfMon counters for disk I/O, see Tom
Davidson's articles in SQL Magazine.
Hope this helps,
Ron
--
Ron Talmage
SQL Server MVP
"Dan" <anonymous@.discussions.microsoft.com> wrote in message
news:017601c4a00a$51af0c00$a401280a@.phx.gbl...
> I'm relatively new to Perf Mon and am trying to figure out
> the best disk objects to use. I've been watching our
> servers and I've noticed that sometimes in the evening the
> Avg Disk Q Length goes over acceptable levels. But during
> the entire night (or most of it) the Total MBytes/Second
> is very high due to backups apparently.
> How can I interpret these two numbers? One says the
> server is getting slammed all night and the ohter says
> it's only having troubles occasionally? Which do I go by?sql

Disk space usage

SQL 7.0 SP4/NT 4.0
DB File is set to grow by 5%.
It's given that SQL preallocates its hard disk space so
that as records are added to the table, there is no
change to the hard drive space at the NT level.
Is there a way to see, at the SQL level, how much of the
space currently allocated, is available?
Thanks,
Donsp_spaceused will show you how much space is currently
allocated in a database.
Linchi
>--Original Message--
>SQL 7.0 SP4/NT 4.0
>DB File is set to grow by 5%.
>It's given that SQL preallocates its hard disk space so
>that as records are added to the table, there is no
>change to the hard drive space at the NT level.
>Is there a way to see, at the SQL level, how much of the
>space currently allocated, is available?
>Thanks,
>Don
>
>.
>

DISK SPACE QUERY

Hello, is there a way to make a sql statement that checks disk space and
returns a value if it is below x%?Hi,
See the below query, values for each drive will returned in mega bytes.
create table space_check (drive_letter char(1), space_free int)
insert into tmp exec xp_fixeddrives
select * from space_check where space_free < 20
Thanks
Hari
SQL Server MVP
"Gervaise" <Gervaise@.discussions.microsoft.com> wrote in message
news:86C35096-4F7D-4CBB-8A1A-9BDBF028F0E7@.microsoft.com...
> Hello, is there a way to make a sql statement that checks disk space and
> returns a value if it is below x%?

disk space occupied by certain rows?

is there a way to get the disk space occupied by certain rows?

Thank You.

Regards,

A Friend.

SELECT DATALENGTH(ColA) + DATALENGTH(ColB)
From SomeTable
Where Conditionhere

Jens k. Suessmeyer.

http://www.sqlserver2005.de

Disk space Issues

Good day,
I installed sql server 2000 on a 10Gig disk. Now i have a fast growing
database. Is there a way to chanel the incoming data to an already installed
40Gig disk on thesame system?
--
Michael AligbeYou could back up your database, drop it, and then restore it with the "WITH
MOVE" option. This would allow you to place your ldf and/or mdf files on a
different drive.
The other option would be to add filegroups to your database and move some
of your data to those new filegroups. This might be a little more involved
than option one however.
"Myk" wrote:
> Good day,
> I installed sql server 2000 on a 10Gig disk. Now i have a fast growing
> database. Is there a way to chanel the incoming data to an already installed
> 40Gig disk on thesame system?
> --
> Michael Aligbe|||Another way is to sp_detach_db dbname,
copy the mdf file to the other hard drive, the
sp_attach_db dbname, mdffilename, logfilename
This would be quicker than backing up and restoring
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Myk" <Myk@.discussions.microsoft.com> wrote in message
news:00085AD1-BF75-4066-9C12-3D2BAF27DB14@.microsoft.com...
> Good day,
> I installed sql server 2000 on a 10Gig disk. Now i have a fast growing
> database. Is there a way to chanel the incoming data to an already
installed
> 40Gig disk on thesame system?
> --
> Michael Aligbe

Disk space Issues

Good day,
I installed sql server 2000 on a 10Gig disk. Now i have a fast growing
database. Is there a way to chanel the incoming data to an already installed
40Gig disk on thesame system?
Michael Aligbe
You could back up your database, drop it, and then restore it with the "WITH
MOVE" option. This would allow you to place your ldf and/or mdf files on a
different drive.
The other option would be to add filegroups to your database and move some
of your data to those new filegroups. This might be a little more involved
than option one however.
"Myk" wrote:

> Good day,
> I installed sql server 2000 on a 10Gig disk. Now i have a fast growing
> database. Is there a way to chanel the incoming data to an already installed
> 40Gig disk on thesame system?
> --
> Michael Aligbe
|||Another way is to sp_detach_db dbname,
copy the mdf file to the other hard drive, the
sp_attach_db dbname, mdffilename, logfilename
This would be quicker than backing up and restoring
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Myk" <Myk@.discussions.microsoft.com> wrote in message
news:00085AD1-BF75-4066-9C12-3D2BAF27DB14@.microsoft.com...
> Good day,
> I installed sql server 2000 on a 10Gig disk. Now i have a fast growing
> database. Is there a way to chanel the incoming data to an already
installed
> 40Gig disk on thesame system?
> --
> Michael Aligbe
sql

Disk space Issues

Good day,
I installed sql server 2000 on a 10Gig disk. Now i have a fast growing
database. Is there a way to chanel the incoming data to an already installed
40Gig disk on thesame system?
--
Michael AligbeYou could back up your database, drop it, and then restore it with the "WITH
MOVE" option. This would allow you to place your ldf and/or mdf files on a
different drive.
The other option would be to add filegroups to your database and move some
of your data to those new filegroups. This might be a little more involved
than option one however.
"Myk" wrote:

> Good day,
> I installed sql server 2000 on a 10Gig disk. Now i have a fast growing
> database. Is there a way to chanel the incoming data to an already install
ed
> 40Gig disk on thesame system?
> --
> Michael Aligbe|||Another way is to sp_detach_db dbname,
copy the mdf file to the other hard drive, the
sp_attach_db dbname, mdffilename, logfilename
This would be quicker than backing up and restoring
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Myk" <Myk@.discussions.microsoft.com> wrote in message
news:00085AD1-BF75-4066-9C12-3D2BAF27DB14@.microsoft.com...
> Good day,
> I installed sql server 2000 on a 10Gig disk. Now i have a fast growing
> database. Is there a way to chanel the incoming data to an already
installed
> 40Gig disk on thesame system?
> --
> Michael Aligbe

Disk space information in SQL Server 2005.

As a normal sql user we are not able to get the disk space information by

executing 'xp_fixeddrive' extended stored procedure.

We are able to get the result using sa user and windows authenticated user.

Any help will be appreciated.

You may get the information you seek by querying: sys.sysfiles,

or perhaps using the dynamic management view: sys.dm_db_file_space_usage

Refer to Books Online for more information about either of them.

|||the xp_fixeddrives can get the free space in the disk(drivers). it is different to sys.sysfiles.

|||do you have the permission to run this extend procedure? any error informaiton that you got when you used a normall sql user?

I think it caused by the permission. .when you login as sa or windows administrator account , it belongs to sysadmin group by default.

Disk space getting low

I have 3 disk volumes on my server. C, D, E. C=System, D=Logs, E= Data
How do I get the 2 databases to use drive D in addition to drive E for data?
I have 50 gig volume for E and I have about 9 gig free as of now. D has
only consumed 1 gig and free is 34 gig.
TIA
__StephenPre-allocate storage for the database files as desired. If you need to shrink one of the file (so
that data will be pushed to the other file), you can do it using DBCC SHRINKFILE. It will take a
while for a lot of data, though.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Stephen Russell" <srussell@.transactiongraphics.com> wrote in message
news:ugcOCCvsFHA.3040@.TK2MSFTNGP14.phx.gbl...
>I have 3 disk volumes on my server. C, D, E. C=System, D=Logs, E= Data
> How do I get the 2 databases to use drive D in addition to drive E for data? I have 50 gig volume
> for E and I have about 9 gig free as of now. D has only consumed 1 gig and free is 34 gig.
> TIA
> __Stephen
>
>

Disk space getting low

I have 3 disk volumes on my server. C, D, E. C=System, D=Logs, E= Data
How do I get the 2 databases to use drive D in addition to drive E for data?
I have 50 gig volume for E and I have about 9 gig free as of now. D has
only consumed 1 gig and free is 34 gig.
TIA
__Stephen
Pre-allocate storage for the database files as desired. If you need to shrink one of the file (so
that data will be pushed to the other file), you can do it using DBCC SHRINKFILE. It will take a
while for a lot of data, though.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Stephen Russell" <srussell@.transactiongraphics.com> wrote in message
news:ugcOCCvsFHA.3040@.TK2MSFTNGP14.phx.gbl...
>I have 3 disk volumes on my server. C, D, E. C=System, D=Logs, E= Data
> How do I get the 2 databases to use drive D in addition to drive E for data? I have 50 gig volume
> for E and I have about 9 gig free as of now. D has only consumed 1 gig and free is 34 gig.
> TIA
> __Stephen
>
>

Disk space getting low

I have 3 disk volumes on my server. C, D, E. C=System, D=Logs, E= Data
How do I get the 2 databases to use drive D in addition to drive E for data?
I have 50 gig volume for E and I have about 9 gig free as of now. D has
only consumed 1 gig and free is 34 gig.
TIA
__StephenPre-allocate storage for the database files as desired. If you need to shrin
k one of the file (so
that data will be pushed to the other file), you can do it using DBCC SHRINK
FILE. It will take a
while for a lot of data, though.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Stephen Russell" <srussell@.transactiongraphics.com> wrote in message
news:ugcOCCvsFHA.3040@.TK2MSFTNGP14.phx.gbl...
>I have 3 disk volumes on my server. C, D, E. C=System, D=Logs, E= Data
> How do I get the 2 databases to use drive D in addition to drive E for dat
a? I have 50 gig volume
> for E and I have about 9 gig free as of now. D has only consumed 1 gig a
nd free is 34 gig.
> TIA
> __Stephen
>
>sql