https://learn.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-clonedatabase-transact-sql?view=sql-server-ver16

YES but merge join requires SORT operation

hello ,

You should click on the 'refresh' button after entering the master key password.

hello ,

Use the setspn command to manually register the SPN. The command usually looks like this:

setspn -A MSSQLSvc/FQDN:port DOMAIN\service_account

small question I don't understand why you disabled the resumable option

but this allows you to pause rebuilding

this is taken by default from framwork 4.6

I have This error message

• This reply was modified 4 years, 1 month ago by  abdalah.mehdoini.

I did not understand

thank you very much

the module has been installed

I can't install this module there

the result of the order

Get-Installed Module

Install-Module -Name SqlServer

thanks for your help

but this is from sql server 2016

I am with sql server 2014

you need 3 ip address for the cluster and 3 ip address for the listener

does this command move the sql server service and the agent service

sorry I'm a little confused

<!--more--><!--more-->

https://docs.microsoft.com/en-us/powershell/module/failoverclusters/suspend-clusternode?view=win10-ps

Msg 3101, Level 16, State 1, Line 3Exclusive access could not be obtained because the database is in use.Msg 3013, Level 16, State 1, Line 3RESTORE DATABASE...