Activity overview
Latest activity by EdVassie
Feature Request - Allow a COPY_ONLY backup to be registered
It should be possible to register a COPY_ONLY backup so that it can be used in a restore in the same way as a normal backup.
A COPY_ONLY backup does not reset the dirty bits used to control a diffe...
Feature Request - ODBC Driver for SQL Backup
One of Reg Gate's competitors has a cool feature where they have provided a ODBC driver for their backup files. A similar feature would enhance SQL Backup by making any of the following possible:
...
Feature Request - Offline Backup
A potential key differentiator for SQL Backup compared to the competition would be the ability to take a backup of a database that is not attached to SQL Server.
Consider the following scenario:
1)...
alecl,
When BMC and CA did this for DB2, they did it on their own. There was no vendor API to help.
My understanding from when I worked at BMC is they worked out what a valid page should look like, and highlighted any inconsistencies. Different pages (data, index, space map, etc) each have their own formats. Where relevant, pointers to next/previous pages (eg for spacemaps, etc) were checked to ensure the target page was of the correct type. CA must have done something similar for their product but which did not violate the BMC patents, as these 2 companies were and still are very serious rivals.
The BMC product had various levels of integrity check the DBA could ask it to do. The most expensive checked that all index RIDS pointed to the right data, and that all off-page pointers went to whatever was valid.
Most installations settled on the option do do page consistency and spacemap (etc) chain checks. This was the option that added only about 5% to elapsed time. The little feedback I had about the more complex options was they were shelfware.
After about 10 years, IBM as DB2 vendor also thought that inline consistency checks were a good idea and added it to their own backup product.
The moral of all this is Red-Gate could add inline consistency checks to SQL Backup without any additional help from Microsoft. However, I have posted this request on Connect so vote for it if you want: https://connect.microsoft.com/SQLServer ... kID=340720 / comments
alecl,
When BMC and CA did this for DB2, they did it on their own. There was no vendor API to help.
My understanding from when I worked at BMC is they worked out what a valid page should look like...
Feature request - Omit indexes on restore
Description:
The restore process should have an option to omit all non-clustered indexes during a restore. The index definitions should be restored, but the index data omitted.
Pages that containe...
Feature Request - Release unused space on Restore
Description
The backup process should have an option to release unused space on a restore. Separate options may be useful for data and log files.
For a data file, where the restore finds an empty ...
Feature Request - Inline integrity check
Description
Include the processing normally done by a DBCC CHECKDB inline with running a backup.
Most of the time required to do a CHECKDB is the time needed to read the DB files. Likewise most of...
Feature Request - merge backups
Description
Ability to merge multiple backup files and create a new backup file.
e.g.1 Take a Full backup file and the subsequent transaction log backup files, and create a new full backup file to ...