Solved

sql backup

Posted on 2013-12-30
4
517 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
  • 2
4 Comments
 
LVL 117

Assisted Solution

by:Andrew Hancock (VMware vExpert / EE MVE)
Andrew Hancock (VMware vExpert / EE MVE) 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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Calculating Business Hours 19 63
Log Backup 2 13
Sql query for filter 12 22
Mssql SQL query 14 27
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Last article we focus in how to VMware: How to create and use VMs TAGs – Part 1 so before follow this article and perform the next tasks, you should read the first article how to create the TAG before using them in Veeam Backup Jobs.
Teach the user how to convert virtaul disk file formats and how to rename virtual machine files on datastores. Open vSphere Web Client: Review VM disk settings: Migrate VM to new datastore with a thick provisioned (lazy zeroed) disk format: Rename a…
Teach the user how to configure vSphere Replication and how to protect and recover VMs Open vSphere Web Client: Verify vsphere Replication is enabled: Enable vSphere Replication for a virtual machine: Verify replicated VM is created: Recover replica…

758 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now