Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Suspends the data movement on this availability database.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
Public Sub SuspendDataMovement
'Usage
Dim instance As AvailabilityDatabase
instance.SuspendDataMovement()
public void SuspendDataMovement()
public:
void SuspendDataMovement()
member SuspendDataMovement : unit -> unit
public function SuspendDataMovement()
Remarks
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();
}