?
Solved

Suggestions on Drive Replacement

Posted on 2006-11-02
2
Medium Priority
?
283 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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

The question appears often enough, how do I transfer my data from my old server to the new server while preserving file shares, share permissions, and NTFS permisions.  Here are my tips for handling such a transfer.
Is your phone running out of space to hold pictures?  This article will show you quick tips on how to solve this problem.
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 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…

777 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