Backup Plan for new midweek SQL databases

  • Currently we use Symantec Backup Exec to run a full Saturday SQL database backup across all of our servers followed by midweek differentials. If any new databases were created we would manually add a full backup run for individual databases. However, there has been an influx of development work and I really need to automate this process - as Symantec support stated BE could not process the operation of picking up full database backups during a diff. run.

    Is there any way to run a full backup script and midweek diffs, as well as pick up full backups of new databases which get diff runs for the remainder of the week?

  • What I have so far - is to create 1 full weekend/5x diff weekday plan as currently exists with Backup Exec. Only on top of that use a daily full but restrict using 'CRDATE < GETDATE() -1' to only full backup anything created in the last day. So that would be:

    1x Full Weekend Script

    5x Weekday Differential Scripts

    5x Weekday Full (last 24 hour) scripts

  • below query can help you to list down all db for backup but you need to cutomize your current scripts

    declare @tbl_backup_list table (id int identity ,[db_name] nvarchar(200))

    insert into @tbl_backup_list

    select name from sys.databases where --- database_id >4 you can have your database selection which you dont want to backup

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply