We are running legato to backup SQL databases, however one of the servers is failing on two of it’s databases as they are offline, is there a way to put them online in order to run the backup on them but have them ‘blocked’ from running?
There are two ways you can go about this. One would be to set the offline databases to single user mode:
ALTER DATABASESET SINGLE_USER
…then back them up. Any users attempting to access the databases will receive the following error:
Server: Msg 924, Level 14, State 1, Line 1
Database '‘ is already open and can only have one user at a time.
Once the backups have run the databases can be taken back offline.
The other way would be to bring the databases online and change the access permissions to deny access to all users but the one used to run the Legato backups.
The approach you take will necessarily depend on your company’s security policies and the reason the databases are offline to begin with. If it were me, I’d try to avoid constantly changing database states and simply address the access rights to the database.