Skip to main content
Solved

Migration 1 SQL Server for new SQL server by commvault


Did this answer your question?
Show first post

89 replies

Forum|alt.badge.img+14
  • Vaulter
  • 243 replies
  • May 11, 2021

Fernando, perform a database restore from the console, once you have performed the SQL database backup from our SQL agent. You have a simplified restore, just select the right choice for you: https://documentation.commvault.com/commvault/v11_sp20/article?p=112786.htm


Fernando Souza
Byte
Forum|alt.badge.img+13

Hello @Ledoesp 

i use this for restore to Disk:
https://documentation.commvault.com/commvault/v11_sp20/article?p=112754.htm

but still restore *.bak Files:
 

 


Fernando Souza
Byte
Forum|alt.badge.img+13
  1. All Tasks\Browser and Restore

Restore do Disk:
 

View Content:
Test_Mirroring Database

Recover All Selected

 


Forum|alt.badge.img+14
  • Vaulter
  • 243 replies
  • May 11, 2021

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

Yes you restore to disk and you get these files, now you can try to use Management Studio to restore from these files or select the additional option Attach to SQL server.


Fernando Souza
Byte
Forum|alt.badge.img+13

Hello @Ledoesp @Mike Struening 

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

 


Fernando Souza
Byte
Forum|alt.badge.img+13

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

 


Forum|alt.badge.img+14
  • Vaulter
  • 243 replies
  • May 13, 2021

Sean Crifasi
Vaulter
Forum|alt.badge.img+9
  • Vaulter
  • 98 replies
  • Answer
  • May 13, 2021

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
Byte
Forum|alt.badge.img+13

Hello

@Ledoesp @Mike Struening @Sean Crifasi 

I was able to do thanks for all!! i´ll put the procedure that i made here.


Fernando Souza
Byte
Forum|alt.badge.img+13

Procedure:
 

Select the MS SQL Database

Recover All Selected

Example:
Change the destination cliente and path

and after “Job Controller”

ok?

 

 

 

 

 


Fernando Souza
Byte
Forum|alt.badge.img+13

Hello 

@Ledoesp @Mike Struening @Sean Crifasi 

The sql database admin verified the restore and it´s OK.

Then now i need to replicate to another SQL Database, in the same version, 

Do i use “Live Sync” or “Continuous Data Replicator" to replicate database SQL?

 


Fernando Souza
Byte
Forum|alt.badge.img+13

Hello Guys,

How can i remove this? i created last month and i don´t know how to remove. This is a test.

 


Fernando Souza
Byte
Forum|alt.badge.img+13

Hello @Ledoesp @Mike Struening @Sean Crifasi 

i made the restore of the database(production) to the new machines, but i´m getting this error, i think is related to licensing, could you help me?
Or am i doing wrong?

i have 3 three license for MS SQL, ok?
 

Production servers:
 

 

New servers:
 

 


Forum|alt.badge.img+14
  • Vaulter
  • 243 replies
  • June 2, 2021

It is license related. You have 3 licenses for the 3 production servers however there is a 4th server named sql01 where you are trying to run a job, not sure if a backup or a restore because you don’t provide the right details.

Release SQL license in sql01 if you are running a restore, if you are running a backup, buy additional licenses or release one for the three SQL production servers.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings