Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Single User Rss

   Items 1 to 3 of 3   
 

Temporary exclusive database access

This simple script disconnects any other session that is connected to the specified database by temporarily switching the database to single user.  Read more...
By Tom Staab 2015/11/20 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 847 reads

Setting Single User Mode - SQL School Video

This edition of SQL School brings us a look at how to set single user mode for your SQL Server instance.  Read more...
By Andy Warren 2009/07/16 | Source: SQLServerCentral.com | Category: video
Rating: |  Discuss |   Briefcase | 4,109 reads

Backup and Truncate Transaction Logs

Save the transaction log and truncate the file to prevent Tlogs FULL Error  Read more...
Rating: |  Discuss |   Briefcase | 2,657 reads
   Items 1 to 3 of 3   
 
Tags
administration (1)    
backup and restore (1)    
truncate log (1)    
video (1)