Solved

Suggestions on Drive Replacement

Posted on 2006-11-02
2
276 Views
Last Modified: 2010-04-03
Hello All,

I have a Dell  PowerEdge 2800 Server that needs a drive replaced. It is a SCSI Ultra360 interface and is not configured in a RAID array or mirror. It  basically just contains a volume were SQL transactions are logged (60 GBs worth).  

I don't have an extra drive carrier( the device that holds the drive and is pushed into the open  bay slot) or I would just pop the drive in, stop the SQL service and copy the data over. Then assign the old drive letter.  

I do have about 60 gigs on the C: partition where I could move the data temporarily. This system is on a detached subnet with no access to a backup device. Anyway... Anyone have any tips to speed things up or another way to do this ?
0
Comment
Question by:VConnick
2 Comments
 

Accepted Solution

by:
SRWright earned 50 total points
Comment Utility

I had a similar situation to this, but the drive was only a 30gb.

I used an external 160GB USB drive to back the information onto.  My purpose was actually to refit the server and add a couple more drives to it, then build an array.

The only concern I would have with moving the data to the C: drive is that the process may interfere with the functionality of the server itself.  Slowing it  down some or even interfering with the caching.

However you do it, if you do not have a place to put in another SCSI drive, sounds like you may have some down-time.

0
 
LVL 55

Expert Comment

by:andyalder
Comment Utility
60GB transaction log???

SQL is broken, never mind the hardware. Really you need to ask in the SQL TA on how to use dbcc shrinkdb or dbcc shrinkdatabase along with how to create a new transaction log using the enterprise manager and how to stop SQL from creating logs that are 10% bigger each time it needs a new one and how to make the backup software truncate the log properly.

Sure a 60GB log is valid size for a 1TB database with 1000 data entry users but such systems aren't on networks without a backup device, anyway you do have a backup device, you've got 60 gigs free on C: that you can backup to using the SQL GUI.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

We all have limited time to study long and complicated information about RAID theories, but you may be interested as to how RAID 5 works. We made it simple for you by providing the shortest and easiest explanation ever.   First we need to remind …
How to update Firmware and Bios in Dell Equalogic PS6000 Arrays and Hard Disks firmware update.
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…
This Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now