Kill All Processes Before Database Restore

A useful script for killing all processes in a database i.e. for the purposes of refreshing a training database before restore.


ALTER DATABASE [Training]

SET SINGLE_USER

WITH ROLLBACK IMMEDIATE;

ALTER DATABASE [Training]

SET MULTI_USER;

Then apply your restore script.

Another good link from Pinal Dave.

About AussieBICG

Connect with me here https://au.linkedin.com/in/aussiebicg

1 Response

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s