This project is read-only.

Backup server objects

Backup Logins - server principals Custom server roles

Id #1678 | Release: None | Updated: Today at 11:31 AM by NielsGrove | Created: Jan 23, 2014 at 6:28 AM by NielsGrove

Test backup files

Create backup files for testing.   Full backup chain: FULL - DIFF - LOG. Several chains. Several databases. Several MSSQL versions: 2005 - 2008 - 2008R2 - 2012   Northwind

Id #1122 | Release: None | Updated: Today at 11:31 AM by DN_Niels | Created: Apr 27, 2012 at 8:07 PM by NielsGrove

Spike: C++

Try making an application using C++ to improve performance, harden implementation and reduce capacity requirements.   Multithreading to parallelize component execution like database backup and gene...

Id #1107 | Release: None | Updated: Feb 1, 2013 at 1:55 AM by NielsGrove | Created: Apr 16, 2012 at 8:13 PM by NielsGrove

Encrypt the backup file

Encrypt the backup file (AES 256). Do not write unencrypted data to disk.

Id #1106 | Release: None | Updated: Feb 1, 2013 at 1:55 AM by NielsGrove | Created: Apr 16, 2012 at 8:11 PM by NielsGrove

Backup database replication

Generate DDL script for Distributor, Publisher and Subscriber.

Id #1105 | Release: None | Updated: Feb 1, 2013 at 1:55 AM by NielsGrove | Created: Apr 16, 2012 at 8:10 PM by NielsGrove

Backup mirroring

Write dublicate backup files to different locations in a single (parallel) backup operation.

Id #1104 | Release: None | Updated: Feb 1, 2013 at 1:55 AM by NielsGrove | Created: Apr 16, 2012 at 8:09 PM by NielsGrove

Backup files housekeeping

Implement separate task for housekeeping on the archive: Is the backup file in the archive? Remove old generations (1+) of backup files from local storage.   Integration with external backup system...

Id #1103 | Release: None | Updated: Today at 11:31 AM by NielsGrove | Created: Apr 16, 2012 at 8:07 PM by NielsGrove

Parallel backups

Backup multiple databases in parallel.

Id #871 | Release: None | Updated: Today at 11:31 AM by NielsGrove | Created: Feb 3, 2012 at 6:39 PM by NielsGrove

SQL Agent proxies

Generate scriptfile on all SQL Agent proxies. Inclusive credentials?

Id #870 | Release: None | Updated: Feb 1, 2013 at 1:55 AM by NielsGrove | Created: Feb 3, 2012 at 6:31 PM by NielsGrove

SQL Agent jobs

Generate scriptfile for existing SQL Agent jobs. Inclusive jobsteps and associated schedules.

Id #869 | Release: None | Updated: Feb 1, 2013 at 1:55 AM by NielsGrove | Created: Feb 3, 2012 at 6:30 PM by NielsGrove