-
- Enthusiast
- Posts: 27
- Liked: 2 times
- Joined: Jan 06, 2012 10:16 am
- Full Name: Synthos Kralupy
- Contact:
SQL log backup for specific DB only?
Hello,
is possible somehow define to backup transaction logs from specific SQL databases only? As I see SQL transaction log process is taking backup of all DBs and all instances with Full recovery model. I know, I can switch DBs to Simple mode to workaround this, but...
Thanks.
Pavel.
is possible somehow define to backup transaction logs from specific SQL databases only? As I see SQL transaction log process is taking backup of all DBs and all instances with Full recovery model. I know, I can switch DBs to Simple mode to workaround this, but...
Thanks.
Pavel.
-
- Veteran
- Posts: 3077
- Liked: 455 times
- Joined: Aug 07, 2018 3:11 pm
- Full Name: Fedor Maslov
- Contact:
-
- Enthusiast
- Posts: 27
- Liked: 2 times
- Joined: Jan 06, 2012 10:16 am
- Full Name: Synthos Kralupy
- Contact:
Re: SQL log backup for specific DB only?
Wow! Thanks, it looks great
I am still running VBR 9.5 U3a, do you know if will works? Document is related to Update 4.
Pavel.
I am still running VBR 9.5 U3a, do you know if will works? Document is related to Update 4.
Pavel.
-
- Veteran
- Posts: 1943
- Liked: 247 times
- Joined: Dec 01, 2016 3:49 pm
- Full Name: Dmitry Grinev
- Location: St.Petersburg
- Contact:
Re: SQL log backup for specific DB only?
Sure, you can see in the KB it can be applied to versions 8.x, 9.x. Thanks!
-
- Enthusiast
- Posts: 27
- Liked: 2 times
- Joined: Jan 06, 2012 10:16 am
- Full Name: Synthos Kralupy
- Contact:
Re: SQL log backup for specific DB only?
It's perfect. I suppose some service on VBR server should be restarted, isn't it? To re-read new registry settings. SQL log backup process is still processing all DBs.
Thanks.
Thanks.
-
- Veteran
- Posts: 1943
- Liked: 247 times
- Joined: Dec 01, 2016 3:49 pm
- Full Name: Dmitry Grinev
- Location: St.Petersburg
- Contact:
Re: SQL log backup for specific DB only?
Yes, you should restart Veeam related services, but don't forget to stop all activities on the backup server prior doing it. Thanks!
Who is online
Users browsing this forum: Google [Bot] and 53 guests