Incremental database backup on 'Simple' recovery model

Last Post 29 Oct 2012 07:55 PM by ctseah. 6 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
ctseah
New Member
New Member

--
15 Oct 2012 10:17 PM


Hi,

A question on database that has a recovery mode set as 'Simple'.

Using Acrserve software to backup the database.
Performed a full database backup using acrserve.
Followed by incremental database backup using acrserve.

Both results are successful.

However my query is why it is that incremental database backup is available for database set as 'Simple' mode ?
Thought that for 'Simple' recovery mode database only can perform full database backup and not incremental or transaction log backup ?

Hope someone can advise or share pertaining to this.

Thanks in advance.

Regards
rm
New Member
New Member

--
16 Oct 2012 04:08 AM
You can't backup log if the db is in simple recovery mode, can do full and diff db (no incremental backup in sql) backup.
gunneyk
New Member
New Member

--
16 Oct 2012 04:56 AM
Yes rm is correct. I think the terminology is what is causing the confusion. What Arcserve calls an Incremental must really be a DIFFERENTIAL backup in SQL Server and not a TRAN LOG backup.
ctseah
New Member
New Member

--
16 Oct 2012 07:13 PM


Hi,

Thanks for the clarification.

Another scenario question in this order of sequence
1) perform a full backup using acrserve on 'Monday'.
2) perform a full backup using sql server Maintenance Plan on 'Tuesday'
3) perform a differential backup using acrserve on 'Wednesday'.

System crash on Wednesday after the differential backup has been performed using acrserve.
I need to perform recovery using acrserver to bring the data back to 'Wednesday' will there be a problem ?

Thanks in advance.

regrads
rm
New Member
New Member

--
17 Oct 2012 05:10 AM
You need restore from full backup of Tuesday then diff backup of Wednesday.
gunneyk
New Member
New Member

--
17 Oct 2012 08:32 AM
You should never mix backups liek that. Use one tool or the other but not both. The Diff is always from the last FULL backup regardless of the tool used so in this case it is as rm stated the SQL Server one from Tuesday.
ctseah
New Member
New Member

--
29 Oct 2012 07:55 PM
Hi all,

Thanks for the advise.
Tried sequence mentioned by 'rm' , it worked. However need to do 'manual' restore instead of 'automatic' a bit of trying out before it worked.
I also felt that we should not mix the two different types of backup as much as possible stick to one type of backup to avoid confusion.

thanks
Regards
You are not authorized to post a reply.

Acceptable Use Policy