Data Backup and Recovery

How to reconfigure SnapInfo directory in SMSQL

mheimberg
5,369 Views

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
5,370 Views

Hey Markus

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

Peter

mheimberg
5,370 Views

no, unfortunately not.

abhisek
5,370 Views

What is the version of SMSQL are you using ?

Regards,

Abhishek

admchtxpl
5,370 Views

I am using Version 5.0.

Peter

penguinssh
5,369 Views

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
5,369 Views

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
5,370 Views

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!

Public