commvault.com commvault.com
Solved

Migration 1 SQL Server for new SQL server by commvault

Show first post

89 replies

Mike Struening RETIRED
Rank
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.

https://www.linkedin.com/in/michael-struening
Fernando Souza
Rank
Userlevel 3
Badge +13

Hello @Ledoesp @Mike Struening 

In short, i was unable to do it, continue to restore *.bak files.

 

Fernando Souza
Rank
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.

 

Fernando Souza
Rank
Userlevel 3
Badge +13

All these MS SQL Database restores brings *.bak
Example:

 

Mike Struening RETIRED
Rank
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.

https://www.linkedin.com/in/michael-struening
Fernando Souza
Rank
Userlevel 3
Badge +13

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

 

Mike Struening RETIRED
Rank
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.

https://www.linkedin.com/in/michael-struening
Fernando Souza
Rank
Userlevel 3
Badge +13

@Mike Struening 

I start the full backup, wait for finish:
 

 

Fernando Souza
Rank
Userlevel 3
Badge +13

I think it´s ok:
 

And now?

Fernando Souza
Rank
Userlevel 3
Badge +13

 

Fernando Souza
Rank
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

Mike Struening RETIRED
Rank
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.

https://www.linkedin.com/in/michael-struening
Fernando Souza
Rank
Userlevel 3
Badge +13

These SQL servers

need to replicate Database Servers:
publico01 ==> publico02

 

Fernando Souza
Rank
Userlevel 3
Badge +13

Hello @Ledoesp @Mike Struening 

Do i need to install CommServe LiveSync package in my CommServe?
 

 

Mike Struening RETIRED
Rank
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?

https://www.linkedin.com/in/michael-struening
Fernando Souza
Rank
Userlevel 3
Badge +13

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

Fernando Souza
Rank
Userlevel 3
Badge +13

@Mike Struening 

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

The Lab:


 

 

Fernando Souza
Rank
Userlevel 3
Badge +13

Yes, 

And the database appears to be made the Sync:
 

 

Fernando Souza
Rank
Userlevel 3
Badge +13

@Mike Struening 

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

 

Fernando Souza
Rank
Userlevel 3
Badge +13

I need to replicate to another server, this is a Laboratory.

But when i finish the LyveSync setup, it does nothing; and i saw that CommServe LiveSync” is not installed:
 

 

Fernando Souza
Rank
Userlevel 3
Badge +13

@Mike Struening 

i dont know, but appeared the Subclient:
 

 

L
Rank
Userlevel 5
Badge +13

you have to follow these steps: https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/restore-a-database-to-a-new-location-sql-server?view=sql-server-ver15

Sean Crifasi
Rank
Userlevel 4
Badge +9

Hi @Fernando Souza 

 

  • Can you confirm the databases are configured in full mode on the sql server?
  • Have you completed an initial full backup of the SQL subclient yet?

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.

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

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

Fernando Souza
Rank
Userlevel 3
Badge +13

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

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

Reply


Terms & ConditionsCookie settings