?
Solved

Suggestions on Drive Replacement

Posted on 2006-11-02
2
Medium Priority
?
284 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 

Accepted Solution

by:
SRWright earned 150 total points
ID: 17861487

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 56

Expert Comment

by:andyalder
ID: 17861581
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Create your own, high-performance VM backup appliance by installing NAKIVO Backup & Replication directly onto a Synology NAS!
The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
This video teaches viewers how to encrypt an external drive that requires a password to read and edit the drive. All tasks are done in Disk Utility. Plug in the external drive you wish to encrypt: Make sure all previous data on the drive has been …
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…
Suggested Courses

649 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