Comprehensive data protection for all workloads
Post Reply
john.heimiller
Novice
Posts: 4
Liked: 2 times
Joined: Oct 01, 2015 3:11 pm
Full Name: John Heimiller
Contact:

SQL Restore with NORECOVERY

Post by john.heimiller » Dec 16, 2015 8:16 pm 1 person likes this post

Sorry if this thread is stale....I searched for NORECOVERY and found one here and went to the bottom.
For a SQL DBA, VEEAM is really lacking...not only are the interfaces clunky ... there are few recovery options that the SQL DBA really needs at crunch time. So what if there's a limited set of vanilla options to recover point-in-time from the most recent "successful" backup. What if a daily full backup fails...what if the DBA needs to do a one-off log backup and break the chain. what if a DBA needs to recover some tlog backups and not all. What if we need to recover with NORECOVERY or STANDBY. what if we want to log-mine....where are the tlog backups? inaccessible, that's where. The options you provide might impress a systems infrastructure guy who cares about VM recovery (which I'm sure Veeam does great)...but its totally maddening as a DBA trying to use your tools and system which has usurped all the capability out of SQL Server backup and Restore. VEEAM, it just DOESN'T work (for SQL).

Vitaliy S.
Product Manager
Posts: 23070
Liked: 1582 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Feature Request: Point in time recovery for SQL database

Post by Vitaliy S. » Dec 18, 2015 11:37 am

Hi John! For other options (not available) in Veeam you can always use native tools (store logs backup locally and then backup the entire VM), but thanks for your feedback on our current functionality.

johannesk
Enthusiast
Posts: 56
Liked: 9 times
Joined: Jan 19, 2016 1:28 pm
Full Name: Jóhannes Karl Karlsson
Contact:

Re: Feature Request: Point in time recovery for SQL database

Post by johannesk » Sep 20, 2016 11:15 am

I'm needing this functionality to be able to restore a SQL DB with no recovery.

- it will make big database migrations (moving a db from on SQL to another) much quicker. Hence you can restore the Full backup with no recovery (might easily take 60-120 minutes). Then do a log backup of the source DB and have a quick restore of the db to the new target that would only take a few minutes the most.

- by having the possibility to do SQL DB migrations this way, you won't need a scratch disk for the backup when using SQL management studio or TSQL, since you can use the data from the backup system.

please put this on the roadmap.

bubbagump
Influencer
Posts: 18
Liked: 2 times
Joined: May 30, 2016 12:18 am
Contact:

[MERGED] SQL restore with norecovery

Post by bubbagump » Apr 07, 2017 10:12 pm

My DBA threw me a curve ball. I know we can certainly recover to a point in time in Veeam. His challenge is, can you recover a full in NORECOVERY mode so that he can manually apply logs? The specific scenario is for pre-seeding AlwaysOn Availability groups ala here: https://docs.microsoft.com/en-us/sql/da ... sql-server

Is there any way to do this? I have tried to see if I can force a DB into NORECOVERY somehow to no avail. The best I could come up with is simply to create a full through native SQL tools to a BAK file like the olden days and skip Veeam all together. Is there a way with Veeam that folks have accomplished this? Even if Veeam is only used for part of the equation?

veremin
Product Manager
Posts: 17005
Liked: 1455 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: SQL Restore with NORECOVERY

Post by veremin » Apr 10, 2017 11:13 am

We've received similar feedback already, and this request has been tracked. Thank you for sharing your thoughts in this regard; appreciated.

NicolasM
Service Provider
Posts: 11
Liked: never
Joined: Jan 30, 2017 2:13 pm
Full Name: Nicolas
Location: Switzerland
Contact:

Re: SQL Restore with NORECOVERY

Post by NicolasM » Dec 12, 2017 2:06 pm

Are there any updates / news regarding this feature request? A customer of mine contacted me last week and asked if Veeam B&R can do SQL restores with NORECOVERY option.

foggy
Veeam Software
Posts: 18366
Liked: 1575 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL Restore with NORECOVERY

Post by foggy » Dec 12, 2017 4:32 pm

Nothing to share at the moment.

Gostev
SVP, Product Management
Posts: 24939
Liked: 3622 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: SQL Restore with NORECOVERY

Post by Gostev » Dec 13, 2017 5:41 pm 1 person likes this post

I suppose I can share that this functionality is being worked right now, but I am not sure yet which update it will be shipped in - this will depend on a few features competing for the same dev/QC resources.

NicolasM
Service Provider
Posts: 11
Liked: never
Joined: Jan 30, 2017 2:13 pm
Full Name: Nicolas
Location: Switzerland
Contact:

Re: SQL Restore with NORECOVERY

Post by NicolasM » Dec 18, 2017 12:07 pm

Thanks for sharing, nice to hear that this feature is being worked on. :-)

simon_b
Lurker
Posts: 1
Liked: never
Joined: Dec 20, 2017 6:26 pm
Contact:

Re: SQL Restore with NORECOVERY

Post by simon_b » Dec 21, 2017 9:48 pm

So, is the ability to restore with NORECOVERY in this week's release of Update 3?

foggy
Veeam Software
Posts: 18366
Liked: 1575 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL Restore with NORECOVERY

Post by foggy » Dec 22, 2017 2:01 pm

No, it is not there.

Gostev
SVP, Product Management
Posts: 24939
Liked: 3622 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: SQL Restore with NORECOVERY

Post by Gostev » Dec 22, 2017 5:10 pm

Not so fast, as I've said it still being developed :D

NicolasM
Service Provider
Posts: 11
Liked: never
Joined: Jan 30, 2017 2:13 pm
Full Name: Nicolas
Location: Switzerland
Contact:

Re: SQL Restore with NORECOVERY

Post by NicolasM » May 15, 2018 7:47 am

Does anyone have any News worth sharing regarding the development of this feature? :-)

NicolasM
Service Provider
Posts: 11
Liked: never
Joined: Jan 30, 2017 2:13 pm
Full Name: Nicolas
Location: Switzerland
Contact:

Re: SQL Restore with NORECOVERY

Post by NicolasM » Sep 18, 2018 7:22 am

Any chance this will be included in Update 4 or sometime in the near future?

Gostev
SVP, Product Management
Posts: 24939
Liked: 3622 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: SQL Restore with NORECOVERY

Post by Gostev » Sep 18, 2018 1:05 pm

Yes, it will be included in Update 4.

NicolasM
Service Provider
Posts: 11
Liked: never
Joined: Jan 30, 2017 2:13 pm
Full Name: Nicolas
Location: Switzerland
Contact:

Re: SQL Restore with NORECOVERY

Post by NicolasM » Sep 25, 2018 10:52 am

Oh these are great news, thanks for sharing, looking forward to the release of update 4 then. :-)

Post Reply

Who is online

Users browsing this forum: Google [Bot] and 16 guests