Solved

Suggestions on Drive Replacement

Posted on 2006-11-02
2
279 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
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 55

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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

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!
In this article we will learn how to backup a VMware farm using Nakivo Backup & Replication. In this tutorial we will install the software on a Windows 2012 R2 Server.
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…

840 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