Solved

Migration 1 SQL Server for new SQL server by commvault



Show first post

89 replies

Userlevel 3
Badge +13

@Mike Struening 

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

 

Userlevel 3
Badge +13

@Mike Struening 

i have a doubt: Why is diferent?
The Client:

The Lab:


 

 

Userlevel 3
Badge +13

These environment is the lab, don´t have support contract.

Userlevel 3
Badge +13

These SQL servers

need to replicate Database Servers:
publico01 ==> publico02

 

Userlevel 7
Badge +23

@Fernando Souza at this point I am not sure why it is not showing up.  Can you call in a Support ticket and share back the case number?

This way I can follow it and bring the resolution back for posterity.

Userlevel 3
Badge +13

SQL Live Sync Options:
There is another server SQL [publico02] and has a SQL server installed, the same version.

but don´t show, why?

I need to replicate SQL Database to another SQL server

Userlevel 3
Badge +13

 

Userlevel 3
Badge +13

I think it´s ok:
 

And now?

Userlevel 3
Badge +13

@Mike Struening 

I start the full backup, wait for finish:
 

 

Userlevel 7
Badge +23

Thanks!

Kick off a Full SQL iDA backup and once it completes, check the Live sync tab and let me know if the database shows up.

Userlevel 3
Badge +13

I install this agents.
**I uninstall e reinstall the server in the CommCell

 

Userlevel 7
Badge +23

Run a full backup for the source SQL client first.

Next, go back to the Live sync setup and you should see the database listed.

This is the database that will be synched to the other destination client.

Once that’s set up, you should be golden.

Userlevel 3
Badge +13

@Mike Struening 

Don´t have a backup full, 

i can not add the SQL Database in the backup, don´t find the database in the server.

i installed the sql agent, but not find.

i updated the CommCell and i remove and re-add but not find the SQL instance.

 

Userlevel 7
Badge +23

@Fernando Souza , not sure if you saw my other reply:

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

Hello @Mike Struening 

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

Do you know what is the problem?

Userlevel 3
Badge +13

hello @Mike Struening 

i update the commcell and try to configure again.

 

 

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 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

I think need to update:
 

What do you think?

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 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 @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 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

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

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?

Reply