SQL Backup uses the 'ALTER DATABASE [..] SET OFFLINE WITH ROLLBACK IMMEDIATE' command to disconnect any existing users.
Do you know why the DISCONNECT_EXISTING option failed? Was it because the rollback process took a while to complete, or that another process was blocking SQL Server from taking the database offline?
SQL Backup Consultant Developer
Associate, Yohz SoftwareBeyond compression
- SQL Backup goodies under the hood, updated for version 8