topic Re: How to force SM-SQL to create a new dataset? in Data Protection

How to force SM-SQL to create a new dataset?

vanhees — Thu, 05 Jun 2025 06:29:40 GMT

Hi,

How can I force Sm-SQL to create a new dataset in Protection Manager? I am in a situation that I need to save the old data set for a while, but want to create a new data set.

Thanks,

Hans

Re: How to force SM-SQL to create a new dataset?

rmharwood — Mon, 16 Apr 2012 12:11:20 GMT

I don't think this can be done. The dataset always has a fixed name and SMSQL will use it if one exists already, or create a new one if it doesn't. Removing the dataset should not remove any volumes so you can still access the snaps, but you can't then use SMSQL to restore from them.

Richard

Re: How to force SM-SQL to create a new dataset?

vanhees — Mon, 16 Apr 2012 12:15:18 GMT

Actually, I just tested this in my lab. What I did was just rename the existing data-set to "-old" or something and SM-SQL does not see a data-set anymore. After that I ran the "configuration wizard" and SM-SQL created a new data-set.

I agree that you will not be able to restore from the old data-set using SM-SQL, this you need to do manually. But for this is enough.

Cheers,

Hans