Is It Possible To Move My Sql 2000 Database (in C Disk) To Another Disk (Disk) ?

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 !

---

SQL Server, Disk Arrays And Disk IO
Hi all,

Ok here goes,

I have a three tier system using SQL server 2000, we are currently experiencing IO bottle necks on our SCSI Raid 10 array, which holds the Data and the logs in separate partitions.

So my options as I understand it are:

Get Enterprise edition

or

Get another physical raid 10 array and separate the logs and data i.e. data on one array and logs on the other array.


I would like to try the latter but I am totally unsure how much difference this will make or whether it will make any difference at all.

Does anyone know how much performance increase I will get from using two arrays as opposed to one?


Any other advice on this scenario would be greatly appreciated.


Thanks

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 !

---

Tempdb: How Can I Move To Another Disk ?
I want to move the tempdb SQLServer database from the default install location (c:program filesMicrosoft...)
to d:mydb

How can I do that ?

View Replies !

---

How To Move Distribution DB To Another Disk (Replication)
Somebody now what is the correct process to move the Distribution BD to another Disk with out affect the defined replication

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 !

---

Move Log File To Another Physical Disk
Hi everyone,

Due to running out of disk space and reducing I/O contention, I plan to seperate data files and log files to different disk arrays.

My plan is to
- detach all databases
- copy log files to another disk
- attach all databases

The total size of log files is about 60GB. It becomes a problem becasue it spend too much time passing files. To reduce down time, is there any way I can do?

Can I just create new log files and remove the current files by using sql management studio?

any other suggestions? Thanks in advance

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 !

---

Recover A Database From Another Hard Disk With A Corrupted Windows 2000 Installation.
Hello,I am trying to recover a SQL Server 7 database from another hard diskdrive that has a corrupted Windows 2000 Advanced Server installation. Iam not able to repair the corrupted Windows 2000 Advanced Serverinstallation but the file system is intact. I have installed a new copyof SQL Server 7 onto a new hard disk and have used the sp_attach_dbsystem stored procedure to attach the database from the old hard driveinto the new installation of SQL Server 7 on the new hard drive. Thedatabase shows up in the Enterprise Manager View and all the data andstructure are there, but when I try to run a Web site that uses ODBCconnections to the database I get the following error:ODBC Error Code = 08001 (Unable to connect to data source)[Microsoft][ODBC SQL Server Driver][Named Pipes]Specified SQL servernot found.I have double-checked that all the NTFS permissions, ODBC DSNs, and WebServer settings are correct and when I run the SQL Server ODBC drivertest at the completion of each ODBC DSN setup, it is successfull.1) Why am I getting this ODBC error?2) What steps have I missed in the recovery process?3) If I have done something wrong recovering my database, can I stillrecover it since I still have: a) The old master database file and logfile; b) The old database (non-master) file and log file; c)A backed-up(Enterprise Manager -> Right Click A Database -> All Tasks -> BackupDatabase) copy of the old database (non-master) file; ?My System Specifications:-Windows 2000 Advanced Server-SQL Server 7-IIS 5.0-Cold Fusion Server 4.5 Professional Full EditionThanks For Your Time,Nathan

View Replies !

---

Database File On A LAN Disk
I want to put the database file on a separate physical disk from my SQL 2K server.
This disk is on a LAN server ( a SnapServer )
I don't know how to create a unit disk on a LAN disk.
Somebody can help me ?

View Replies !

---

What Happens When A Database Is Dumped To Disk ?
Hi,

If a large (say 10Gb) SQL 7.0 database is being backed up to disk via a Maintenance Plan, what happens if the database is being changed as it is being backed up ?

Does SQL7 lock users out of the database (maybe single user mode) when it is being backed up ?

Thanks for any help,

TimH

View Replies !

---

Cannot Access Clustered Disk Using Enterprise Manager SQL 2000
Hello,

I am running an SAP installation on clustered DELL poweredge 1850's with a shared scsi disk system. I am running Windows 2000 sp4 with sql 2000 sp4. I am trying to restore a database from a .bak file on a clustered disk. When I attempt to access the disk through enterprise manager it is not there. I only get access to the E: drive (which is clustered as well)

View Replies !

---

Copying MSDE Database To Disk - How??
I have my little MSDE on my computer. I can add and delete stuff from it through Web Matrix. My question is, where exactly is the database stored in Windows?? Also, say I wanted to copy it to a disk so I could show it to someone else, what file(s) would I need to copy?

The reason why I ask is because I have been doing a website as a project and we have to hand in all files on a disk. Getting all the .aspx & .ascx and the .config file is easy, but the database & stored procedures is proving tricky to find.

Thanks

View Replies !

---

No Disk Activity During Database Restore
I am trying to restore a 200 GB database on to a newly formatted SANvolume. The restore has been running for hours but there doesn't seemto be a lot of disk activity on the disks I'm restoring to and I'mwondering if that's anything to worry about.Using perfmon I'm monitoring the % Disk time for the disk I'm restoringto. It will show around 99% for a minute or so and then drop to zerofor 3-4 minutes. Is this normal? I know that since I'm restoring to anew volume that SQL Server needs to zero out the 200 GB before itstarts the actual restore but I would expect to see 100% disk timewhile it does this.Any insight appreciated.Thanks!

View Replies !

---

Moving A Database To Another Physical Disk
I want to move 2 databases to another physical disk. They are both single file databases. It looks like a fairly straigtforward attach and detach procedure, but I have a couple of questions:

The log files (.ldf) currently reside on a separate physical disk from the data files, if I attach and reattach the data files will the logs remain where they are by default or do I have to re specify there location?

Is there any advantage to running the update statistics portion of the sp_detach_db?

View Replies !

---

Database File And Disk Space
Hi All,

One of the drives that stores the database file is close to running out of space. The chance of me getting more space added to this drive any time soon are really low. What are other options I have?

Thanks.

View Replies !

---

Database File And Disk Space
Hi All,

One of the drives that stores the database file is close to running out of space. The chance of me getting more space added to this drive any time soon are really low. What are other options I have?

Thanks.

View Replies !

---

Multiple Database Files On The Same Disk
Hi there

 

It is obvious that putting multiple database files on different physical disk is better for performance, but what about splitting the data on different files on the same disk?

 

I have got a database of about 20GB and only a single data file. will I benefit from splitting this file to multiple files on the same disk?

 

View Replies !

---

Disk Configuration For Replicated Database
We are going to implement either a replicated database or use log shipping to another database to support our reporting needs. Basically we are moving reporting over data off our transactional database.

With this in mind, I have several questions:
Are there any special configurations in terms of disks for a database in this situation?What are the recommended raid types?
Also, we currently store our data in one filegroup and indexes in another so obviously I'll want those on 2 separate physical disks other than the C:. What about the log files? Do I care where they go (on C: or another physical drive separate from C:, data filegroup drive and index filegroup drive)?

Thanks!

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 !

---

Format Database Disk With 64K Blocks NTFS
Hi:

Somebody tellme that with a format of my database disk with 64K blocks NTFS, i can have better performance, is that true ? there is any problem in SQL with this block size ?

View Replies !

---

Can't Create New Database -&> No Disk Space (os Error 112)
Hello everybody

Had some problems yesterday with a full transaction log. Was able to solve it by following microsofts knowledge base article n° 272318.

However, today I'm trying to create a new DB using the enterprise manager and get this error:

d:databasesHERCULES_1_Data.MDF: Operating system error 112(Es steht nicht genug Speicherplatz auf dem Datenträger zur Verfügung.) encountered.

The free disk space is > 60GB. That's by far enough... I only need 1-2 GB.

Any ideas what's wrong here?

Thanks anyone in advance for some guideance.

Renaud

View Replies !

---

How Can I Calculate The Disk Space Which Some Records Used In SQL 2005 Database?
I execute the following SQL, and return 3 records, I want to know how many disk space the 3 records use, how can I do? thanks! select * from myTable where username='Paul' 

View Replies !

---

Problem Backing Up Database And Transaction Log Due To Disk Space Limitations
I am having a problem backing up my database and TLog files due to alack of local diskspace. The db file is about 30GB and the TLog isabout 20GB each on a different hard disk. Each disk doesn't haveenough available space to accomadate a backup. I also can't shrink thefiles because part of that procedure would require a backup.Question: Can I use a redirected drive for the backup media? Is therea way to trick SQL into allowing this? If the answer is no, doesanyone have a suggestion as to want I should do? I am in the processof requesting more disk space,but that could take a while.Thanks,

View Replies !

---

Help: Database Table Taking 9GB Of Disk Space But Only Contains 50Mb Data.
Disk space is increasing at an alarming rate (about 500MB a day). Shrink of database seems to have no effect. It is a queueing table so data is inserted then a few minutes later it gets processed & deleted.
 
Here is info about the problem:
 
sp_spaceused ImporterModuleQueue
 
name                rows        reserved           data               index_size         unused
------------------- ----------- ------------------ ------------------ ------------------ ------------------
ImporterModuleQueue 30          9469432 KB         9468280 KB         32 KB              1120 KB
 
This is about 9 GB
 
 
select sum(len(QueueContent)) from ImporterModuleQueue
 
49744918
 
select sum(len(QueueErrors)) from ImporterModuleQueue
 
43529
 
This is about 50 Mb
 
 
CREATE TABLE [dbo].[ImporterModuleQueue](
      [ImporterModuleQueueId] [int] IDENTITY(1,1) NOT NULL,
      [ImporterModuleId] [int] NOT NULL,
      [StartedDateTime] [datetime] NULL,
      [FinishedDateTime] [datetime] NULL,
      [QueueContent] [varchar](max) NOT NULL,
      [CreatedDateTime] [datetime] NOT NULL,
      [QueueErrors] [varchar](max) NULL,
      [QueueSourceId] [int] NOT NULL,
      [QueueStatusId] [int] NOT NULL CONSTRAINT [DF_ImporterModuleQueue_IsProcessed]  DEFAULT ((0)),
 CONSTRAINT [PK_ImporterProcessQueue] PRIMARY KEY NONCLUSTERED
(
      [ImporterModuleQueueId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
 
 
--
 
dbcc opentran
 
No active open transactions.
 
--
 
DBCC SHOWCONTIG scanning 'ImporterModuleQueue' table...
Table: 'ImporterModuleQueue' (2030070418); index ID: 0, database ID: 5
TABLE level scan performed.
- Pages Scanned................................: 14
- Extents Scanned..............................: 10
- Extent Switches..............................: 9
- Avg. Pages per Extent........................: 1.4
- Scan Density [Best Count:Actual Count].......: 20.00% [2:10]
- Extent Scan Fragmentation ...................: 80.00%
- Avg. Bytes Free per Page.....................: 5714.1
- Avg. Page Density (full).....................: 29.40%
 

View Replies !

---

How To Create A New Database From An Existing Database Saved To An External Hard Disk?
Hi, My server went dead(problems with the hard disk), but I have a copy of the whole sql server directory  including the database in a external hard disk. I have a new server now and I would like to copy this  database (with the reports from reporting services too) from the external hard disk to my new server. can anybody help me please? Thanks.

Note : I have a plain copy of all the sql server directory with all the files including the database not a SQLServer backup done with the wizards.

 

View Replies !

---

Database 'msdb' Cannot Be Opened Due To Inaccessible Files Or Insufficient Memory Or Disk Space.
I am using SS2005 on XP and things have been good. Today I installed"Microsoft SQL Server 2000 DTS Designer Components" (I can't think ofwhat else could have caused the problem), and now in SS2005 ManagementStudio I am getting this error message when I try to connect to theserver on my machine:Database 'msdb' cannot be opened due to inaccessible files orinsufficient memory or disk space.Any ideas??? Thanks!-John

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 !

---

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 !

---

Disk Organization
I understand the log files (LDF ) and data files (mdf ) should be on a different drives . I believe it leads to greater availabilty and speed . Are there any other reasons for to keep this on a separate drive.

Also what considerations I should take care while creating a database of around 100 GB . (use of filegroups , growth % etc ). Is there any connection of number of users to number of disks SQL data file to be spread to . Also do I need to take care (through hardware / software for a Quad core CPU ) to take full advanage of Quad core CPU.

View Replies !

---