Solved

sql backup

Posted on 2013-12-30
4
530 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 120

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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

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

Will try to explain how to use the VMware feature TAGs in the VMs and create Veeam Backup Jobs using TAGs. Since this article is too long, I will create second article for the Veeam tasks.
Ransomware is a malware that is again in the list of security  concerns. Not only for companies, but also for Government security and  even at personal use. IT departments should be aware and have the right  knowledge to how to fight it.
Teach the user how to rename, unmount, delete and upgrade VMFS datastores. Open vSphere Web Client: Rename VMFS and NFS datastores: Upgrade VMFS-3 volume to VMFS-5: Unmount VMFS datastore: Delete a VMFS datastore:
This video shows you how easy it is to boot from ISO images for virtual machines with the ISO images stored on a local datastore on the ESXi host.

739 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