[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1186
  • Last Modified:

Backing up and restoring windows 2003 using ntbackup?

I have a server w2k3 sbs with obviously exchange , file server and a SQL database (which is used by a bespoke accountancy application)

It is also a domain. I do regular full ntbackups.


If the server fails i.e won't boot anymore do corrupt boot files , or if the hard drives die.....

1. Can I do a full windows restore using ntbackup after reinstalling windows? Will it restore it to its exact original state?

2. Do I create three backups , one for the complete server, one for exchange and one for SQL. ? I understand ntbackup can backup exchange without dismounting the informations store but how do I back up SQL ?

3. If the hard drives fail, I can put in new hard drives , reinstall windows, then do a full restore from the full ntbackup? Correct

Please advise
0
Ikky786
Asked:
Ikky786
  • 3
  • 2
  • 2
  • +1
7 Solutions
 
Miguel Angel Perez MuñozCommented:
Standard procedures to make restorations with ntbackups are:

Perform full backups. In case of crash (hard drive damaged or whatever), reinstall OS and perform full restoration. Doing this, you recover your server as same point was at time you do your backup.
Since you have other apps, I recommend before running your ntbackup job, make a full export of your databases, sometimes database files can not be copied using ntbackup, this let you import if database restoration fails. This is a job on SQL Server.
Exchange databases requires another procedures.
This articles may help you:
How to restore a datababase from export: http://msdn.microsoft.com/en-us/library/ms177429.aspx
How to make export backups using sql server:http://msdn.microsoft.com/en-us/library/ms187510.aspx
How to backup and restore your Exchange server using ntbackup: http://www.msexchange.org/articles-tutorials/exchange-server-2003/high-availability-recovery/Exchange-2003-Backup-Restore-NTBACKUP.html
0
 
Scott CSenior Systems EnginerCommented:
To answer your question, no.  NTBackup cannot back up the OS and restore it to a functional OS again.

You need something with more features like BackupExec.

With everthing you are backing up you really need to use a 3rd part program that will have the features you need to do a proper backup.
0
 
Ikky786Author Commented:
thanks people.

i dont understand why microsoft have made product which we cannot backup properly without third party tools.

doesnt make sense. through all the different flavours of windows they could of atleast included one utility that completely backs up the whole system in its entirety ready for restore.
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
Miguel Angel Perez MuñozCommented:
Really you can recovery at same point using ntbackup, but need reinstall OS first and restore over this install.
0
 
hecgomrecCommented:
I don't know the size of your enviroment but here is my recomendation:

Installed Software:

1 HD (mirrored) for System (OS)
1 HD for your Exchange Data Base (RAID as/if needed)
1 HD for your SQL Database (RAID as/if needed)

Backup:  (if possible different units and Grand Father, Father, Son as needed)

1 set for System
1 set for Exchange Data Base
1 set for SQL Database

Note: Never backup all your data to the same media.  Not safe.

Backup Software:  NTBackup can do the trick but has limitations and can be time consuming for backing up and restoring, other software solution might give you better results but you should decide with one fits your company's needs and budget.

Good Luck
0
 
Scott CSenior Systems EnginerCommented:
That's a great idea to not have all of your data on the same media. I never thought about it but if a tape breaks then it is all gone for that day.

Wheras if a tape breaks you only lose part of that media for that day and the rest will be fine.

Excellent.
0
 
hecgomrecCommented:
TAPE???? No way....

Use NAS or SAS at 5.0 Gbps via usb 3 or 3.0 Gbps via eSata.
0
 
Ikky786Author Commented:
i like the NAS or SAS at 5.0gps via usb 3 or 3.0gps via estata.

what should I purchase , a QNAP or synology?

whats cheap and reliable and most commonly used.
0
 
hecgomrecCommented:
Here is a thing...  this you will have to go with your budget and company needs.

QNAP is very business oriented...like big!!!

Synology has a broad liine of products, even for home.

So at the end of the day I can't really recommend a Backup solution (NAS) as I like to think there are no rules when it comes to which products is the "best" because what is best for you doesn't mean it will be for the company next door.  As long as you have a good backup organization the media you choose... sorry that you can afford... will do.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now