Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Backup with integration und Maint. Plan

Author  Topic 

andi-ulm
Starting Member

1 Post

Posted - 2012-09-19 : 11:00:15
Hello,

i have an SQL Server 2008 R2 Instance.

The backup is done by HP Data Protector with integration to SQL.

Now we want an additional backup to disk with Maint. Plan.

Is this an Problem with LSNs and the Transaction Log backup ?

The integration Backup is once a day Full and hourly Transaction Log.

When we backup now additionally with an Maint. Plan, is there a problem with the LSNs ?

Kind Regards

Andi

jeffw8713
Aged Yak Warrior

819 Posts

Posted - 2012-09-19 : 13:25:38
The only problems will be with differential backups. To avoid issues with differentials you want to use the COPY_ONLY parameter on the maintenance plan backups. There are no issues with transaction log backups.
Go to Top of Page
   

- Advertisement -