May 11, 2012 at 6:16 am
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?
May 11, 2012 at 7:40 am
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
May 11, 2012 at 8:34 pm
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