Browsing the blog archives for May, 2015

Bug in sys.fn_hadr_backup_is_preferred_replica

While testing backups in SQL Server 2014 Availability Groups I hit a bug in a system function that is used to determine which replica is the most appropriate to be backed up. You can set the desired backup pattern by RIGHT clicking on the availability group to bring up the properties:     Iā€™ve decided […]

0 Comments

View to get DB Size

The DBCC SQLPERF(logspace) is a handy routine to check the transaction log sizes.  But it does have some limitations: The log file size is in KB.  All of our databases are in GB, so I end up unconsciously converting the KB output into GB. Saving the data to a table is not convenient. It provides […]

0 Comments

Netezza: Restore a table from an INCREMENTAL Backup

Netezza supports 2 types of backups: FULL INCREMENTAL CUMULATIVE ā€“ All changes since the last FULL backup DIFFERENTIAL ā€“ All changes since the last FULL or CUMMULATIVE The first step to restore a single table is to see what backups we have.  Note: That NZ calls the FULL backup Increment #1. Determine what incremental backups […]

0 Comments