Solved

Migration 1 SQL Server for new SQL server by commvault


Userlevel 3
Badge +13

Hello,

the cliente need to migrate MS SQL Server database for the new server by Continuous Data Replicator.

Someone already made this procedure and can help me?

I install SQL Server in 2 servers and add to Commcell.

Current version of Commvault: 11 SP 13+

**Do i need to upgrade Commvault before migrating?

Current version of SQL: 2012

And the cliente is asking to me what the best version will migrate? 2019 standard or enterprise?

 

icon

Best answer by Sean Crifasi 13 May 2021, 20:11

View original

89 replies

Userlevel 3
Badge +13

The question: Do i need more SQLlicenses to migrate SQL Servers?

Userlevel 3
Badge +6

Hi Fernando,

 

you should always upgrade Commvault to a recent/supported version. The latest release has improvements for CDR.

What do you mean about the license from Commvault perspective? Its part of Commvault Complete. So it depends what licenses you currently own

Userlevel 3
Badge +13

Hello @M Scheepers 

Regarding to upgrade Commvault 
Current version of Commvault: 11 SP 13+

i will need to update before migrating SQL.

But the license i would like to know if need to acquire new licenses before migrate the SQL servers.

Userlevel 3
Badge +6

hi @Fernando Souza,

what do you want to achieve?

Is the SQL of the Commserve needs to be migrated/upgraded or a other client in the environment?

the need of SQL standard or SQL Enterprise is depending on the functionality needs.

Userlevel 3
Badge +13

@M Scheepers 
Ok, i understand, but need more add more license for add this new client to migrfate the SQL Server? or for example: there are a limitationsof the connections concurrents for backups or whatever.

is there any limitation between SQL Standard and the entrerprise Version for Commvault?

Because the customer need to purchase the license and have this doubt.

is there a doc (website) explain about this type of license (SQL)?
Userlevel 3
Badge +6

@Fernando Souza 
for Commvault functionality it doesn’t matter, Enterprise is only needed if you want use other SQL functionalities what isn’t available with SQL standard.

https://documentation.commvault.com/commvault/v11_sp20/article?p=1720.htm

 

Userlevel 3
Badge +13

The major question: procedure to  migrate SQL Database by (Commvault) Continuous Data Replicator.

Userlevel 3
Badge +13

Do i need new licenses before migrate SQL Servers? because i use  the actual sql license to the new server

Userlevel 7
Badge +23

@Fernando Souza , are you asking if the actual Microsoft SQL server needs to be licensed, or if you need to increase your commvault licensing?

CV licensing needed for a SQL agent (which leads to the full licensing guide): https://documentation.commvault.com/commvault/v11_sp20/article?p=18120.htm

If you have an instance of SQL running, it would need to have a valid MSFT license (assuming you are not referring to the Commserve which is already licensed: https://documentation.commvault.com/commvault/v11_sp20/article?p=2801.htm)

 

Userlevel 3
Badge +13

Hello @Mike Struening

I need to know if i need license for commvault when i add new SQL Server to migrate.

Userlevel 7
Badge +23

Possibly, but not likely….what is your licensing type?  Do you have Capacity Licensing set up?

This might be a conversation for your Account Rep (in case you DO need additional licensing though you can review the full licensing guidehere: https://documentation.commvault.com/commvault/v11_sp20/article?p=18120.htm

I would expect if you have capacity licensing and room to space, then you should be just fine.

Userlevel 3
Badge +13

Hello @Mike Struening 

I don´t think i need to acquire new licenses, but can you help me? *If i need new licenses.

The license:
 

 

 

 

 

Userlevel 7
Badge +23

Thanks @Fernando Souza !!

I reread your posts and it sounds like you already added both SQL servers needed….is that right?

You have 3 Application class 1 licenses and all 3 are in use (I’m assuming these are physical servers, not vms) so I think you’re ok.

If you STILL need to install this SQL server, and have 3 other servers installed using the 3 availablethen you are out of licenses (only your account rep can get you more).

You also have Commvault Complete for Virtual Machines (for 10 vms) and don’t seem to be using any right now, so that’s an option, potentially.

Userlevel 7
Badge +23

@Fernando Souza have you had a chance to confirm the above?  Did you already install the SQL iDAs or do you need to install another one?

Userlevel 5
Badge +13

It is not very clear the original question.

 

  1. do you want to perform a hardware refresh of the CommServe in order to have a more updated version of SQL? Follow procedure described in our documentation.
  2. You want to restore a SQL database from server 1 with SQL2012 (source) to server 2 with SQL in higher version (destination). Perform an out of place restore with SQL agent or if you don’t have enough license, create a dump and restore it in destination outside of CommVault. Why do you need CDR here?
Userlevel 3
Badge +13

Hello @Ledoesp

The customer wants MS SQL Server 2012 to migrate from a new server by CDR Commvault.

Questions:
1) Do I need an SQL license to add the MS SQL server (new)?
(I think no)
2) Are you recommending using an area to do the out of place and restore by MS SQL, without needing to use commvault?
3) the client will update the version before and then migrate the MS SQL database by commvault.

Userlevel 5
Badge +13

Fernando, you are mentioning CDR (ContinousData Replicator) but then you refer to SQL agent.

1)  Do I need an SQL license for the new MS SQL server?

If you mean a Microsoft license, yes you need one.

If you need a CommVault SQL agent license, yes you need as you have already used 3 Application Class 1 licenses of a total of 3. The good thing is that you can install in restore mode the SQL agent on the new server, once restored is completed, you can release license from the old SQL server and then activate the license on the new server and enable its scheduling.

​​​​2)​​​ If you don’t have enough licenses for our SQL agent, you can do dumps to disk in your maintenance plans and use FS or VSA agent to collect them. You can use this for performing the migration. There are more than 1 way to achieve an outcome in life. (it sounds a bit philosophical). I am afraid using CDR is not the right approach, not even when there is unlimited CDR licenses in this CommCell.

3) Updating from v11 SP13 to a more recent and supported version of CommVault it is good start.

 

 

Userlevel 3
Badge +13

Hello @Ledoesp 

i made a test, the DBA create a SQL database for a one server and i replicate by CDR

Server: publico01

Server: publico02 (Replication Server)

The Database was create in c:\SQL2014

and i replicated in another server c:\public01\...\SQL2014

One question: The CDR just copy the file systems or can create a database in MS SQL and other things more?
 

Userlevel 7
Badge +23

@Fernando Souza are you replicating the flat files?

why not set up a Live Sync and do it all within SQL?

https://documentation.commvault.com/commvault/v11/article?p=92004.htm

I think this is what you are asking at the end there :nerd:

Userlevel 3
Badge +13

Hello @Mike Struening 

I uninstalled and installed the Commvault agent, because I was not looking at the SQL Database.and the link sent says it must have at least 1 sql live sync backup done.

Then i installed the agent again:
 

So, dind´t find the SQL Database:
 

Can you help me?

Userlevel 3
Badge +13

I think need to update:
 

What do you think?

Userlevel 7
Badge +23

Can you confirm that there is at least one full backup to seed the sync?

From that doc:

Before You Begin

  1. Install the SQL Agent on the destination host. For more information, see Getting Started with the SQL Server Agent.
  2. Add a SQL instance in the CommCell Console for the destination instance. For more information, see Instances for the SQL Server Agent.
  3. Make sure that you have a backup for the database that you want to use for the Live Sync operation.

If you do, then we may need to get a support case created.

Userlevel 3
Badge +13

@Mike Struening 

I´m updating this Commvault, is a lab. 

when finish the update i will config this and send a message here.

 

Userlevel 3
Badge +13

hello @Mike Struening 

i update the commcell and try to configure again.

 

 

Userlevel 3
Badge +13

Hello @Mike Struening 

Don´t find the Database in the SQL Live Sync Options:
 

Do you know what is the problem?

Reply