SQL question

Availability for the Always-On Enterprise

SQL question

Veeam Logoby joshgfeller » Wed Apr 05, 2017 8:55 pm

Hello,

On our main SQL server I do full backups nightly, differential at noon, and trans logs throughout the day all via windows sql agent. When I setup Veeam I went ahead and turned on application processing. I noticed when doing a restore on SQL in windows my backup chain seemed messed up and it was trying to pull the full backup with a Veeam name on the backup so it wouldn't work.

Is best practices in my scenario to let windows handle all the SQL backups and then turn off application processing on the DB server?
joshgfeller
Influencer
 
Posts: 10
Liked: never
Joined: Fri Apr 05, 2013 5:14 pm
Full Name: JOsh Gfeller

Re: SQL question

Veeam Logoby kubimike » Wed Apr 05, 2017 11:24 pm

No let application aware do it's thing. Could you post a pic of the error ?
kubimike
Expert
 
Posts: 133
Liked: 20 times
Joined: Fri Feb 03, 2017 2:34 pm
Full Name: MikeO

Re: SQL question

Veeam Logoby joshgfeller » Thu Apr 06, 2017 1:10 am

I will pull a screenshot in the morning . So veeam should be able to take a full sql backup in the evenings and not mess up the backup chain? So I can let veeam handle the full nightly, turn off full sql full backup in windows, and let windows sql handle differential and trans logs?
joshgfeller
Influencer
 
Posts: 10
Liked: never
Joined: Fri Apr 05, 2013 5:14 pm
Full Name: JOsh Gfeller

Re: SQL question

Veeam Logoby kubimike » Thu Apr 06, 2017 1:25 am 1 person likes this post

If you're doing windows sql backup and veeam sql backup that's going to cause an issue with log rolling. :( what's your logging plan ? Simple ? Full?
kubimike
Expert
 
Posts: 133
Liked: 20 times
Joined: Fri Feb 03, 2017 2:34 pm
Full Name: MikeO

Re: SQL question

Veeam Logoby joshgfeller » Thu Apr 06, 2017 2:40 am

Hello we use full with transaction log backups every 15 minutes. However Now that I've done some more research I didn't realize that veeam could backup transaction logs frequently. I thought you only had the database restore from the image backup. Now that I see veeam has the transaction log backups with point in time recovery it seems maybe the best solution is rely completely on veeam for full and trans log backups and ditch sql server agent backups entirely ?
joshgfeller
Influencer
 
Posts: 10
Liked: never
Joined: Fri Apr 05, 2013 5:14 pm
Full Name: JOsh Gfeller

Re: SQL question

Veeam Logoby Mike Resseler » Thu Apr 06, 2017 4:42 am

Hi Josh,

Veeam can (for example) take an image-level backup every day (or every 12 hours depending on your needs) and then every x minutes ship the logs. Truncation will happen when you do the image-level backup and with application aware processing veeam will take care of it.

As @Kubimike said, having different solutions doing backups and allowing them to play with the logs really can mess thing up and you will end up with broken things in the end. So you want to avoid that. You are going to have to make the call which solution is allowed to work with the logs. I'm certainly not going to try to convince you to choose for Veeam, but I am going to ask you to look at our SQL explorer (https://helpcenter.veeam.com/docs/backu ... tml?ver=95) and I hope you will see that you are going to get a very powerful restore tool (and that is the reason why we backup right ;-))

If you have a DBA, I am sure he is going to like this also

Let us know what you think and don't hesitate to ask more questions.

Cheers
Mike
Mike Resseler
Veeam Software
 
Posts: 2637
Liked: 315 times
Joined: Fri Feb 08, 2013 3:08 pm
Location: Belgium, the land of the fries, the beer, the chocolate and the diamonds...
Full Name: Mike Resseler

Re: SQL question

Veeam Logoby joshgfeller » Thu Apr 06, 2017 1:24 pm

Hello, I think I will give veeam a try on transaction logs and disable sql server agent backups. A couple more questions:

1. Can you define which databases on the DB server get trans logs backed up? Or is it simply by which DB's are in the full recovery model?


2. Sometimes we restore from backup to the SAME server with a DIFFERENT db name and file names for application testing. Can veeam do this restore while writing over the test database or do you have to delete it first?
joshgfeller
Influencer
 
Posts: 10
Liked: never
Joined: Fri Apr 05, 2013 5:14 pm
Full Name: JOsh Gfeller

Re: SQL question

Veeam Logoby kubimike » Thu Apr 06, 2017 2:28 pm

@josh, any DB thats not set to simple will get backed up. Veeam can do this when doing a restore select "Other Server" pick the same server, then you can rename.
kubimike
Expert
 
Posts: 133
Liked: 20 times
Joined: Fri Feb 03, 2017 2:34 pm
Full Name: MikeO

Re: SQL question

Veeam Logoby foggy » Thu Apr 06, 2017 2:36 pm

You can also specify database exclusions, if required.
foggy
Veeam Software
 
Posts: 14091
Liked: 1027 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson


Return to Veeam Backup & Replication



Who is online

Users browsing this forum: Doc and 56 guests