• We do two types of backups.

    As DBA, I schedule my backups of the SQL2005 servers using SQLbackup routines for time that are best for the databases and save to disk on one of the other servers and vice a versa. The Windows admin then has a nightly backup routine that goes in and does it's backup of the system files and the backup folder with the database backups. Since the backup application can trigger at any time within a window this works as best control.

    For older servers with SQL 2000, we don't have the space to do the Sql backup routines as described above. So we use the 3rd party app to do the backup but I sit with the Windows Admin and decide what databases are needed to be backed up and at what schedule. The 3rd party app sees "all" databases and cannot determine what is offline and the Windows adm wouldn't know this.

    Future builds will be according to the first method.