SQL Restore with NORECOVERY

Availability for the Always-On Enterprise

SQL Restore with NORECOVERY

Veeam Logoby john.heimiller » Wed 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).
john.heimiller
Novice
 
Posts: 4
Liked: 2 times
Joined: Thu Oct 01, 2015 3:11 pm
Full Name: John Heimiller

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

Veeam Logoby Vitaliy S. » Fri 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.
Vitaliy S.
Veeam Software
 
Posts: 19465
Liked: 1092 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

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

Veeam Logoby johannesk » Tue 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.
johannesk
Influencer
 
Posts: 22
Liked: 3 times
Joined: Tue Jan 19, 2016 1:28 pm
Full Name: Jóhannes Karl Karlsson

[MERGED] SQL restore with norecovery

Veeam Logoby bubbagump » Fri 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?
bubbagump
Influencer
 
Posts: 18
Liked: 2 times
Joined: Mon May 30, 2016 12:18 am

Re: SQL Restore with NORECOVERY

Veeam Logoby v.Eremin » Mon 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.
v.Eremin
Veeam Software
 
Posts: 13102
Liked: 950 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin


Return to Veeam Backup & Replication



Who is online

Users browsing this forum: Google [Bot], tommyo and 69 guests