Solved

sql backup

Posted on 2013-12-30
4
534 Views
Last Modified: 2013-12-31
I am going to run a baremetal backup on sql server, this case , the barmetal will backup only the c: , but I see the server has sql apps installed on d: drive and also the data folder  is on d: drive too.
As I understand the SQL tech runs maintenance on that server and also runs  sql backup to dump the data on a shared drive.
My responsibilities is that I have to bring the server up and running , this case I have to restore the d:drive to bring the sql installation .
Will it be an any issue with the sql maintence If I let my backup software to backup the d: drive?
0
Comment
Question by:sara2000
[X]
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
  • 2
4 Comments
 
LVL 121

Assisted Solution

by:Andrew Hancock (VMware vExpert / EE MVE^2)
Andrew Hancock (VMware vExpert / EE MVE^2) earned 250 total points
ID: 39746477
Should be no issues, encountered with your Backup Software - backing up the D: drive.

You should be able to check in the logs, if the backup job encountered any issues, backing up critical files e.g. open files at time of backup omn the D: drive.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 39747485
Unless you are able to shut down the SQL Server service, prior to running your "baremetal' backup , the backups will be useless.
0
 

Author Comment

by:sara2000
ID: 39748381
Anthony Perkins:

I am talking about thirdparty software, You do not need to shut down the services for baremetal.
unitrneds,acronis, symantec, etc.
0
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 250 total points
ID: 39749216
I am talking about thirdparty software.
I know you are and my point is that provided the backup version you have supports SQL Server then you should be fine.  For example, unless you use the edition of Acronis Backup & Recovery that supports SQL Server (not all of them do) you will not have a good backup.

Put in another way, your backup software is not much use to you if you cannot restore the SQL Server data.  So test first or you may have to update your resume.
0

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

In this article, I will show you HOW TO: Install VMware Tools for Windows on a VMware Windows virtual machine on a VMware vSphere Hypervisor 6.5 (ESXi 6.5) Host Server, using the VMware Host Client. The virtual machine has Windows Server 2016 instal…
In this article, I show you step by step with screenshots to assist you - HOW TO: Deploy and Install the VMware vCenter Server Appliance 6.5 (VCSA 6.5), with some helpful tips along the way.
Teach the user how to use vSphere Update Manager to update the VMware Tools and virtual machine hardware version Open vSphere Client: Review manual processes for updating VMware Tools and virtual hardware versions: Create a new baseline group in vSp…
This video shows you how to use a vSphere client to connect to your ESX host as the root user. Demonstrates the basic connection of bypassing certification set up. Demonstrates how to access the traditional view to begin managing your virtual mac…

690 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