Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 453
  • Last Modified:

NTbackup? backup entire OS

Does NTbackup have the capability to create an image of the entire OS.  

For example, if my SQL Server (on Win 2k) died, can I restore the image onto a new computer?
5 Solutions
Christopher McKayMicrosoft Network AdministratorCommented:
Hi phileoca,
Unfortunately, NTBackup skips files that are in use by the operating system when it does it's complete backup.
You would need to install the os, and then restore from the backup.

Hope this helps!


You're asking an involved question.  How do you backup SQL now?
NTbackup won't cut it unless SQL is down when it's backed up.
Are you dumping databases now?
Will you please provide the exact way you're backing up SQL?
Microsoft has a new tool for use with NTBackup called Automatic System Restore (ASR).

Previously with NTBackup you had to re-install the OS, restore the original settings and then restore the data. With ASR, that's no longer necessary -- you can restore the system directly from an ASR backup.

So that would be like creating an image of your entire OS that could be restored onto a brand-new, bare computer (known as a Bare Metal Restore).

If this sounds like what you're looking for, there's more information at:
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Steve McCarthy, MCSE, MCSA, MCP x8, Network+, i-Net+, A+, CIWA, CCNA, FDLE FCIC, HIPAA Security OfficerIT Consultant, Network Engineer, Windows Network Administrator, VMware AdministratorCommented:
Here is something you could do.  

1.   Get something like Veritas Backup Exec with the SQL option.

2.  Use something like Ghose or Drive Image.  Make a mirror of your drive.  If it fails, restore the image to the new drive and drop your sql database back on there.  

If NT backup is not fully backing up SQL, try stopping SQL first.  Before the backup you would use something like net stop mssqlserver and afterwards net start mssqlserver.  Just put them in a batch file.
<<Does NTbackup have the capability to create an image of the entire OS.>>

It can create an entire backup of the drive, but an entire IMAGE of the drive, NO.

<<For example, if my SQL Server (on Win 2k) died, can I restore the image onto a new computer?>>

SQL server has zillions of open files all the time it is running.

Use NTbackup.exe to -- backup the system state -- to a removable media or mapped drive.  That will get all the open files.

Then stop the SQL service, and run a complete backup of the SQL database.  Now you have both.
Restart the service.

There are MANY MANY other tools to backup the entire drive, but you want it as files, not an image, if you intend to recover it.
Recommend you clone the entire drive to another one, with Norton Ghost 2003 Enterprise -- copies the image or files to a remote drive.

That is the best total backup there is.
phileocaAuthor Commented:
just a hypothetical question.  Once our SAN device is installed, I won't have to worry about any of this.


Read the resolution.

I'll distribute points later today.

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now