What's up!

Pyaarey Allah!

Wednesday, August 7, 2013

SQL Free up busy database resources

use master
ALTER DATABASE im_test_restore SET SINGLE_USER WITH ROLLBACK IMMEDIATE
  
use im_test_restore;
go
 
checkpoint;
go
 
use master;

go
  
ALTER DATABASE im_test_restore SET MULTI_USER

0 comments: (+add yours?)

Post a Comment