Query For Full Drives

Apr 22, 2015

SQL Windows Server: 2008 R2
SQL: 2008 R2

Problem: I have following drives on this server, Is there a query that I can run daily which will show us the % full and remaining storage capacity on these drives?


I would like to run that query on all of my servers to get a daily report.

View 6 Replies


Different Drives

Feb 6, 2008

I am trying to run a program called NVivo7, which - when I install - also requires installation of SQL Server. Because my C drive is small (and nearly full), I am trying to run NVivo7 off my D drive, though SQL seems to install on C. Is it possible, do you think, to use 2 different drives in this way, or do both the program and the Server need to be on the same one? If so, is there any way to get them both on D?

View 3 Replies View Related

Raptor Drives?

Feb 21, 2007

So i'm not really new, but got a question. i've recently been looking to to the Western Digital Raptor Drives.

as far as performance, it's always been my understanding that the speed of the hard drive is just about always the bottle-neck of a computer. i'm currently running 2 stripped WD 500gb SATA drives for my SQL server (dual Xeon 2.8 with 2GB memory).

i'm thinking of upgarding to 4 WD Raptors (10k RPM) drives, the new 150GB models. anyone have an opionion? do you think i'll get a large performance increase?

the database that i run queries off of now is about 125 Million names, with about 80 fields in width. so it's rather large, and usally takes a fair abount of time to get my results back (we're talking anywhere from a minute, to half the day.)

do you think the raptors will slim that down significantly?

View 20 Replies View Related

Restore Does Not See All Of The Drives

Mar 14, 2008

We recently installed SQL Server 2005. The server has 3 drives. When I try to restore a database I can only access the C: drive. How do I make the D: and E: drives visible in the "locate folder" window?

View 5 Replies View Related

Can Not Locate Other Drives

Nov 13, 2007


Can someone help me, I installed SQL 2005 Enterpirse Editon on windows clustered servers. Then after the installation
I want to change the path of my DB logs but the problem was, I can not see the other drives. I can see only the drive where the DB was located. Is there any special configurations that should be done.



View 1 Replies View Related

Cluster Configuration W/ Drives

Apr 19, 2001

Ideally we'd like to configure our SQL cluster w/ the databases on one drive and the logs on another. Is this feasable in a cluster solution.. Will it basically just be 2 drives that are failed over vs. 1?


View 1 Replies View Related

Mapping Drives---URgent Pls

Jul 13, 2000

Hi ,
We are having 4 sql7 servers. All are in network only.
serverA: drives c,d
serverB: drives c,e
serverC: drives c,d
serverD: drives c,d,f
Now my question i want map all the drives to each other. So that i can use the space wherever available, because in serverA i dont have space but in ServerC have lot of free space.
Can anyone pls tell me in detail how we have to map the drives.


View 2 Replies View Related

Monitor Hard Drives

Jul 30, 2001

Hi, I'm looking for a way to check the free space left on the hard drives and then if needed send an alert to notify when we need to free up some space. I played around with the performance monitor and realized I could do it that way but I think you would have to leave the performance monitor running all the time and I'm not sure if I want to do that. I also read about the xp_fixeddrives proc that displays how much free space is available but then I don't know what to do from there? Does anyone have any recommendations for the best way to do this.

View 3 Replies View Related

Mapped Drives On SQL Server

Aug 6, 2001


I mapped a drive on to my SQL Server box. It points to another server from the same domain. When I try to backup or restore a database, I can't see this mapped drive through my SQL Server. Even if I type the entire path, SQL Server wouldn't take it. I don't have a clue about why it is not working. Can anyone throw some light on this. Your help is grately appreciated.


View 2 Replies View Related

Why We Allocate .mdf And .ldf On Seperate Drives?

Oct 25, 2004

Why we allocate .mdf and .ldf on seperate drives?
Please tell me a proper logical reason behind it.

View 2 Replies View Related

SQL Server Not Showing The Drives

Mar 13, 2006

My sql server is not showing all of my drives in server. Please help me

View 5 Replies View Related

Drives On Perfomance Monitor

Jan 20, 2004

Can someone tell me if it is possible to see the drives on the server using Perfomance Monitor? I so, where are tehy hiding because i struggled the wholed day!

View 6 Replies View Related

Best Practice For Db Design On 2 Drives

Nov 1, 2007

I have a SQL 2000 server that is installed on a Dual Xeon server running win2k. The server has two raid 5 hard drives, a C drive and an E drive.
The C drive is currently where the operating system files are stored as well as the SQL program files. As things stand there are SQL DB and transaction logs strewn between these two drives with no particular logic.
My question is, with two drives as it stands how should I move things around to gain the best performance? For example, should I keep all my data on the E drives and all my transaction logs on the C drives with the OS and the program files?

There are about 10 Databases in use. One database run's the configuration for proprietary predictive dialing software. The other databases are calling information for each campaign we run within the dialing software.

I have enough space on both drives to accommodate the data, its performance I would like to see a difference in.

View 6 Replies View Related

Drives In A Cluster Environment

Jul 24, 2006


I have a SAN and configuring a cluster on SQL 2005. I initially created a Quorum drive when setting up the cluster and now added 4 more drives to the physical node but when I try to install SQL that drive cannot be located.

Do we need to create all the drives when installing the cluster or what is the way to add the drives later on.



View 9 Replies View Related

Mirroring Hard Drives

Jul 16, 2007

I have a 75 GB hard drive and a 300 GB. I want to mirror the 75 to the 300 and use the extra space as data storage. Is this possible if I partition the 300 and then mirror the hard drives.


View 5 Replies View Related

Drives Missing From Requester...how Come ?

Sep 20, 2006

I'm trying to attach to a database that's stored in my D: partition on my disk. The disk has partitions C: D: E: F:

But when I choose "Attach", and open the requester to select the database-file, only drives C: and E: are shown.

All other programs lists the partitions right.

Where have D: and F: gone to ?

View 4 Replies View Related

Full Text Query

Aug 31, 2001

I have a problem with sql 7 full text query. Everything appears to be in place the database is enabled and the catalogue populated but a query like this
select * from risks_intercat WHERE CONTAINS(RISK_NOTES, ' "bean curd" ')
always returns this;
Search on full-text catalog 'ftc_Risks_ic' for database ID 8, table ID 329768232 with search condition ' "bean curd" ' failed with unknown result (8bcf8cc).
has anybody got any ideas why?

View 1 Replies View Related

Creating Databases On Network Drives?

Jul 11, 2001

Is this possible? I seem to remember doing it with SQL Server 7 a long time ago. The Microsoft Knowledgebase says it's not possible with 4.2 through 6.5, but nothing about 7.0 and up.

View 2 Replies View Related

EM Not Seeing All Drives In Cluster Shared Array

Sep 16, 2002

Environment: Windows Advanced Server with SP2. SQL 2K Enterprise edition with SP2.

There are three disk drives in my shared array named E:, F:, and H:.

When I use EM (Enterprise Manager) to create a job (like a backup job), the drop down box contains only drive F:.

Drive F: was the drive specified during the install process for data files.

Drive C: and D: also exist. Drive D: was specified during the install process for the program files.

It seems to me that drop down boxes in EM which show disk drives should actually show me the following drives: C:, D:, E:, F:, and H:.

Any ideas why EM may not be showing all the disk drives.

TIA solart

View 2 Replies View Related

Maintenance Plan With Maped Drives

Feb 12, 2003

hi all
we have some servers connected in the same LAN, most of them with sql server. our production database is on a server with some several mapped drives (network drives). we have a maintenance plan which makes a database backup on one of this mapped drives, and also we make a backup of the transaction logs in another mapped drive.

recently we install another sql server on a new server and we are trying to create a maintenance plan in the same way as our production server. so we are trying to make backups in mapped drives. the server options are the same but the new server don't recognize the mapped drives...

is there an option or something that makes server recognize mapped drives or simply this server is not-well installed?

please, some ideas... :)
thanks & regards to all

View 2 Replies View Related

Problem With Xp_cmdshell ,BCP And Network Drives

Sep 27, 1999

Basically what I am trying to do is run bcp from within a stored procedure in SQL 6.5.
It allows me to dynamically assign the destination filename (the legacy application expects to see a file for each picking slip) I want to store the file on another server/shared directory on the LAN

Here is the code
DECLARE @ship_no varchar(16)
SELECT @ship_no = '1234567'
DECLARE @SQL_SYNT varchar(255)
SELECT @SQL_SYNT = "master.dbo.xp_cmdshell " + '"BCP AUSTCHAR..armaster out servernameBECpsqlout'+@ship_no+'.cba /c /t , /r /Sservername /Uuser /Ppassword"'

However I get the following output:

(1 row(s) affected)

(1 row(s) affected)

Bcp: Unable to open host data-file.

The destination file is not created.
I have tried:
making the path the local HDD that works:
Using a mapped drive, that does not work
Running the same bcp command from the command line. That works.
Using UNC's (as above) You can see the result.
I have also checked security and made SQLexecutive ran as the domain admin. Did not work.

Can Anyone help?

Thanking you in advance

View 1 Replies View Related

Advantages&&Disadvantages Logical Drives

Aug 5, 2005

Are they're any real disadvantages or advantages in having 1 massive disk partioned to create 2 logical drives (not including the C drive) and separating the SQL Database File & Transaction Log so that it doesnt reside on the same logical drive?

After all, it is still a single disk.


View 3 Replies View Related

Drives On Server And How To Define Raid For Them

Jan 25, 2008

Hello! I hope that I have posted in the right spot.
We are looking for advise. I know that there is no right or wrong answer. "It depends."

We currently have a server with the OS as Windows Server 2003 SP2 and SQL Server 2000 SP3. This Server has 6 physical drives; only 3 of these physical drives are being used. These 3 physical drives are 1 container with Raid 5. This 1 container is divided into 3 logical drives.

We would like to fill the other 3 physical drive slots and create another container. We were thinking of making this Raid 1.

I should put in my disclaimer that Raid 10 is out of the question and so is SAN.

Is Raid 1 the best choice? This is my first question.

Next is how should we split up the files among the containers.

For example, OS, log and swap file on container 1 with Raid 1 and datafiles on container 2 with Raid 5?

What are most people doing? Is there a standard? Can people provide examples of what they are doing or provide suggestions?

View 11 Replies View Related

SQL 2012 :: Getting Backups Off Local Drives

Dec 8, 2014

I have tried doing sql server backups to a file share and that has been taking too long. So I've decided to backup locally and then taking those backups and getting them off the server. For those that are doing this what do you use to get your backups off the server?

View 9 Replies View Related

Dedicated Data & Log Drives For Each SQL Instance?

May 17, 2007

For single instance installations I try to follow a standard configuration where our log files go to E, data files to F, tempdb to H and backups to G. With a new project we have decided to combine our Test and Dev environments on one server with Test being a default instance of SQL Server and Dev being a named instance. My plan was to stick with the above convention, but I was asked if it would be better for each instance to have dedicated data, log and tempdb drives. The problem is we would not have a dedicated controller for each drive. We would have one controller for the default and named instance data drives, one for the log drives and one for tempdb. The other issue is having to modify some of my admin scripts/procedures to work with different drive letters. That's now a real big deal, but does add more work to my plate.

Do you think it's worth having separate drives for a Test/QA server or is it typically sufficeint to use shared?

Thanks, Dave

View 7 Replies View Related

Installing Databases To Different Hard Drives.

Apr 24, 2006

Can't find anything on how to install to drives other than sys. I'm brand new to Servers and Databases in general and trying to learn. How do I get databases to install on drive partitions other than my main system drive?

View 5 Replies View Related

Writing To Network Drives From SQLServer

Apr 23, 2008

I am having difficulty getting both xp_cmdshell and the Scripting.FileSystem to work via sp_OACreate/sp_OAMethod with files residing on network drives . I am able to create/move/copy/delete files on local drives through both of these methods, but when I specify a network drive as the target an operation requiring write access I get an "Access is Denied" error. I recognize that the SQLServer service account is being used to perform these operations, and I have granted Full control permissions to this user on the directory I'm trying to perform the operation on. Is there some other permission either on the SQLServer or Windows account that is required to enable write access from T-SQL?

--Listing of network directory works fine:

EXEC xp_cmdshell 'dir \Gol-devftprootgolsolgolEngMaint';
Volume in drive \Gol-devftproot has no label.
Volume Serial Number is 5493-88CD
Directory of \Gol-devftprootgolsolgolEngMaint
04/23/2008 12:37 PM <DIR> .
04/23/2008 12:37 PM <DIR> ..
03/28/2008 01:56 PM <DIR> 40083388
04/23/2008 12:37 PM <DIR> 4008343A
04/23/2008 11:05 AM 230 4008343a.task
12/18/2007 12:15 PM <DIR> 4008CE92
04/23/2008 08:41 AM <DIR> 4008D108
04/22/2008 06:40 PM <DIR> 4008D134
04/21/2008 02:46 PM <DIR> 4008D15D
03/05/2008 10:14 PM <DIR> 4008D1BA
02/12/2008 04:41 PM <DIR> 4008D1FA
10/29/2007 11:06 PM <DIR> 4008D583
04/21/2008 02:41 PM <DIR> CMU
04/22/2008 02:25 PM 313 ESN_All.task
09/05/2007 11:22 AM <DIR> HotSpot
04/23/2008 07:25 AM <DIR> M4008CEC7
04/23/2008 07:56 AM <DIR> M4008D1BC
04/22/2008 05:24 PM <DIR> M4008D1CF
04/21/2008 02:43 PM <DIR> MEU3
04/21/2008 02:43 PM <DIR> Tools
2 File(s) 543 bytes
18 Dir(s) 25,083,801,600 bytes free

-- Local copy works fine...
EXEC xp_cmdshell 'COPY C:TestLoad4008D1FA4008D1FA.TASK C:Temp';
1 file(s) copied.

-- Copy to network drive fails
EXEC xp_cmdshell 'COPY C:TestLoad4008D1FA4008D1FA.TASK \Gol-devftprootgolsolgolEngMaint';

Access is denied.
0 file(s) copied.

View 8 Replies View Related

Model Database And Default Drives.

Feb 4, 2008

Every time a new database is created on my server,my log files and database files automatically default to the following to the C drive in the following path: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData. Is there a way to get them to default to different drives?

For example, right now I have my data files on our F Drive, which is a RAID 5 and my log files on our G Drive which is a RAID 1. Every time an out of the box application installs a database, it does so on the C Drive. I want data files to default to my F Drive and log files to default to my G drive? Is this possible?

View 3 Replies View Related

This Schema Prefix Drives Me Crazy...

Nov 16, 2006


I have created a new user in my database called "acm", I also created a new schema called "acm" as well, the "acm" user is its owner, and the default schema for "acm" user is the "acm" schema.

I also created a login called "acm" (surprise surprise) and set its default database to "mydb" database.

In "mydb" database I have a table "mytable" that is owned by "acm". In my connection string I am using "acm" as the user, but when I do:
"select * from mytable" I get error ("bla bla object bla bla"), when I use "acm" as a prefix for the table name it works fine... What do I miss??

My connection string is:

Data Source=.SQLEXPRESS;AttachDbFilename=&quot;C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataAccountManagerDb.mdf&quot;;Persist Security Info=True;User ID=acm;Password=acm;Connect Timeout=30;User Instance=False



View 7 Replies View Related

Full Text Commands In SQL Query?

Jul 2, 2007

My host does allow me to create full text catalogs. I use SQL Server Management Studio Express, so I'd have to do it "by hand" as opposed to point-clicking menus and going through wizards. Where do I go to find those commands? I've seen them before but I can't remember where to get them. They're the ones that begin with sp_.
I need the commands for:

Creating a full text catalog

View 4 Replies View Related

Full Text Query Problem

Jan 8, 2008

Is there something wrong with my query or my full text catalog? The first query returns data while the second one does not. Does it have something to do with it being a number? I can get the rows to return by searching on alpha text.

select * from gk_info
where info_desc like '%6416%'

select * from gk_info WHERE
CONTAINS (info_desc, '"6416"')

View 1 Replies View Related

SQL Query For Full-text Search!!!

Feb 8, 2008

I want to add the full text search feature into 2 columns of a table in my DB.What will be the query that I should execute.I have aalready the tables existing.So probably I need to ALTER alongwith the new functions!!


View 2 Replies View Related

Shrinking Transaction Logs And Placing On Different Drives

Oct 6, 2004

I am working on deploying my production DB's to a new server and am looking for some advice. The new server is running RAID-5 (the old one is RAID-0) but it only has one controller therefore I can not create another array group. So I was wondering since the disk setup is C: and D: (Virtual Drive) if I would see any benefits from placing my log files on C: and my Data files on D:?

The other question is related to the size of my log files. Some of the DB's were not created by me and there are no constraints in log file growth causing some very large TRANS logs. For example, there is a 100 MB DB with a 1 GB trans log. I restored the DB on my new server and truncated the log file (manually, the Ent Mgr Shrink DB tool doesn't work worth a hoot) to half the size of the DB and it functions properly. I was just wondering if this would cause any problems down the road if I did all of my DB's like this?

I am restricting log file growth to approximately half the size of the DB.

There is one DB that is 1.5 GB and the log file was set restricted to 2mb and it works fine, but I feel that I should bump this up a bit.

Any recommendations?

View 10 Replies View Related

Copyrights 2005-15 www.BigResource.com, All rights reserved