SQL Server, Disk Arrays And Disk IO

Is It Possible To Move My Sql 2000 Database (in C Disk) To Another Disk (Disk) ?
hello,all
          I am new to Sql 2000,I installed sql 2000 database in C disk,but Now I found my C disk space is smaller than before,So I want to move my databse(include data and structure)   from C Disk to D Disk(its space is very large) .
         is it possible to do it ? 
         if its can be done ,do I need to change my asp.net program source code (exp: chaneg my crystal  report connectstring ) ?
        thanks in advanced!
 
 
 
      

View Replies !

---

Migrating SQL Data From MSA1000 Disk Arrays To SAN In SQL 2000 Cluster.
 

Hello All,
 
I have a 2-node cluster environment & I am planning to replace it with new hardware. Currently I am using MSA1000 Disk arrays. Now I would like to move my storage to SAN.
 
What are the necessary pre-requisite and actions to do this. Any particular thing, I must take care in planning.
 
Any help would be appreciated.
 
Thanks
Dev

View Replies !

---

Calculating COUNTER Physical Disk: AVG. DISK QUEUE LENGTH
If I return the Average, Minimum, and Maximum values for the counter Physical Disk: Avg. Disk Queue Length, and those values are 10, 0, 87 respectively, which value do I use to compute the Avg. Disk Queue Length for a 4 disk array(RAID 10): Average, Minimum, or Maximum?  The disk(lun) is on a SAN. 
 

View Replies !

---

Should The Quorum Disk Be A Physical Disk Or Majority Node Set?
Hello,

   I am trying to setup a test cluster and am having an issue. When I try to create the resource of a physical disk it takes both the drive e: and drive q: and doesn't seperate them into two physical disks as resources. This means when I try to associate the quorum disk it links the to physcial disk resource of drive e and q. Then when I try to install SQL2k5 I get the warning about installing SQL on the quorum disk. Am I missing something? Is there a way to seperate e and q onto two physical disk resources so I can specifically associate the quorum to q and the sql to e or should I be setting the quorum disk to a majority node set? Thanks in advance.

John

 

View Replies !

---

Get Total Disk Size And Free Disk Space
-- Initialize Control Mechanism
DECLARE@Drive TINYINT,
@SQL VARCHAR(100)

SET@Drive = 97

-- Setup Staging Area
DECLARE@Drives TABLE
(
Drive CHAR(1),
Info VARCHAR(80)
)

WHILE @Drive <= 122
BEGIN
SET@SQL = 'EXEC XP_CMDSHELL ''fsutil volume diskfree ' + CHAR(@Drive) + ':'''

INSERT@Drives
(
Info
)
EXEC(@SQL)

UPDATE@Drives
SETDrive = CHAR(@Drive)
WHEREDrive IS NULL

SET@Drive = @Drive + 1
END

-- Show the expected output
SELECTDrive,
SUM(CASE WHEN Info LIKE 'Total # of bytes : %' THEN CAST(REPLACE(SUBSTRING(Info, 32, 48), CHAR(13), '') AS BIGINT) ELSE CAST(0 AS BIGINT) END) AS TotalBytes,
SUM(CASE WHEN Info LIKE 'Total # of free bytes : %' THEN CAST(REPLACE(SUBSTRING(Info, 32, 48), CHAR(13), '') AS BIGINT) ELSE CAST(0 AS BIGINT) END) AS FreeBytes,
SUM(CASE WHEN Info LIKE 'Total # of avail free bytes : %' THEN CAST(REPLACE(SUBSTRING(Info, 32, 48), CHAR(13), '') AS BIGINT) ELSE CAST(0 AS BIGINT) END) AS AvailFreeBytes
FROM(
SELECTDrive,
Info
FROM@Drives
WHEREInfo LIKE 'Total # of %'
) AS d
GROUP BYDrive
ORDER BYDrive

E 12°55'05.25"
N 56°04'39.16"

View Replies !

---

Disk Crash Of Disk That Contains The Paging File.
Hello,

this is my configuration :

1) 3 disks in RAID5 that hold the SQL data
2) 1 disk in RAID0 that holds the only paging file.

What will happen to the SQL data (DB) when the disk that holds the paging file crashes?

Kindest regards,
Luc.

View Replies !

---

Disk To Disk Backups
Does anybody know exactly what happens within the SQL Server engine when backups are done? Specifically is tempdb used as a 'staging post' to write data to before it is written out to the backup directory?
The reason I ask is that during weekend, full database backups one of the stripe sets in my RAID array (there are 8 in total) is being hit VERY hard. I am trying to identify what is happening, hence the question.

If anyone has any thoughts or suggestions they would be gratefully accepted.
Jonathan

View Replies !

---

Is There A SQL Server API To Flush All Buffers To Disk?
I am looking for an API to flush all data in memory held by SQL Serverto disk. Also, is there a tool for SQL Server like eseutil forExchange that lets you correct a SQL database?

View Replies !

---

SQL Server SQLMAINT And Disk Space
Hi,
I have a 250 GB database and not much space left on the disk drive. I want to run SQLMAINT to do optimization and integrity checks on this db. My question is : How much work space does SQLMAINT need to perform these tasks?.
Thanks in advance for your help.
F.

View Replies !

---

Move Transaction Log To Another Disk (on Same Server)
I'm trying to find the easiest (and quickest) way to move the log device and files from one disk to another on the same server. They are small dbs. Is it simplest to dump the database, delete, recreate to new locatioN? I found the attach and dettach in SQL7.0 would work - but we are running SQL6.5 SP4.
any ideas would be helpful - thanks in advance

View Replies !

---

Optimized SQL Server Disk Configuration
I have a question concerning where to put certain database files for the followinig RAID configurations.  The server has 2 RAID configs: 2 hds in a RAID 1 and 4 hds in a RAID 10.  The server will host 4 database instances:  A replicated db, a Reporting Services db (which technically constitutes 2 db instances) and an application db.
In order to get the best performance, should I put the OS, SQL binary and log files on the RAID 1 config with the data and tempdb on the RAID 10?  If not, please explain the best solution.  Thank you!

View Replies !

---

SQL Server Error Log Fills Disk
Hello,

 

I have the following problem:

 

I'am running SQL Server 2005 Express Advanced Services on a Windows 2003 Server in a hosted Environment. Some times SQL Server is beginning writing entries into C:ProgrammeMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG until the disk is full.. After that, I have to delete the error log file (some GB of size), restart the server and everything is running fine until the log file runs amok again.

 

I have installed SQL Server Management Studio.

 

With SQL server 2005 Standard I can configure or disable Error logging in the Management Studio. But with the Express Edition it seems that is not possible.

 

What I want to do is (maybe with system stored procedures)

limit number of error log files by cycling it, e.g. 5 files and delete the old ones
limit the size of one log file. e.g. 100 MB

Is there an option to configure this in the Express edition of SQL Server 2005?

 

Thanks in advance

 

Regards

 

Rolf

View Replies !

---

Moving Data Files To A New Disk, Same Server
Hello, I have been having a bit of trouble finding help on the safestway to move data files to a different disk on the same server. Mosthelp is about moving data files to a different sqlserver. I just wantto move the files to a different drive on the same server. Any helpwould be appreciated.Thanks,David

View Replies !

---

Extracting Images To Disk From Community Server
I posted this question in the Community Server forums, but thought I would try here as well...
 
I am trying to use SQL Integration Services (SSIS) to dump out the images from Community Server and I'm getting zero length files. Here's what I'm trying....
 
I have a Data Flow Task with an OLEDB Data Source with this query (The TOP is for testing purposes) :
 
SELECT     Top 10 cs_Posts.Body, cs_Posts.PostDate, cs_PostAttachments.FileName, cs_PostAttachments.[Content], cs_PostAttachments.ContentType,
                      cs_PostAttachments.ContentSize, cs_Post_Categories.Name
FROM         cs_Posts INNER JOIN
                      cs_PostAttachments ON cs_Posts.PostID = cs_PostAttachments.PostID INNER JOIN
                      cs_Posts_InCategories ON cs_Posts.PostID = cs_Posts_InCategories.PostID INNER JOIN
                      cs_Post_Categories ON cs_Posts_InCategories.CategoryID = cs_Post_Categories.CategoryID
WHERE     (cs_Posts.ApplicationPostType = 64)
 
Then I have an Export Column Transformation set to export cs_PostAttachments.[Content] with cs_PostAttachments.FileName as well the file name. Ultimately I'm going to break the filepath all down into folders by the category name, but for now I'm just trying to get the export working.
 
Anyway when I run it I end up with files with the right names, but they are all zero length files.
 
Any ideas?
 
Thanks,
-p

View Replies !

---

Identifying The Remote SQL Server Disk Space?
 

How do we identify the total disk space of a SQL Server Remotely. The procedure xp_fixeddrives gives the available free space .. but I would like to know the total disk capacity .. Any pointers?
 
Thanks,
Deepti

View Replies !

---

SQL Server Developer Edition From A Disk Image
Hi all,

I have a rookie question.  I'm setting up PCs for a team of developers - all of whom will have the same hardware and software setup.  I'd like to just install everything on one PC, then make an image of the PC to apply to the others.  I will be installing SQL Server 2005, Developer Edition.  From a SQL Server installation perspective, what special considerations will I need to make to get this going? 

Any suggestions or links to online documentation would be greatly appreciated. 

Thanks,

John

View Replies !

---

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.

View Replies !

---

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

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

---

Installation Of SQL Server 2005 On The Partition Disk Drive
Trying to install SQL Server 2005 beta version on partition disk drive sayF: (Other than local disk drive c:),Does anyone know how can I do this? During the installation, it never asksme on which drive it install to nor browse button is there to browse thedisk drive for installation...Any help???ThanksJ.

View Replies !

---

SQL Server Disk Sub-system (overhaul) Performance Questions
I 'inherited' a group of SQL Server server class machines. They aretrue server technology but the disk sub-systems are lacking. There isone hot-swap backplane that all the drives share (with one SCSIchannel) thusly even though there are three logical drives (composedfrom 6 to 8 hard drives), they all go through one channel. This iscreating a performance issue that is noticable and can be seen invarious performance counters that Microsoft recommended one shouldmonitor in terms of disk I/O. For a cheaper 'fix', I can add aseperate two drive bay (with its own SCSI channel) with mirroreddrives. I would then mostly likely place the transaction log files onthis new channel. Or I could place the indices filegroup files onthis new channel for DBs with mainly searching going on (not muchupdating). If I went this route I would be leaning towards thetransaction log move since the second method would require me movingDBs around quite a bit. Any input on this solution (besides spendingmore money)?What I would prefer to do is get a better server class machine or addan external drive bay solution (not a SAN). I would try to get threeor four SCSI channels in the new hardware to split the differentfile/filegroups out (i.e. transaction logs files, data filegroup,indices filegroup, etc.). My only concern here is: would this moreexpensive solution be worth the money? As far as replacing servers, Ihave only two kinds of experience...replacing somewhat underpoweredservers with slightly less underpowered servers and replacing overkillservers with even more overkill servers. In both cases, the disksub-systems were fairly equivalent from the old system to the new one.Will going the three/four channel route really get data moving along?We have one server in particular that hosts a database (one of many onit) for a web application that gets decent traffic (it is a privatelogin based system for internal use and external use by our clients'agents). Periodically throughout the day, there are 2-5 minute burstswhere performance slows to a crawl. I want to spend more timeprofiling queries and such before recommending we spend more money,but the folks I am working for want quick results and there is quite abit of stored procedure logic to profile and investigate. I know thedisk sub-system is definately in need of an overhaul, but I would liketo get an idea of peformance gains from adding either one additionalchannel over the existing single channel as well as going thethree/four channel route over the existing single channel setup.Any information would be greatly appreciated.Regards,Tony

View Replies !

---

IIS Server Hang After Error-checking On Hard Disk
I have MSSQL 2000 and IIS 5.0 running on a Microsoft 2000 SBS, and anytime after performing error-checking on the hard disk and server restart, the IIS server was hang, require to shut it down and restart it.

Could anyone tells why it would happened and any solution that can solve or prevent to happen again?

View Replies !

---

Sharing Hard Disk On Multiple SQL Server Instances
 

I have a situation where I would like to set up one DB server instance for US and anther one for AUStralia. The Instance should share the same data base/hardsisk. One of the instances will be running in using US time zone and anothe one in Australia time zone.
There will be 2 Application instaces one poinint to each SQL Server instance. This applications does write into the database
 
So the underlying requirment is to have 2 database server running in differnet time zones but accessing the same disk/set of data
What is the best way to do this? Is it linked servers?Girish

View Replies !

---

SQL Server Freezes : Consumes High Disk Space
Hi,

The SQL Server Database hangs overnight and also consumes high disk space on one of our servers. This has been recurring for quite a few weeks and occurs daily.

Can somebody assist me in trouble-shooting the same

Thanks in Advance
Deepak

View Replies !

---

Required Free Disk Space For SQL Server Backup Operations
What is the percentage of FREE disk space that is needed for a backup?  I have backups that are failing with no disk space errors.  But there is enough disk.  Does SQL Server need a percentage of free space all the time?
 
Thanks
 
geri

View Replies !

---

Operations Manager Server 2007 With SQL Server 2005 Technology Disk
I am getting ready to install Operations Manager 2007. I have two sets of installation disks. 

One disk is labeled MS System Center Ops Manager Server 2007 with SQL Server 2005 Technology and the other says MS System Center Ops Manager Server 2007 with SQL Server 2005 Technology (SQL Server 2005 Standard Edition - Disc 1)

Does anyone know the difference in the two?  I was curious if the first one was MSDE?

Thanks!

Martha

View Replies !

---

Sql Server Express 2005 9.0.2047 - Problem RESTORE VERIFYONLY FROM DISK
Hi all

every time I try to verify the backup file I get the error:

backup set on file '1' is not valid (translated from italian).

this is my backup script:

BACKUP DATABASE [ahr_sistema] TO DISK = N'C:ProgrammiMicrosoft SQL ServerMSSQL.1MSSQLBackupahr_sistemaahr_sistema_backup_1.bak' WITH FORMAT, INIT, NAME = N'ahr_sistema-Completo Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10

GO

declare @backupSetId as int

select @backupSetId = position from msdb..backupset where database_name=N'ahr_sistema' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N'ahr_sistema' )

if @backupSetId is null begin raiserror(N'Verifica non riuscita. Impossibile trovare le informazioni di backup per il database ''ahr_sistema''.', 16, 1) end

RESTORE VERIFYONLY FROM DISK = N'C:ProgrammiMicrosoft SQL ServerMSSQL.1MSSQLBackupahr_sistemaahr_sistema_backup_1.bak' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND

GO

View Replies !

---

Receiving An Error Message That There Is Not Sufficient Disk Apce To Intall SQL Server (but There Is)
I downloaded this program, and when trying to intall I am receiving an error meesage that there is insufficient disk space to install.
 
I have 98GB available on C and 107 GB available on D.  I am on an IBM Intellistation dual processor 3,08 Ghz with 4GB RAM and 240 GB Disk (those are "G"'s), so I have tons of capacity.  This has to be a problem with the .msi - any suggestions?

View Replies !

---

DIsk Quotas
Hello,I am investigating setting up a shared sql server. I wish to enforcedatabase size quotas, and hopefully still allow customers to managethe creation of their own databases.Any thoughts or suggestions would be appreciated.Kind RegardsSimon Hall

View Replies !

---

Low Disk Space On C:
I noticed something strange today. I was running a query using query analyzer on a large database (8.8 million records) and the disk space on the c: drive was dropping and eventually went to 0. Availalbe space on the c: drive is 10GB. The query did complete. SQL server and all the databases are on the d: drive. After closing the query results in query analyzer the disk space returned. Is this a concern and is there a way to change it to use the d: for whatever it is doing?

View Replies !

---

Disk Fragmentation
What's the best way to find out if disk fragmentation on Windows 2000 Server is affecting SQL Server performance?

If disk fragmentation is shown to be a cause of performance problems, what are the recommendations for a disk fragmentation strategy? eg. use the win 2000 built in disk defrag utility or buy a 3rd party product like DiskKeeper? How much of an overhead is a product like DiskKeeper that defrags in the background?

Clive

View Replies !

---

Disk Full.
Hi all,
I have a problem...
I use SQL server 2000,all the disk on computer is used to store data file and transaction log file, and now they are full so data can be insert or update because the data file and transaction log file can be add more or increase, please show me.
Best regard,

View Replies !

---

No Place On Disk
I have one big db and i heve no place on disk
the log file is big too. how can i delete the log

View Replies !

---

SQL 6.5 And Disk Cloning
We need a drive cloning app, like Ghost, that will allow us to transfer a production image off of a HDD to other PCs. The problem with this is that
our production needs SQL in order to run and transferring the initial image to uniquely named workstations causes DB registration problems. Is there
an app that will allow us to configure this transferred image so that SQL will refer to the "new" drive instead in of the "old"?

View Replies !

---

DB Disk Space
In a fast growing OLTP database, disk space is critical. What, if any is the connection between the unallocated and unused space fields in sp_spaceused proceedure? Can unused table space really be reclaimed by the general database?

View Replies !

---

Disk Keeper
Dear All,
How are you?
NT 4.0 with Service Pack 5, SQL 6.5 with service pack SP5A.

Should I run Disk Keeper after stopping the SQL services for Disk Defragmentation?
You know the data always is important. Please correct me if I am wrong:

"We can't even copy or compress the SQL DAT files while the SQL services are running."

Thanks in Advance!!!!!!!

Kind Regards
SaDaT

View Replies !

---

High Disk I/o
Hello,

We are experiencing high disk i/o on one of our RAID disk systems. Can someone tell me how I can identify the query or user or process which is causing this high disk i/o?

Thanks,
Brent.

View Replies !

---

Disk Space
Does anyone know how to get the free disk space for all drives in many different SQL servers.

I need to populate a report (right now output in Excel) with the free disk space of all drives on all of my SQL servers.

I found xp_fixeddrives but that is specific for the server where it is executed.

Any help or pointers to a script in the archives is much appreciated.

Thanks.

View Replies !

---

Disk Fragmentation && SQL
One of my production servers has been determined to be 92% fragmented.

What's the proper procedure for defraging a database server?

I couldn't find anything very helpful in BOL, nor Knowledge Base.

Sidney Ives
Database Administrator
Sentara Healthcare

View Replies !

---

Disk Space
Hello
I need to setup a compaq sever with 300 MB database, and will be adding around 600 records on a daily basis. Can someone help with how much disk space i should have on sqlserver, providing i have c: and d: setup.

Thank you in advance for all the help.
Paula

View Replies !

---

Disk Space
Hi All,

I have a server and it has C: D: F: I: Drives and all the system files are on C:Drive and and all the .MDF's and .LDF's(model,temp,master) are on the F: Drive and now I am running out of space on both(C: and F: Drives)

1. Can we add space to the C: and F: drives on the fly?.
2. Can I move the System databases ( MDF's and LDF's to some other drive)and if so, how do I do it?( Moving the databases ) and this is on the production database so when I have to do this.Will there be any impact.

Thanks in Advance,
Reddy

View Replies !

---

Move Log To Different Disk
We will move t-log from one disk to another one. I tried Alter Database and found it did not work for log.

Can somebody give me a method about moving log from different disks?

Thanks.

Jean

View Replies !

---

Quorum Disk Again.
Hi,

I'm trying to install a server cluster to implement an SQL Server 2005 cluster. No other services (I think this is important).

I've a dual SCSI channel Smart Array with 4 disks configured in a 400Gb RAID 5.

I do not need to move different resource groups from one node to the other, I need only one group with all the resources IP, Network name, MSDTC, and SQL Server..., when a node fails, all services should failover to the other node.

Is it possible to have only one physical disk (RAID 5) for Quorum disk and shared disk?

It would be the following configuration:

[Groups]
    Cluster Group
          IP Address
          Network Name
          Physical disk (used for quorum and shared storage)
          Distributed Transaction Coordinator
          SQL Server
          SQL Server Agent
          Generic Service (SQL Server Fulltext)

The other option would be having a 1 physical disk Raid 0 for Quorum (146Gb wasted) and another physical disk Raid 5 (3 disk) for Shared Storage, but this schema will have a a flaw point that if Quorum disk fails, the cluster fails....

Any help would be appreciate.

Best regards.

Ilde.

View Replies !

---

Normal Disk IO
I am wondering what normal disk I/O should be.
i know it verys depending on use but im looking for an average.

here is an idea of what we have

there is about 10 centers doing replication to our primary server.
we have about 80 users connecting directoy to our primary server using MS Dynamics through CITRIX.
we have a few other apps use the database as well however i am fairly certin its Dynamics generating our disk IO
Hardware wise we have a powerful blade connected to a raid 5 SAN with 15000 rpm disks.
normaly the disk IO stays fairly low but every so often it goes crazy and im thinking it shouldn't

Below is a sample of our disk IO from perfmon over 2 minutes or so. as you can see everything looks ok untill 04/15/2008 10:12:49.470 when the Disk I/O % goes above 100%

"04/15/2008 10:12:23.470","2.8300181121159178"
"04/15/2008 10:12:24.470","0"
"04/15/2008 10:12:25.470","3.950025280161793"
"04/15/2008 10:12:26.470","0"
"04/15/2008 10:12:27.470","0"
"04/15/2008 10:12:28.470","5.9800382722449426"
"04/15/2008 10:12:29.470","7.7400495363170325"
"04/15/2008 10:12:30.470","3.4500220801413128"
"04/15/2008 10:12:31.470","0"
"04/15/2008 10:12:32.470","4.180026752171214"
"04/15/2008 10:12:33.470","3.8600247041581071"
"04/15/2008 10:12:34.470","0"
"04/15/2008 10:12:35.470","142.71091334984544"
"04/15/2008 10:12:36.470","0"
"04/15/2008 10:12:37.470","1.1500073600471041"
"04/15/2008 10:12:38.470","0.81000518403317789"
"04/15/2008 10:12:39.470","0"
"04/15/2008 10:12:40.470","2.1400136960876548"
"04/15/2008 10:12:41.470","10.230065472419025"
"04/15/2008 10:12:42.470","4.5800293121875981"
"04/15/2008 10:12:43.470","0"
"04/15/2008 10:12:44.470","0"
"04/15/2008 10:12:45.470","14.500092800593926"
"04/15/2008 10:12:46.470","6.730043072275663"
"04/15/2008 10:12:47.470","1.6300104320667652"
"04/15/2008 10:12:48.470","7.3500470403010585"
"04/15/2008 10:12:49.470","264.66169383484055"
"04/15/2008 10:12:50.470","324.18207476527851"
"04/15/2008 10:12:51.470","536.17343150996169"
"04/15/2008 10:12:52.470","270.31172999507197"
"04/15/2008 10:12:53.470","331.97212462159757"
"04/15/2008 10:12:54.470","333.84213658967417"
"04/15/2008 10:12:55.470","435.57278766584108"
"04/15/2008 10:12:56.470","442.31283080211716"
"04/15/2008 10:12:57.470","685.92438991609549"
"04/15/2008 10:12:58.470","295.1618890360898"
"04/15/2008 10:12:59.470","61.470393410517829"
"04/15/2008 10:13:00.470","56.360360706308519"
"04/15/2008 10:13:01.470","45.260289665853861"
"04/15/2008 10:13:02.470","224.58143732119885"
"04/15/2008 10:13:03.470","1022.0365410338626"
"04/15/2008 10:13:04.470","1114.6271336136551"
"04/15/2008 10:13:05.470","241.52154573789269"
"04/15/2008 10:13:06.470","506.79324347675828"
"04/15/2008 10:13:07.470","374.88239924735518"
"04/15/2008 10:13:08.470","359.5723012627281"
"04/15/2008 10:13:09.485","427.62119831413077"
"04/15/2008 10:13:10.485","400.15256097639025"
"04/15/2008 10:13:11.485","1076.2868882360847"
"04/15/2008 10:13:12.485","325.94208602935055"
"04/15/2008 10:13:13.485","449.36287592240592"
"04/15/2008 10:13:14.485","344.28220340610181"
"04/15/2008 10:13:15.485","569.57364527132972"
"04/15/2008 10:13:16.485","775.02496015974498"
"04/15/2008 10:13:17.485","729.54466908588222"
"04/15/2008 10:13:18.485","778.70498371189581"
"04/15/2008 10:13:19.485","1080.1269128122422"
"04/15/2008 10:13:20.485","754.56482921490704"
"04/15/2008 10:13:21.485","999.11639434492372"
"04/15/2008 10:13:22.485","701.36448873272786"
"04/15/2008 10:13:23.485","276.26176807531567"
"04/15/2008 10:13:24.485","252.13161364232732"
"04/15/2008 10:13:25.485","533.27341294984296"
"04/15/2008 10:13:26.485","759.54486108711092"
"04/15/2008 10:13:27.485","817.11522953746908"
"04/15/2008 10:13:28.485","129.41082822930068"
"04/15/2008 10:13:29.485","158.94101722251023"
"04/15/2008 10:13:30.485","160.55102752657618"
"04/15/2008 10:13:31.485","655.87419759486454"
"04/15/2008 10:13:32.485","444.49284475420637"
"04/15/2008 10:13:33.485","272.47174381916045"
"04/15/2008 10:13:34.485","94.730606275880163"
"04/15/2008 10:13:35.485","355.28227380655238"
"04/15/2008 10:13:36.485","898.29574909279427"
"04/15/2008 10:13:37.485","1309.3783800216322"
"04/15/2008 10:13:38.485","88.200564483612695"
"04/15/2008 10:13:39.485","1.2300078720503811"
"04/15/2008 10:13:40.485","4.9400316162023437"
"04/15/2008 10:13:41.485","217.90139456892524"
"04/15/2008 10:13:42.485","373.26238887928884"
"04/15/2008 10:13:43.485","73.760472067021226"
"04/15/2008 10:13:44.485","1.4100090240577541"
"04/15/2008 10:13:45.485","34.960223745431975"
"04/15/2008 10:13:46.485","15.990102336654955"
"04/15/2008 10:13:47.485","63.580406914604247"
"04/15/2008 10:13:48.485","26.560169985087906"
"04/15/2008 10:13:49.485","11.150071360456707"
"04/15/2008 10:13:50.485","15.250097600624644"
"04/15/2008 10:13:51.485","17.010108864696736"
"04/15/2008 10:13:52.485","12.210078144500125"
"04/15/2008 10:13:53.485","95.650612163917842"
"04/15/2008 10:13:54.485","38.740247937586801"
"04/15/2008 10:13:55.485","5.6000358402293777"
"04/15/2008 10:13:56.485","1.6600106240679942"
"04/15/2008 10:13:57.485","19.590125376802412"
"04/15/2008 10:13:58.485","2.8100179841150981"
"04/15/2008 10:13:59.485","631.48404149786563"
"04/15/2008 10:14:00.485","579.14370651972172"
"04/15/2008 10:14:01.485","1.0600067840434177"
"04/15/2008 10:14:02.485","15.870101568650039"
"04/15/2008 10:14:03.485","112.28071859659903"
"04/15/2008 10:14:04.485","15.660100224641438"
"04/15/2008 10:14:05.485","4.9800318722039822"
"04/15/2008 10:14:06.485","25.44016281704203"
"04/15/2008 10:14:07.485","16.130103232660691"
"04/15/2008 10:14:08.485","5.9300379522428939"
"04/15/2008 10:14:09.485","4.8400309761982481"
"04/15/2008 10:14:10.485","2.6400168961081349"
"04/15/2008 10:14:11.485","19.430124352795858"
"04/15/2008 10:14:12.485","42.55027232174286"
"04/15/2008 10:14:13.485","37.550240321538055"
"04/15/2008 10:14:14.485","1.210007744049562"
"04/15/2008 10:14:15.485","15.930101952652498"
"04/15/2008 10:14:16.485","20.550131520841735"
"04/15/2008 10:14:17.485","4.0900261761675267"
"04/15/2008 10:14:18.485","8.0100512643280908"
"04/15/2008 10:14:19.485","1.6000102400655365"
"04/15/2008 10:14:20.485","2.3300149120954372"
"04/15/2008 10:14:21.485","1.6200103680663558"
"04/15/2008 10:14:22.485","10.730068672439504"
"04/15/2008 10:14:23.485","4.4600285441826832"
"04/15/2008 10:14:24.485","9.0300577923698704"
"04/15/2008 10:14:25.485","0"
"04/15/2008 10:14:26.485","15.550099520636932"
"04/15/2008 10:14:27.485","2.970019008121652"
"04/15/2008 10:14:28.485","64.580413314645213"
"04/15/2008 10:14:29.485","71.850459842942996"
"04/15/2008 10:14:30.485","53.220340610179903"
"04/15/2008 10:14:31.485","32.620208769336124"
"04/15/2008 10:14:32.485","1.0000064000409603"
"04/15/2008 10:14:33.485","4.8400309761982481"
"04/15/2008 10:14:34.485","8.2700529283387425"
"04/15/2008 10:14:35.485","11.160071424457115"

View Replies !

---

DTS Disk Space
This is my first attempt using SQL 2000 and DTS. I am importing an Access database using the DTS wizard. The process fails with a "Not enough space on temporary disk" error. There is definitely enough space on the physical disk. I don't have any limits on any folder sizes either. What "disk" is the error talking about, and how do I give it enough space. The database is relatively small, about 10MB. I believe the database was created using Access 97. Please help.

View Replies !

---