Solved

Migration 1 SQL Server for new SQL server by commvault



Show first post

89 replies

Userlevel 7
Badge +23

@Fernando Souza , I would suggest opening a support case for this.

Let me know the case number so I can follow.

Userlevel 3
Badge +13

Hello @Mike Struening and @Ledoesp

Could you help me?

Userlevel 3
Badge +13

I run the full backup and stop and restart the replicator, but the unavaliable to be continued:
 

 

Userlevel 3
Badge +13

Hello,

The database team access the server and viewed that change some parameters and appear the database in commserv, i make full backup early and create the CDR, but have an error when start the replication:
 

 

Userlevel 7
Badge +23

@Fernando Souza have you had a chance to follow the advice from @Ledoesp ?

Thanks!

Userlevel 5
Badge +13

Please list the available destination instance to see what it is listed and if desired destination instance is selected it populates the destination client publico02 and once destination is selected the databases are displayed in square below:

 

Userlevel 3
Badge +13

Hello @Ledoesp 

The SQL instance in puiblico01:

Don´t appear for me in SQL Live Option
 

 

 

 

 

Userlevel 5
Badge +13

Just in case, have you performed the documented steps?

From the Destination Instance list, select the instance where the software replicates the data.

The Commvault software automatically populates the Destination Clientvalue based on the instance that you select
 

Try it just in case. Otherwise the other reason might be the edition of the engine.

Userlevel 3
Badge +13

The version of MS SQL servers:

If this works? I think no, because doesn´t appear in the CommServ GUI or because the express version.

 

 

 

Userlevel 5
Badge +13

Ricardo, I told you the same yesterday. I’m afraid the problem is that publico01 (source) has a SQLExpress version SQL 2014 while publico02 (destination) version SQL 2019 has a Standard.

Can you try to use a standard SQL 2014 instead of SQLExpress in source?

Also, not sure the commvault version you have in lab, SQL 2019 is supported in v11.16 onwards.

Userlevel 3
Badge +13

i found:
https://documentation.commvault.com/commvault/v11_sp13/article?p=92004.htm

In the online manual it says that it supports the same version or a higher version to Live Sync Operations.

Userlevel 5
Badge +13

From CommVault Java console you can see this at the SQL instance properties:

 

Also in program and features you can get the SQL version installed.

Userlevel 3
Badge +13

Hello @Mike Struening @Ledoesp 

I´m looking for the SQL Versions must be the same to make the replication.

Do you know where i can find it?

Userlevel 7
Badge +23

Great!  I’ll keep an eye here for your update!!

Userlevel 3
Badge +13

The SQL Servers version are diferents in these severs.

i will contact DBA to solve these ands continues the procedure and post that i will make here.

Thannk you!!!! @Ledoesp @Mike Struening 

Userlevel 3
Badge +13

 

Userlevel 7
Badge +23

No, I would expect it to show up.  Can you open a support case and share the case number with me?

Userlevel 5
Badge +13

The software only displays the SQL instances that have the same SQL version or higher than the source database.

Source is SQLExpress and destination SQL Instance is LXPSQL01, what versions they are?

Userlevel 3
Badge +13

Hello @Ledoesp and @Mike Struening 

I made the full backup of my sql server:
 

Then, i will setup the live sync, but don´t appear the second node SQL and neither the database:


 

 

Userlevel 5
Badge +13

Have you performed a SQL backup on the source machine?

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

You must have a backup in order to perform a Live Sync operation. If you have installed the SQL Server agent on the client, but have not yet performed a backup, then the software does not display any databases in the SQL Live Sync Options dialog box.

Also, Note: You can only use the Live Sync feature with SQL databases that use the Full Recovery model.

 

Userlevel 3
Badge +13

Hello @JStainbrook

I need to do a Replication through the CDR Commvault by Live Sync and i will use it for Full Recovery Model SQL Databases.
I´ll read the documentation you sent.

I want to do is Replicate an SQL database from one server to the other server(new) by Commvault CDR.

Is it possible, ok?

I know that the Ideal goal is backup/restore, but that was how the replication was combined and then when migration “turn one side OFF and turn the other side ON”

 

Badge

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?

 

  What is the end goal here? A migration usually consists of a backup/restore and not a replication yet you mention both. Continuous Data Replicator can only replicate flat file system files, to replicate SQL files from one active SQL instance to another, SQL Live Sync would need to be used. Note for SQL Live Sync is that it you can only use it for Full Recovery model SQL databases. The SQL Live Sync documentation should help you through any issues: https://documentation.commvault.com/commvault/v11_sp13/article?p=92005.htm

Badge +15

@Mike Struening

Could you help me? Could you access my labs to discovery these problems?

 

 

WAIT WHAT

 

 

Userlevel 7
Badge +23

@Fernando Souza , I won’t be able to, but if you open a support case (and mention this thread) the Frontline can assign this to one of our SQL experts who can assist you.

Userlevel 3
Badge +13

@Mike Struening 

i dont know, but appeared the Subclient:
 

 

Reply