We have prepared a number of SQL queries that you might find useful for
database administration.
| Category |
Contents |
| Users |
- List of all SQL Server users
- List of users with database access
|
| Backup/Restore
Database |
- Database backup
- List of backups
- Get file names from backup
- Database restore
- Database restore by moving database to other location
|
| Databases |
- List of databases and their status
- Check whether a database belongs to PANTHEON
- ATTACH database
- DETACH database
- Log size
|
| Jobs |
- List of categories
- Types of job steps
- Determine server name
|