Tail log backup or use log backup after putting DB into single user mode?
If the DB is set into single user mode which means that no one except me can access database, can I omit using NORECOVERY?


If you are connected to a different database, or when you eventually disconnect any other user can access the SINGLE_USER database.  A Tail Log backup leaves the database in the RESTORING state.  This guarantees that no users can accidentally read or write data to the old database after the cut-over.