AvailabilityDatabase.SuspendDataMovement Método
Suspends the data movement on this availability database.
Espacio de nombres: Microsoft.SqlServer.Management.Smo
Ensamblado: Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Sintaxis
'Declaración
Public Sub SuspendDataMovement
'Uso
Dim instance As AvailabilityDatabase
instance.SuspendDataMovement()
public void SuspendDataMovement()
public:
void SuspendDataMovement()
member SuspendDataMovement : unit -> unit
public function SuspendDataMovement()
Comentarios
Data movement on this availability database may not yet have been suspended after a call to SuspendDataMovement() returns control to the program. The following code snippet suggests one way to pause program execution until data movement on this availability database is suspended:
Server server = new Server("PrimaryServerName");
AvailabilityGroup ag = server.AvailabilityGroups["AgName"];
AvailabilityDatabase dbToSuspend = ag.AvailabilityDatabases["DbName"];
dbToSuspend.SuspendDataMovement();
while (!dbToSuspend.IsSuspended) {
Thread.Sleep(10000);
dbToSuspend.Refresh();
}