Does a full/differential backup made using the backup dialog box in SSMS disrupt log shiiping of that database??? if Yes how can we take a backup of that system without disrupting log shipping
Yes, it does break the backup sequence. To avoid such a scenerio you can create the backup using COPY_ONLY option. There is an excellent article in SSP for the same. http://www.sql-server-performance.c...out_Breaking_Database_Backup_Sequence_p1.aspx
i have one more question.. if we are performing differential backups after the full backup with COPY_ONLY option does the differential backup too has to be using the copy_only option???
when i perform the differential backup as follows i get an error.. i cnt figure out wt is wrong.. plz help me with this /* Full Backup Using COPY_ONLY Option*/ BACKUP DATABASE AdventureWorks TO DISK='C:BackupAW.bak' WITH COPY_ONLY /* Differntial Backup Using COPY_ONLY Option */ BACKUP DATABASE AdventureWorks TO DISK='C:BackupAW_diff.bak' WITH DIFFERENTIAL,COPY_ONLY error: Processed 20576 pages for database 'AdventureWorks', file 'AdventureWorks_Data' on file 2. Processed 1 pages for database 'AdventureWorks', file 'AdventureWorks_Log' on file 2. BACKUP DATABASE successfully processed 20577 pages in 8.070 seconds (20.887 MB/sec). Msg 3035, Level 16, State 1, Line 9 Cannot perform a differential backup for database "AdventureWorks", because a current database backup does not exist. Perform a full database backup by reissuing BACKUP DATABASE, omitting the WITH DIFFERENTIAL option. Msg 3013, Level 16, State 1, Line 9 BACKUP DATABASE is terminating abnormally.
From BOL: A data backup taken with the COPY_ONLY option cannot be used as a base backup for differential backups. Differential backups taken later will behave as if the copy-only backup does not exist.