Swapping out Drives on our production SQL Server this weekend

Travis L. Alltop

All,

To make a long story short, we are swapping out the "knock-off" drives
that the NA purchased on E-Bay in one of our production SQL Servers
(SQL Server 2000 Enterprise) this weekend for brand new ones (Compaq
15K RPM 32GB drives). We are currently experiencing ASR almost on a
daily basis and it is really causing a disription in service. SO, The
Network Admin ahs made this decison to replace these drives in attempt
to solve this. These new drives will be imaged with ALL of the current
data on the "knock-off' drives and will be plugged back in to this
database server and brought back up .This Server also happens to
currently be a subscriber in Merge Replication as well. Besides
stopping replication to this subscriber is there any other tasks that
I need to do or concerns that I need to be knowledgable about or look
for when we bring this database server backup on line this weekend?
Thanks Travis. :)

Jul 20 '05 #1

Subscribe Reply

1606

Simon Hayes

ta*****@rairtec h.com (Travis L. Alltop) wrote in message news:<26******* *************** ****@posting.go ogle.com>...

All,

To make a long story short, we are swapping out the "knock-off" drives
that the NA purchased on E-Bay in one of our production SQL Servers
(SQL Server 2000 Enterprise) this weekend for brand new ones (Compaq
15K RPM 32GB drives). We are currently experiencing ASR almost on a
daily basis and it is really causing a disription in service. SO, The
Network Admin ahs made this decison to replace these drives in attempt
to solve this. These new drives will be imaged with ALL of the current
data on the "knock-off' drives and will be plugged back in to this
database server and brought back up .This Server also happens to
currently be a subscriber in Merge Replication as well. Besides
stopping replication to this subscriber is there any other tasks that
I need to do or concerns that I need to be knowledgable about or look
for when we bring this database server backup on line this weekend?
Thanks Travis. :)

In theory, as long as you stop MSSQL, then image the drives, there
shouldn't be a problem (assuming that you're not also renaming the
server, changing domains, or doing anything beyond a disk copy).

However, if your drives are suspect, then how do you know that the
imaged copy will be good? If the source is unreliable, then the copy
could be too. So I'd definitely make a backup or two to completely
separate media and verify them, just in case...

Simon

Jul 20 '05 #2

Similar topics

2485

upgrading hard drives, best way to back up and restore SQL

by: Ned Hart | last post by:

I'm formatting my mirrored drives and installing a third drive for raid 5 to add more space. I have backup exec. Can anyone tell me the best way to backup SQL so I can be sure it will restore properly? I was thinking of using imaging software and creating an image to a USB 2.0 hard drive. The DB is 80 gigs. Thanks NH

Microsoft SQL Server

2668

Different web.config's for development and production

by: Klaus Jensen | last post by:

Hi! I have a pretty traditional setup where I develop on my local PC and the use "Copy Project" to deploy to the production enviroment.. In web.config I need different values for connectionstrings etc for development and production - pretty normalt stuff. Currently I edit the web.config manually before deploying, and have never forgotten - but I know it is a matter of time before I or a colleague do.

ASP.NET

1562

Enumerate all the drives including Mapped network drives on a serv

by: Pradeep Sundaram(MSFT) | last post by:

Hello, I want to enumerate all the Drives on the web server using ASP.NET (C#) Writing code like this works when i use local host but when i try to access it from another machine it does not show the network drives. Code: foreach (string s in arr) { s2=s2+s; }

ASP.NET

3575

Get Computer Name from Mapped Drives using Classic ASP

by: Ben | last post by:

Hi, Thanks for reading this post... I am trying to get the computer/server names from the mapped drives on the Clients PC when they select a file from the upload "browse" button. When the user clicks on the "Browse" button on the "<input type="File"... control and selects a file located in one of many possible mapped drives. I want to save the location of the file as a path as you would see when mapping a drive. For instance,...

ASP / Active Server Pages

4851

Byte swapping help please

by: Ann | last post by:

I am opening a file which looks like 0xABCDEF01 on another machine but 0x01EFCDAB on my machine. Is this a byte swapping? Could anyone give a good way to check if bytes are being swapped? (code should work smoothly across different machine.) Thanks, Ann

C / C++

9912

Error 1312 when Mapping drives.

by: Tomas Vera | last post by:

Hello All, I have a web application that is required to copy a file from the WebServer to a remote web server (staging server to production server). I've created an application that maps the network drive, then moves a specified file to the remote server. I've imported the SDK API "WNetAddConnection2A" to map the network drive.

C# / C Sharp

1337

How do you retrive drives and net work connections?

by: ImOk | last post by:

I want to retrieve a list of all the drives (HD, CD-ROM, Removable, etc) and also network connections/mappings and shares connected to the computer which is Windows XP. I am trying to avoid using FileSystemObject if possible. Is there anyway of doing this with PHP extensions? My other thought would be to use exec() or a Java applet. Any one of code that does this already or have any ideas how it could

PHP

4965

"Failed to start monitoring changes to... " drives me crazy !

by: Radu | last post by:

Hi. I have finished a web-site - and it runs fine on my dev machine. I have deployed it onto the server, and now I have this (which, by the way, doesn't seem to happen all the time - sometimes I can see other errors): _______________________________________________ Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your...

.NET Framework

1519

Find drives in the PC

by: DBC User | last post by:

I have a program in the network location, which when running, it needs to find out what are all the drives available in the PC. I have the following code in my program using (ManagementClass netwConn = new ManagementClass("Win32_NetworkConnection")) { ManagementObjectCollection shares = netwConn.GetInstances(); foreach (ManagementObject share in shares)

C# / C Sharp

9636

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9474

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10306

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8961

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7485

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6724

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5373

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5503

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2869

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General