[SQL Server] Restoring option - BLOB stores

Availability for the Always-On Enterprise

[SQL Server] Restoring option - BLOB stores

Veeam Logoby VanillaMastermind » Wed Sep 21, 2016 2:55 pm

I occasionally need to restore a copy of a database back onto the original server with a different name, such as "DatabaseName_RESTORED" by using "Restore to another server" in the SQL Explorer. I was just testing a restore, and noticed a new option I don't remember seeing before. On the screen where you specify the mdf and ldf file of the restored database, I now see a "BLOB stores" path that needs to be filled. We recently installed Veeam 9 Update 2, so I'm not sure if this is a new feature or if I somehow never saw it before.

What do I enter for "BLOB stores"? I would normally use something like "DatabaseName_RESTORED.mdf" and "DatabaseName_log_RESTORED.ldf" for the data and log files. When I click "browse" on BLOB Stores, it brings me to the root folder such as "D:\\Program Files\Microsoft SQL Server\

Also, when does this "BLOB stores" option show? I only see it showing when restoring from 1 server.
VanillaMastermind
Enthusiast
 
Posts: 32
Liked: 4 times
Joined: Mon Nov 23, 2015 4:47 pm
Full Name: VanillaMastermind

Re: [SQL Server] Restoring option - BLOB stores

Veeam Logoby VanillaMastermind » Thu Sep 22, 2016 1:30 am

I have narrowed this down in my environment. Out of quite a few servers from SQL 2005 - SQL 2016, I have only found a single one, running SQL Server 2014 Developer edition, which is forcing me to pick a BLOB store in Veeam for a restore. Why is this only happening on one server? Is it a server setting? The "production partner" of this server is configured identical (except on SQL Standard Edition), and this does not have the option for a BLOB store.

By default, this BLOB store selection is set to the same file name as the log file. Veeam will not let me proceed and give an error that the file names are the same. If I give the BLOB store an arbitrary name, I get an error "The directory name is invalid". Any suggestions?
VanillaMastermind
Enthusiast
 
Posts: 32
Liked: 4 times
Joined: Mon Nov 23, 2015 4:47 pm
Full Name: VanillaMastermind

Re: [SQL Server] Restoring option - BLOB stores

Veeam Logoby foggy » Fri Sep 23, 2016 2:47 pm

The ability to specify path for BLOB stores is available if the backed up database has BLOB stores configured.
foggy
Veeam Software
 
Posts: 14742
Liked: 1079 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: [SQL Server] Restoring option - BLOB stores

Veeam Logoby VanillaMastermind » Fri Sep 23, 2016 6:40 pm

I have done a default SQL Server installation on this machine. I don't see how BLOB support is a configurable option. Where is this? When I do see this option in Veeam, how do I perform a restore? Right now I can't do a SQL restore in Veeam as I can't seem to put the blob file anywhere. I have to do a FLR restore for now.
VanillaMastermind
Enthusiast
 
Posts: 32
Liked: 4 times
Joined: Mon Nov 23, 2015 4:47 pm
Full Name: VanillaMastermind

Re: [SQL Server] Restoring option - BLOB stores

Veeam Logoby foggy » Mon Sep 26, 2016 10:33 am

You can check whether BLOB stores are configured for the original database right in the Veeam Explorer for SQL Server, when you select the particular database in the databases tree. The database info will list the corresponding path right after the paths for primary and secondary database files. The fact that in your case the log folder is returned as BLOB store path might be a bug, to verify that we need to review log files, so I recommend contacting support with this.
foggy
Veeam Software
 
Posts: 14742
Liked: 1079 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: [SQL Server] Restoring option - BLOB stores

Veeam Logoby VanillaMastermind » Mon Sep 26, 2016 6:22 pm 1 person likes this post

Something definitely doesn't seem right here. When I browse the databases in the Explorer for SQL Server, it is showing the BLOB store as having the same exact name of the log file.

I have opened support ticket 01915589.
VanillaMastermind
Enthusiast
 
Posts: 32
Liked: 4 times
Joined: Mon Nov 23, 2015 4:47 pm
Full Name: VanillaMastermind

Re: [SQL Server] Restoring option - BLOB stores

Veeam Logoby foggy » Wed Sep 28, 2016 6:49 pm

This was confirmed to be an issue with the returned folder path. Will be addressed in the next version.
foggy
Veeam Software
 
Posts: 14742
Liked: 1079 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: Bing [Bot], Yahoo [Bot] and 33 guests