Need Help Approximating How Much Hard Drive Space I Need For My DB Table.

May 12, 2007

In our SQL Server database we will have a table that will be populated with about 2000 records
per day. That is 2000 records per day for 5 days per week. Currently the computer we are using has about  50 gigabytes
of available hard drive space on it. We are concerned that maybe we will need a bigger hard drive,
based solely on the number of records entered into this table per day. The problem is I don't
know how to calculate how much hard drive space we need. I think I read that using varchar,
sql server 2005 really optimizes a database. Here is a typical example of data in our
database. I put dots on three lines between the first and last sample record to just
illustrate that there are many records in between.

Basically we only need 8 months of data at a time in the table and then we can purge
records older than 8 months.
Can someone help me approximate how much hard drive space I might need for 8 months of data,
given the following sample record in the database?

Sample: -->34.5               4.08        10.6       .0012


Sample Table in my DB just for illustration:

(PPsquare inch)  (Diameter)  (Weight gm)     (coeffOfSatFriction)

34.5                      4.08            10.6                .0012
.
.
.
21.7               3.54        6.22         .019

View 4 Replies


ADVERTISEMENT

Copying Sql Table To Computer Hard Drive

Nov 26, 2007

Hi,
 
I use sql server management express. I have created a table on my hosts remote database and i want to copy the table (or the data) in some format or other to my hard drive. does anyone have any good ideas how i may do this either through management express or other means.
thanks a lot
nick

View 2 Replies View Related

Read Binary Data From Table And Save On Hard Drive

Oct 18, 2007

Hi all,
I have one table with a column of type 'image'. There are manytypes of files saved in that column (i.e. .Doc,Xls,Pdf,jpg,gif etc.). What I want is, read that files from database and save it in temp folder on d drive of server. Can anyone help me in my problem?
Thanx in advance

View 1 Replies View Related

Reconfigure NT Hard Drive

Nov 14, 2000

hi, I have NT server which has drive c: 500 MB and drive d has 44 GB.

I know that the person who set up this server did not give enough space to the c drive, here is the problem. I am running sql server 7.0 which has 30 GB of data in the d drive. I need to reconfigure the NT hard drive so I can allocate 2 GB for C drive and 42 GB for D drive.


What is the best, safe method to accomplish this task.

Ahmed

View 3 Replies View Related

Hard Drive Failure

Sep 27, 1999

After experiencing a hard drive failure i have reinstaled MSSQL7 on one drive and have a database which I need to recover on separate physical drive. How can I go about doing this?

View 1 Replies View Related

Hard Drive Status

Jul 17, 2003

Hi,
I have ran
1. xp_fixeddrives and got the result
drive MB free
----- -----------
C 1708
D 16311
2. I ran Backup Wizard in EM and able to see only above drives

3. But if ran backup in EM able to see more than 10 Drives(like C,D,H,I,J,M,N and etc).
Why I can able to see those difference?.
How do I find out exactly how many drives are there in this server without directly going to that server?.
I appreciated your valuable answere.
Thanks,
Ravi

View 8 Replies View Related

The Hard Drive Configuration

Apr 7, 2004

Hello, everyone:

Does any one have an idea for hard drive configuration on SQL Server 2K? How to determine the RAID level for datafile and log file? Thanks

ZYT

View 2 Replies View Related

Formatting The Hard Drive

May 18, 2004

I was wondering if anyone played around with changing the allocation unit size when formatting the hard drive the SQL server is running on. I would think that setting it higher to account for the larger size of the database files would help, but I'm not sure.

Anyone have any thoughts?

View 3 Replies View Related

Hard Drive Setup Question

Feb 2, 2007

Hi guys,

I have a general question. Would SQL server have slower performance if you placed the ldf or mdf files on a dynamic drive setup or should it always be basic? I noticed that a server had 2 dynamic drives and the log files and mdf files are located on these drives. Usually I see all the drives as basic not dynamic. Does this even matter?

thanks

View 1 Replies View Related

Backup To Non-local Hard Drive

Oct 19, 1998

I want to perform backups to a network drive. I need to know if I can access the backup drive via UNC. I have not been able to get it to work and, for now, I would just like to know if what I am trying to do SHOULD work.

For example I want to backup to device mdtnts_prod02LM2BackupNameBack.DAT.

Thanks,Bob

View 1 Replies View Related

Hard Drive Defragmentation Opinions

May 9, 2008

I'm wondering what other people do in regards to running hard drive defragmentation programs on SQL Server 2005 servers (assume 64-bit and Windows 2003). From what I can tell the most common opinions are:

1. Don't defragment because it doesn't help and it can cause problems.
2. Use Diskeeper
3. Use the built-in Windows defragmenter

Other respected defragmented programs are PerfectDisk, O&O Defrag, JkDefrag, and Contig.

What is your hard drive defragmentation strategy?

View 1 Replies View Related

Hard Drive Trashing After SP2 + KB934458

Apr 5, 2007

Hi. Has anyone else had any problem with their SQL Server 2005 going nuts after installing the SP2 + the above hotfix?

We reboot the SQL Server and as soon as SQL receives a command of any sort, the SCSI RAID 5 hard drives light up and start trashing. Therefore every query and even Windows response time is painfully slow or fails to respond. When we look at the Activity Monitor and sp_who2 there is a process running a Select Into from Microsoft SQL Server Management Studio using the sa account from the last database name in our system. So we can't kill the process as it says "Cannot use KILL to kill your own process. Microsoft SQL Server, Error: 6104)".

The last Transact-SQL command from this process is:
create table #tmpDBCCinputbuffer ((Event Type) nvarchar(512),
[Parameters] int, [Event Info] nvarchar(512))
insert into #tmpDBCCinputbuffer exec ('DBCC INPUTBUFFER(56)')
select [Event Info] from #tmpDBCCinputbuffer

The only other issue I should mention is that we had to uninstall and reinstall SQL Server yesterday as SP2 only half installed. The SP2 install log indicated that SQL SP1 wasn't in a good state as we previously (3 months ago) performed an upgrade from Windows 2000 Server to Windows 2003 R2 Server.

Our other 3 Windows 2003 R2 Servers which were a clean install of both Windows and SQL are running fine.

I've been insisting that we do a new clean Windows and SQL install, but the other team members insist that it's been fine until we installed SQL Server SP2.

So can anyone provide and help or evidence to say who is right either way?

Thanks.

View 3 Replies View Related

Help SQL Server 7 Dump Data To Hard Drive

Feb 20, 2004

Hi,

I am running sql server 7 with 200+GB database size. I have one table with following fields

IIINDEX
DOCTYPE
IMAGE BLOB

I need to dump all the information from this table to hard drive.

I have try with delphi ado and delphi odbc (limit 1mb), somehow when I run the program it gives me an error message E_ timeout.

How can I dump this information without using delphi.

Any help will be highly appreciated.

If you have any code that can help please email me samirp@ix.netcom.com

Thanks.

Samir

View 1 Replies View Related

How To Recover SQL Database From A Removed Laptop Hard Drive?

Jul 23, 2005

Dear group:I have removed my hard drive from my laptop (which is now toast) andhave managed to recover nearly all the data from it by installing thedrive into my desktop. I was hoping to reboot the dektop to see if Icould load the operating system on the laptop's hard drive so I coulddo a manual backup of the SQL database on it. This does not work.Does anyone know of a way to recover my SQL database and all its tablesgiven the circumstances above?TIAISZ

View 5 Replies View Related

With New Hard Drive- Error 3: The System Cannot Find The Specified Path

May 5, 2006

Installed SQL Server 2000 Enterprise trial a week ago on XP Pro. Installed new Seagate 80G HD; used Seagate's utility to copy old C: to new drive as new boot drive. All seems to work fine, except, when booting up, SQL server doesn't start. When I try to start it manually I get the following:

Could not start SQLSERVER service on the local computer. Error 3: the system cannot find the specified path.

1. What could be wrong?

2. How do I fix it?

View 9 Replies View Related

Hard Drive Crashed. Master && User Db Mdf && Ldf Files Lost

Jan 31, 2006

Hello.

One of our hard drives has crashed and as a result we have lost our master mdf/ldf & user db mdf/ldf files. It's not that a critical system by any means, but if the hard drive crashes and the master mdf/ldf files & user db mdf/ldf are lost, is there any way of restoring the system?

I'm thinking we probably need to re-install Enterprise Manager completely, and re-install the user db from a backup.

Any advice/suggestions would be much appreciated.

Thanks in advance,

View 1 Replies View Related

Installing Sql 2005 Management Studio Express On 2nd Hard Drive

Apr 25, 2006

Hi,

I've downloaded the sql server 2005 management studio express executable to my second hard drive, as there is no room on my main drive

However, when I try to install, the program shows me both drives, and shows that there is not enough room on my main drive, but it does not allow me to change the installation to my second drive.

I have previously installed the main sql express product to my second drive with visual studio. There's loads of room.

Can anyone give me a clue as to why this might be happening.

Thanks

John

View 1 Replies View Related

Need To Create And Access A SQL Server Database That Will Reside On An External Hard Drive.

Apr 9, 2007

 
 I need to create a SQL server database and add some tables to it. Then access it with a C# application. The problem is that the new SQL server database and it's tables must reside on an external hard drive. How do I point SQL server to this external drive, so that I can create a database on this drive and then create tables and access data on it?
 
 

View 7 Replies View Related

Know The Hard Disk's SQL Server Space Available From SQL Query

Oct 5, 2007



I would be able to determine how much hard disk space is available on the Server with a SQL Query, and from an other computer on the LAN.

How can I do something?

Thanks for your help.

View 4 Replies View Related

Drive Space Getting Increase

Apr 29, 2014

Am using Windows Server 2008R2,In this Server C:/ drive space is getting increase day by day as per my knowledge i have to format that system.If is there any other chances to get space and remove unwanted things from my Server.

View 7 Replies View Related

Space Issue On Drive

Dec 26, 2007

I got a space issue on F drive
Total drive capacity 581 GB
Now free space is 4.4 GB ONLY
F:MSSQLDATA..NDF---163072128(163 GB)
F:MSSQLDATA...MDF--441785344(441 GB)
I am trying to shrink the database to get some free space on F: drive but "USSVC_LADadmin" is executing delete statement on this database. so I could not perform any activity at this time
Please suggest how to proceed further?

View 4 Replies View Related

Can I Find The Drive Space Using A SQL Query?

Jun 1, 2001

Hey - I know that I can find space information about SQL Server. Allocated space, free space, used space, data space, etc... BUT is there a way that I can query how much total/available space is on the actual drive? For example, let's say that I have SQL installed on the D drive of a Server; i also have another application on that drive. I know that I can query how much room SQL Server is using, but can i query how much total/available space is on the drive? Any help appreciated.

View 1 Replies View Related

Reclaiming Space On Windows Drive

Nov 27, 2012

I'm running a security application that generates a lot of events. I have gone in over the past couple days and deleted large numbers of old events in an effort to reclaim space on the D: drive where the SQL DB for this app resides. I did this throught the app itself... through its GUI front end.

I'm not having any impact. There is not a file on the same drive where the deleted events are being directed to. If all these events are going away, why does my used space on the drive not shrink? I came at it from another tack, creating sql queries to delete old events from the same app. I did this through queries in the SQL mgmt studio. The tasks (multiple) completed successfully, and the report on the # of rows 'affected' showed that it was a substantial number. No decrease in the windows drive space being used. Any tips?

View 1 Replies View Related

SQL 2005 Drive Space Issues

Apr 4, 2008

I have a SQL 2005 server I am working on for a client and the issue is this. The original install was put on the servers c: partition. When they ran out of space they moved all of the databases to a different drive. They still run into problems when they run maintenance plans. Half of them fail as drive c: runs out of space.

Is there a temp directory or file that needs to be moved and if so how do I do this? Do SQL system databases grow when a maintenance plan is run? Do the system databases need to be moved as well? I assume that these changes will require down time but I would like to avoid that if possible.

I am new to SQL and I have looked everywhere but have found no solutions. I would think there must be a temp directory where data is stored during the job.

Any help would be appreciated. Thanks.

Steve

View 2 Replies View Related

Install Error - Not Enough Space On Drive C

Jun 11, 2008

Hello Everyone,

I wasn't able to find the answer to my question by searching the forum. I would very much appreciate if anyone would help me.

I need to install the SQL Server Workgroup trial. I wasn't able to find the workgroup trial so I was trying to install the enterprise instead. (If anyone knows how to get ahold of the workgroup trial that would be a help too)

I keep getting the following error when running the SQLEval.exe:

There is not enough space on drive C: to extract this package

I did an internet search on this error and it seems there is a bug that requires the amount of free space not be a multiple of 4. I currently have 13.2 GB free space and I have tried adding and removing files, to no avail. I have tried downloading the file in a few different versions in case the file was corrupted, and rebooting etc, but still I keep getting the same message. I only have one drive!!!

Can anyone help me with this?

View 8 Replies View Related

Log File Too Big To Restore Not Enough Drive Space. Now What?

Mar 5, 2008

Hello all

as indicated by my stupid question, I am very new to sql. our vrsion is 2000 and I'm talking about in enterprise manager, the database that was created is not showing up in the list of db. Although I can see the file in explorer.


The problem I€™m having is when I try to attach the database €œmailarchive3Q2007_data.mdf€? it is also looking for the log file €œmailarchive3Q2007_log.ldf€? . The log file was removed by someone else off our system. I have a backup of the file but it is too large to restore now (160 gig) when the system was first set up the recovery model was not set to simple so the log just grew till it filled up our drive. I no longer have the drive space necessary to restore the log file and shrink it. So what do I do now? I need some kind of €œmailarchive3Q2007_log.ldf€? file to attach the database in enterprise manager.

Hope sombody can help.

thanks

Mike

View 6 Replies View Related

Space Problem On SQL Server Install Drive (was Question???)

Jan 12, 2005

On the drive that SQL server is install on which is the C drive the amount of space is 495mb, can the amount of space be a potential problem, I am so used to looking at the drives that contains the data and log files and the backup.

So My question is should I also concern myself with the drive the sql server itself is installed on?

Thanks

Lystra

View 5 Replies View Related

LOG Fills All Drive Space In Simple Recovery Mode

Dec 21, 2007



I am amazed to see this morning that log file consuming whole disk space even though the database is in simple recovery mode.

What could be the reasons to fill in the space even in simple recovery mode??

View 10 Replies View Related

DB Design :: Clear Space On The Drive - Shrinking Log Files

May 26, 2015

I have a database which has log file size 300 GB. As the drive is filling up i need to clear the space on the drive, for that i have to shrink the log file. 

Unfortunately i dont have option to take backup of the database.And i am not able to shrink the file now. Is there any way to shrink the log file with out taking backup of it ?

View 5 Replies View Related

Transact SQL :: Query To Return Free Space From Mounted Drive

Nov 25, 2015

Is it possible to find out available free space from a mounted / network drive using tsql query? I am using sql server 2008 R2.

View 5 Replies View Related

Approximating Numbers Using Sql

Jan 18, 2008

Hi All,

Is there a ready function in sql that approximate float numbers to the nearest tenth or hundredth?

Thanks

View 1 Replies View Related

Insert Data Into A Table From Two Tables Into A Single Table Along With A Hard Coded Value?

Feb 9, 2012

I'm trying to insert data into a table from two tables into a single table along with a hard coded value.

insert into TABLE1
(THING,PERSONORGROUP,ACCESSRIGHTS)
VALUES
((select SYSTEM_ID from TABLE2 where
AUTHOR IN (select SYSTEM_ID from TABLE2 where USER_ID
=('USER1'))),(select SYSTEM_ID from TABLE2 where USER_ID
=('USER2')),255)

I get the following-

Msg 512, Level 16, State 1, Line 1

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

The statement has been terminated.

Do I need to use a cursor?

View 5 Replies View Related

Hard Coding Colum Names In Returned DetailsView Table

Apr 13, 2007

Hi all,We're selecting data from our database, FirstName, LastName, MobileNumber etc.We're using the detaials view function to return it in a table upon selection. However all of the variables are returned as they are in the database, ie: without spaces. We tried putting in spaces by selecting "AS what ever", but MSSQL does not seem to like spaces.Any ideas?Thanks 

View 2 Replies View Related







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