Data Backup and Recovery Discussions

How to reconfigure SnapInfo directory in SMSQL

mheimberg

Hi

We are running a MS SQL server with several different databases each placed on a separate LUN. That means: there are 6 DBs, for each we have a DB-LUN and a LOG-LUN, sums up to 12 LUNs plus a single SnapInfo-LUN.

The LUNs were mounted by mountpoints.

Now all of a sudden SMSQL complains during the full backup of one DB:

...

[19:50:14.334]  Getting SnapInfo directory info...

[19:50:14.334]  Failed to get SnapInfo directory from registry, please re-run the Configuration Wizard.

...

'til then the structure in the SnapInfo was very clear and readable:

E:\snapinfo\SMSQL_SnapInfo\SQL__ServerName\

and underneath an entry for each DB:

DB__firstDb

DB__secondDB

DB__thirdDB

...

Because the error message was so clear I re-run the config wizard, but now we got an additional directory in the SnapInfo:

E:\snapinfo\SMSQL_SnapInfo\VDISK__MountPoint-001

and in this directory a subdir

FG__\ServerName

Backup is working now, but the funny thing is, that now SMSQL remembers the old SnapInfo location:

...

[09:56:41.979]  SnapManager finds an alternative snapinfo directory for database [IQSCAQ] of [ServerName] at:

[09:56:41.979]  E:\snapinfo\SMSQL_SnapInfo\SQL__ServerName\DB__IQSCAQ

[09:56:41.979]  Renaming alternative snapinfo directory...

...

The Question is:

how do I get rid of the newly created SnapInfo directory "VDISK__MountPoint-001" and tell SMSQL to store its data in the former and proper named directory E:\snapinfo\SMSQL_SnapInfo\SQL__ServerName\DB__IQSCAQ?

Where does SMSQL stores the SnapInfo config information?

And why after all created the Configuration Wizard a new directory?

thx

Mark

7 REPLIES 7

admchtxpl

Hey Markus

Ever got this solved? I'm in the same situation right now.

Peter

mheimberg

no, unfortunately not.

abhisek

What is the version of SMSQL are you using ?

Regards,

Abhishek

admchtxpl

I am using Version 5.0.

Peter

penguinssh

I've had the exact same issue when reconfiguring it the other day. 

I resolved all my issues by going through the Reconfiguration Wizard. 

I then recreated all my backup jobs with the exact same settings. 

Have you tried this yet?

admchtxpl

No did not try this yet, because I'm not sure if it stops any SQL services when going through the complete config wizard.

Does it, or not?

Peter

penguinssh

It shouldn't stop any services.  Just make sure that when you reconfigure it, you don't move any DBs/Luns and it won't stop any services.  If you do move DBs on a different Lun, it will stop only this database but not the actual SQL database engine. 

Let us know!

Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public