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 Complete Forum Thread with Replies
Related Forum Messages:
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 !
Recover Sql And Analysis Service Data From Disk Crash
Cristiano writes "hi everybody. A customer of mine has had a disk "crash" few days ago. I wrote for him a dwh application and of course the backup was not working... now some "hardware guys" said that it is possible to recover most of the files. what I need to restore would be: 1- the sql server db 2- the sql server dts and jobs 3- the analysis service cube and dimensions to do so is it enough for me to have: 1- the .mdf and .ldf files 2- the master.mdl /.ldf file 3- the .odb file and .dim* and .role .map ... files right? is it enough to recover everything? if it is so, what would be the right processes to recover everything? "
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 !
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 !
Reading Sql From A Disk File
It's probably a really easy thing to do, but I can't find out how to do it, so hopefully somebody can spare the time to help. I want to read in T-SQL contained in a file held on disk and execute it in a stored procedure. Anybody know how to get the contents of the text file into a variable so I can exec it ? Thanks for your time.
View Replies !
Reading Sql From A Disk File
It's probably a really easy thing to do, but I can't find out how to do it, so hopefully somebody can spare the time to help. I want to read in T-SQL contained in a file held on disk and execute it in a stored procedure. Anybody know how to get the contents of the text file into a variable so I can exec it ? Thanks for your time.
View Replies !
Restore DB From File On Disk
Hi, I am trying to create a scheduled task taht will restore a database from a backup file. I do not store my backups on a backup device, but on a local disk. To restore a DB from a backup device, the following statement will work: "Load DBName from BackupDeviceName". Does any know what statement to use to restore from a file, if the file is "E:DBName_db_dump_199909272220". Thanks in a advanced.
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 !
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 !
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 !
Moving Transaction Log File To Another Disk
Hi all, I have to give support to this new client of ours and the system out there was a real mess.The log files for all four databases were ranging from 5 to 9 GB's, no maintanance no nothing was done since the setup of the system. I have truncated the logs after taking proper backups since it all started after they compalined a DTS was not working, which was due to no disk space available ;). Now I have to shift the log files to a seperate disk. I know it can be done by detaching the database and attaching it back, I was wondering if we can do it without bringing the system offline? Anycomments welcome. Thankyou. regards, harshal.
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 !
Disk Backup Failures (file In Use)
I am getting occasional failures of a SQL Server 7.0 complete backup to disk on a production database. The errors seem to indicate that another process has the disk file open at the time of the backup. The errors contain the following texts : - 'Cannot open backup device' 'Operating System Error=32 Process cannot access file because it is being used by another process'. The only other process that should access the disk file is an ARCserveIT scheduled job to copy the disk backup to tape but this is completing long before. Any ideas or suggestions?
View Replies !
Log File Filled Up Disk When Restoring
Hi, I'm trying to write a restore script. In the past I've always used the SSMS GUI to restore. When running the script below, the process got stuck at around 90%. Eventually I aborted the restore and found out that my C drive was full. The log file of the database I was restoring was 32GB. Can anyone tell me what I'm doing wrong? Thanks. Code Snippet ALTER DATABASE [oms] SET SINGLE_USER WITH ROLLBACK IMMEDIATE GO RESTORE DATABASE [oms] FROM DISK = N'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackupOMS_Blank_Production.bak' WITH FILE = 1, REPLACE, STATS = 10 GO ALTER DATABASE [oms] SET MULTI_USER; GO
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 !
Error When Attempting To Backup To A Second Disk File
In SQL Server 2005, via the GUI, I wish to backup a database to an additional disk file (there is already an existing backup disk file for this database), so that I can have more than one backup. I've added the new disk file name, highlighted it, and clicked OK. I get an immediate error (see below). Note, the 2nd error message is specifying the existing backup disk file, not the new one I'm attempting to create. "Backup failed for Server 'WCS-DEV-TPA'. (Microsoft.SqlServer.Smo)" "System.Data.SqlClient.SqlError: The volume on device 'D:Program FilesMicrosoft SQL ServerMSSQLBACKUPWCS_ADV_Longmont.bak' is not part of a multiple family media set. BACKUP WITH FORMAT can be used to form a new media set. (Microsoft.SqlServer.Smo)" Does anyone know what causes this and how to correct it?
View Replies !
Recover With MDF File Only Due To Hard Disk Failure
catcat writes "Hi All, Our MSSQL 2000 server crashed yesterday and one database cannot be restored. the latest backup we have is june. We can only recover the MDF file from the harddisk and according to our admin, it cannot be restored anymore because no proper shutdown was made. Will appreciate your help here."
View Replies !
File Fragmentation And Disk Read Queue
I have a poorly performing SQL box. I have run perfmon and the avg read queue length is pretty much permanently maxed out at 100%. I have run a database index defrag. On further inspection the file system is highly fragmented. There is a file fragmentation of 98% with the mdf file fragmented in 25,000 pieces. Running a standard windows defrag does not resolve this. Two questions? 1- Is heavy file fragmentation of the MDF file a likely cause of the read queue length bottlneck? 2 - Why is the MDF file not defragmenting? Does the SQL server have to be taken offline? Is it possible to defrag a MDF file?
View Replies !
Log File Shrink Not Releasing The Space On Disk
Hi all My Transactional log size increased to 39GB, it is in full recovery mode, To regain the space, i have done the following BACKUP LOG DB_NAME WITH TRUNCATE_ONLY DBCC SHRINK_FILE (LOG_FILE_NAME,500) But not able to regain the space in the hard disk. No Transactional backups to truncate the log file were setup. Can you please tell me why the space was released and what should i do further to clean up the sapce
View Replies !
W3wp Causing Memory Paging, Crash On Reportserver?
Summary: We host reports off of one server that are accessed and refreshed 24/7/365. On a daily basis, I receive calls about reports taking several minutes to run IF they run at all. (normally these reports take seconds). There has yet to be an actual "error message" associated with this behavior. When I check the server at these times, I will find that w3wp.exe process is taking up about 4G and is causing paging. It seems that once it gets to that point, it will kill itself and all goes back to normal. However, it's a slow death and is impacting business. We're using MSRS 2005. Hosting the reports is the job of this server--no other applications are hitting it. There is a development SQL db on the box, but not in use at this time. The datasources in most cases are stored procedures housed on another box. The web interface (for end users running the report) is hosted on a third server. Any thoughts?
View Replies !
[Flat File Source [8885]] Error: The Column Data For Column &&"CountryId&&" Overflowed The Disk I/O Buffer.
Hi everyone, I am using SSIS, and I got the folowing error, I am loading several CSV files in a OLE DB, Becasuse the file is finishing and the tak dont realize of the anormal termination, making an overflow. So basically what i want is to control the anormal ending of the csv file. please can anyone help me ??? I am getting the following error after replacing the '""' with '|'. The replacng is done becasue some text sting contains "" wherein the DFT was throwing an error as " The column delimiter could not foun". [Flat File Source [8885]] Error: The column data for column "CountryId" overflowed the disk I/O buffer. [Flat File Source [8885]] Error: An error occurred while skipping data rows. [DTS.Pipeline] Error: The PrimeOutput method on component "Flat File Source" (8885) returned error code 0xC0202091. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. [DTS.Pipeline] Error: Thread "SourceThread0" has exited with error code 0xC0047038. [DTS.Pipeline] Error: Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown. [DTS.Pipeline] Error: Thread "WorkThread0" has exited with error code 0xC0047039. [DTS.Pipeline] Information: Post Execute phase is beginning. apprecite for immediate response. Thanks in advance, Anand
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 !
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 !
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 !
Recovery From LOG Disk Failure
I am writing up a general purpose document regarding Disaster Recovery and Backup and Restore, etc. I have a question that I've been unable to find any definitive answer on, and I was hoping that someone might have an answer. Here is the scenario and what I have so far, and my question: Scenario - A simple database, with one MDF and one LDF, each on it's own disk, with no mirroring or filegroups etc. Disaster - the LOG disk fails. To simulate the disaster, I shut down SQL Server, and delete the LDF manually. When I restart SQL Server, the database is marked as suspect. As expected :) So, now the recovery begins..... I've read that in this case there is no data loss, but I find that hard to believe. Can anyone confirm? Anyway, how to restore the database to usable status? Here is what I've come up with so far: 1) Do a backup of "the tail of the log." This works even though there is no log. I have no idea why really, but I can't proceed otherwise. 2) Detach the database. 3) Reattach the database. This auto-creates a new log file (albeit not in the location I want, which makes for more work after). At this point the database appears to be fine. I have not seen any lost data or problems, but of course I'm working on a test database, not with live users hitting it constantly. If the database were under heavy use, I expect that there might indeed be data lost? Is this the recommended way to recover from a disaster of this type? Or, would it be better to just go back to your last good backups and forget about "up to the minute" recovery in this case? Or is there yet another means? Thanks, Travis
View Replies !
Disk Or Network Error
HiI have written an application in VB through which I can convert DBASEIV database to MS SQL Server database. Also, the application providesdatabase manipulation features to the user like addition, deletion etcof records.I am using OPENROWSET for conversion purposes. Also the server is MSSQL Server 2000.Now this application workks fine when I have installed the instance ofMS SQL Server on my local machine. It converts the database and storesit on the server perfectly and there are no isues.However, when I try to use the application to connect with MS SQLServer on another machine, there are a few problems. I connect to theother MS SQL Server on other machine through named pipes. Myapplication successfully accesses the database and allows user tomodify it according to his needs.For this I created the user account of that user on the machine.But when I try to convert the database, I get the following errormessage:[Microsoft ODBC Dbase driver]Disk or Network ErrorHere is the line in VB code which is causing all the trouble:con.Execute "select * into " & UCase(X) & " fromOPENROWSET('MSDASQL','Driver={Microsoft dBASE Driver(*.dbf)};DEFAULTDIR=" & BaseData & ";SourceType=DBF','select * from " &UCase(X) & "')"Here, X is the dbf file name, BaseData is the path name of file.I gave the user full rights but i am still getting this error message.Now, what am I doing wrong here?Regards,Shwetabh
View Replies !
|
TRACKER
