Solved

Suggestions on Drive Replacement

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

Why Off-Site Backups Are The Only Way To Go

You are probably backing up your data—but how and where? Ransomware is on the rise and there are variants that specifically target backups. Read on to discover why off-site is the way to go.

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.
Many businesses neglect disaster recovery and treat it as an after-thought. I can tell you first hand that data will be lost, hard drives die, servers will be hacked, and careless (or malicious) employees can ruin your data.
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…

726 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