Learn how to a build a cloud-first strategyRegister Now

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

I backed up an OLD windows 2003 server that runs SQL with Windows Backup. Am I covered?

We have an old Windows 2003 server and it looks like a drive has failed. We need to power the server down to replace it, but want to have a backup first. I logged into the Server and ran the built in Windows Backup. I made sure that ALL drives were checked, including the one with the databases. I have a good BKF file saved on another server now. It is 75GB which is about the size of all the data combined on the server. We are ready to shut the server down now, but are we covered for a worst case scenario? The backup looks good, but I know this was only the built in Windows Backup. Do I have a false sense of security?
0
Thor2923
Asked:
Thor2923
1 Solution
 
Obi WanFixerUpperCommented:
Nope sounds ok to me. But to save you worries, and another chance run if it fails for some funky reason, restore to a virtual machine, as a test.

if good, leave on, shut down old machine, or do as you need to do.
0
 
Dr. KlahnPrincipal Software EngineerCommented:
If it's that important, I'd make a second backup using different software such as Macrium Reflect.
0
 
Niten KumarPrincipal Systems AdministratorCommented:
Yeah Windows backup seems good enough.  But just to feel at ease you might wanna take a SQL backup too.  There are many free easy to use utilities.  Try the following link:

http://sqlbackupfree.com/best-sql-backup-software/
0
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.

 
David Johnson, CD, MVPOwnerCommented:
If a drive has failed if it is in a raid array why not just replace the drive and let the array rebuild.
0
 
Lee W, MVPTechnology and Business Process AdvisorCommented:
Who knows?  Even backups that SHOULD work fail.  Have you tried to RESTORE it?  Test restores are VITAL to ANY backup strategy!
0
 
ArneLoviusCommented:
Especially on older operating systems, I am a BIG fan of taking an offline image based backup before replacing or repairing storage subsystems.

An offline image based backup does not have to worry about locked files...

I usually recommend using clonezilla booting from USB or optical media, and then copying to a local USB disk, or over the network to suitable network share.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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