Question : I just installed SQL server 2016 (Standard edition) on a new server, I’m trying to add a Maintenance […]
Tag: maintenance
PostgreSQL maintenance
Question : I am new to PostgreSQL and want to know more about maintenance options in pgAdmin III. I’ve read […]
Rebuild Index not freeing up space
Question : I had a situation yesterday where my indexes were rebuilt and database size doubled in size (50 % […]
VACUUM did not reduce reported size of database?
Question : I have a database with an extremely large table in postgresql. I’m aware that the only way to […]
Deleting aged rows from postgresql table which don’t have related entries in another table
Question : I maintain a website where users post interesting links, and other users leave replies under the said links. […]
What is the use of “Backup set will Expire:” option while creating Backup Database task in Maintenance plan
Question : While backing up the database, I would like to use “Backup set will Expire:” option to delete/overwrite old […]
shrink ibdata1 in Galera Cluster
Question : I’m having a Galera cluster (3 nodes, but currently using only one), MariaDB 10.0 Galera. However, my ibdata1 […]
Automatically restore SQL Server database from file from another server
Question : We have a daily task to overwrite a number of development databases using backups of the associated production […]
Backup database and clean old backup question
Question : Right now we have a maintenance plan which looks like this: backup all databases clean old backups (> […]
Disk Space Considerations for Rebuilding a large Clustered Primary Key Index
Question : We have a table in our database with over 200 million rows and a Clustered Primary Key Index […]