Backing up Windows 2000 Server running SQL 7

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.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
BackupNameAuthor Commented:
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.  
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.
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

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.
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 :)
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.  
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.

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.
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows 2000

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.