Improve company productivity with a Business Account.Sign Up

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

Windows 2012 Server Backup via the WBADMIN/built in Server 2012 tool

Hello All,

I have several 2012 servers. All  are using the built in Windows Server backup program.

When I backup using the built in server backup tool, I assume that  the backup includes open SQL databases and other open files?

Do I need BackupExec with a SQL agent?

Right now I backup bare metal recovery, system state, recovery partition, and my two hard drives on each server

 I am assuming that a VSS  backs up everything regardless if a file is locked by another program or not.

In a worse case scenario, how do I restore a server using bare metal restore. I cannot find a document telling me how to do it? Do I make a 2012 bootable DVD? I see documents on doing the backup and where is the document that tells me how to restore?

Thanks,

DT
0
dronethought
Asked:
dronethought
  • 5
  • 2
2 Solutions
 
Cliff GaliherCommented:
SQL server does install a VSS agent that will ensure the databases are in a consistent state when they are backed up. So yes, SQL will be backed up just fine. Whether you want a 3rd-party tool depends on the granularity of control you want. You won't be able to do a point-in-time restore of a single database with the built-in backup. The backup engine just doesn't have that logic built in. You'd need to run some other backup process for that.

As far as restoring, yes, bootable media is required for a bare metal restore. The process is simple. Boot the media, on the first screen choose "repair" (it is a small link on the welcome  screen), and then choose a complete recovery from backup. The backup/restore program launches and asks for the location of the backup. Point it at your media and away you go...

-Cliff
0
 
CoSmismgrCommented:
0
 
dronethoughtAuthor Commented:
Thank you. Just want to confirm, if I have to restore my sql database, I only have the previous backup to restore, I cannot restore a database during a point and time if the database goes down during the day. Only have one shot at it.
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
dronethoughtAuthor Commented:
Thank you
0
 
dronethoughtAuthor Commented:
I've requested that this question be deleted for the following reason:

This was answered. Why does it show up as open?
0
 
Cliff GaliherCommented:
If the question was answered, why are you requesting it be deleted?
0
 
dronethoughtAuthor Commented:
Because it shows as open. Please close it.
0
 
dronethoughtAuthor Commented:
The answer was accepted. Why does it show as open?
0
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.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

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