Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

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

Posted on 2016-10-11
6
84 Views
Last Modified: 2016-10-13
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
Comment
Question by:Thor2923
6 Comments
 
LVL 6

Accepted Solution

by:
Obi Wan earned 500 total points
ID: 41839113
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
 
LVL 26

Expert Comment

by:Dr. Klahn
ID: 41839149
If it's that important, I'd make a second backup using different software such as Macrium Reflect.
0
 
LVL 6

Expert Comment

by:Niten Kumar
ID: 41839153
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
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
LVL 80

Expert Comment

by:David Johnson, CD, MVP
ID: 41839187
If a drive has failed if it is in a raid array why not just replace the drive and let the array rebuild.
0
 
LVL 95

Expert Comment

by:Lee W, MVP
ID: 41839223
Who knows?  Even backups that SHOULD work fail.  Have you tried to RESTORE it?  Test restores are VITAL to ANY backup strategy!
0
 
LVL 37

Expert Comment

by:ArneLovius
ID: 41839299
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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Row insertion failed. Array 5 45
SQL Server / Update DB? 22 36
Query for timesheet application 3 15
Error when creating a table from a function 6 17
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Microservice architecture adoption brings many advantages, but can add intricacy. Selecting the right orchestration tool is most important for business specific needs.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

789 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question