Backing up Windows 2000 Server running SQL 7

Posted on 2003-03-07
Medium Priority
Last Modified: 2010-04-13
I am currently using Windows 2000 Server running SQL 7.  What I would like is a backup solution that we could use to restore the operating system and all the files in the system including the SQL database, in the case of something like a harddrive failure.  

Basically I want to be able to boot up from the backup and restore the entire system to another harddrive.  The Server can be taken offline to create the backup weekly.
Question by:BackupName
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
  • 2
  • 2
  • +3

Accepted Solution

Goldwing earned 300 total points
ID: 8088091
Have you thought of using mirroring raid??
In case a HD fails the otherone takes operation over
then remove the failed HD, replace it with a new one and let windows 2000 including SQL7 mirror itself back to the new HD.

a other solution is Arcserve backup, there is a SQL module available for it.

Author Comment

ID: 8088362
We do have the harddrive mirrored, but if an error occurs where bad information was somehow written to the harddrive, wouldn't those same errors be written to the mirrored drive?  

The database is not updated very often and what we would like is a not too old backup we can boot from to easily load to a new harddrive if the mirroring somehow failed.  We are using arcserve on another server and it just really sucks :(.  I was thinking of something like Ghost or Drive Image, but did not know if these would work to restore windows 2000 and SQL to the state they were in when they were backed up.  

Expert Comment

ID: 8089911
If you can take your server offline for couble of hours, you could use image softer to take snapshot of your whole system to image files (it can take a while)
If there is only sql 7 server running on the computer, you could take a database dump to a file, and save the file on tape etc..
When/If the system crashes, you reinstall win2ksrv and sql 7, and import the databse dump file.
What Is Blockchain Technology?

Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.


Expert Comment

ID: 8090984
You can use Ghost! (7.51). Although I personnaly have in the past favored Drive Image, they have been leaning towards products defined for each OS and platform. I use GHOST here at The University of Illinois. Do not place any server with HARD RAID into the GHOST console, Do not attempt any remote control of the server with the GHOST console. It will re-write the MBT of all the disks and your raid is gone. Invest in GHOST enterprise 7.51.

Install the console and build a symantec, (NOT a MS DOS) network boot disk, Network Boot Disk.  Boot up your server cold, and direct it to start off of the floppy.
Select the drives you want to copy, and send it either to the ghost console or your mapped storage location.

It will grab it all, sid, security etcc, as it copies each cylinder. So long as you don't rename the server, cahnge it's domain, or alter any trusts, you can drop back in your image at any time, and the network and customers will never know.

I build all my servers so that ONLY the OS is on C:\ the apps on D:\, and E:\ contains temp & swap. Stored data goes on to a seperate spindle. I have created master NSA secure W2k server ghiost images that work on all my flavors of DELL Servers, and RAID controllers. So now I just pop in an image to C:\ join the domain, update the SP's and go on. YES you can IMAGE a PDC, however I don't recommmend it, because It conflicts with security changes.  DEMOTE the PDC, take him off line, bring him up on a local admin account. Then image him.  

WARNING:!! never bring up an image of an AD DOMAIN CONTOLLER that was captured while demoted, unless you have another Domain contoller. You will lose the whole domain, and a whole weekend.
LVL 10

Expert Comment

ID: 8091045
Try Arcserve disaster recovery backup software with SQL agents.


Bets way to go from nothing to up and running intact. It worked for a county office Sql box that had multiple drives die in thier RAID.

Good luck :)

Expert Comment

ID: 8091160
I can't disagree with PCBRAT. However BACKUPNAME seemed to imply, (By mentioning Ghost that he was looking for a cheaper solution.) Live Vault,Arcserve and Backup-EXEC are the best streamlined disaster recovery methods money can buy. However not everyone can pay for it. I use Live Vault and Backup EXEC to handle all the data and databases on the servers. However the fastest cheapest server OS partition only solution I have is ghost. We built a USB BOOTABLE DVD drive, and now we place our server images on DVD, I can have any server reimaged in 10 minutes!, Backup exec, and Arcserver can't even load the tape.  

Expert Comment

ID: 8091464
You can use ghost to image the drives to tape and there is and option to restore from the image from tape.

But you would have to image all the drives to get sql and the os back to the state when you did the ghost image but the problem is that the restore will only get it back to the state it was in when you did it and doing this weekly may be a bit troublesome.

But if the server does not change much ie you dont make changes to the sql server ie adding databases then all you need is to image the server when ever you add a database or service pack and backup the data bases to a local drive then to tape or the arcserv agent.

I do know that there is and image option for backupexec that will do what you want. There may be the same thing available for arcserv but I am unaware of it.


Expert Comment

ID: 8091801
I'll repeat myself,
a solution is Arcserve backup, there is a SQL module available for it.

it has a disaster recovery, you can make it every night when no-one is working.
Worst case scenario, the workers will lose the work they did that day, when you restore from the backup made last night.
LVL 10

Expert Comment

ID: 8091954
I agree with Goldwing. It all depends on how valuable your downtime and data restore is to you. I understand trying to save money by choosing other options, but where do you draw the line?

Good luck in your choice :)
Pcbrat a.k.a Dawne

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

NTFS file system has been developed by Microsoft that is widely used by Windows NT operating system and its advanced versions. It is the mostly used over FAT file system as it provides superior features like reliability, security, storage, efficienc…
In today's business world, data is more important than ever for informing marketing campaigns. Accessing and using data, however, may not come naturally to some creative marketing professionals. Here are four tips for adapting to wield data for insi…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

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