May 28, 2009 at 4:55 am
I have divided my database (40 GB) in many logical filegroups
-DataFilegroup1
-DataFilegroup2
-DataFilegroup3
I have done this because I want to achieve benifits of not backing up -DataFilegroup3 because this is earmarked for readonly data. Now because I take the differential backup only for DataFilegroup1 and DataFilegroup2 then what should be my stategy for taking the transactional backup? Any headsup?
-MJ
-MJ
Please do not print mails and docx unless it is absolutely necessary. Spread environmental awareness.
May 28, 2009 at 5:00 am
if you have kept the third file group as readonly then there is no need to take the log backup of that filegroup except once assuming there might be something in it ...rest, you can take log backups for the 2 file groups ..
Abhay Chaudhary
Sr.DBA (MCITP/MCTS :SQL Server 2005/2008 ,OCP 9i)
May 28, 2009 at 6:40 am
Logs and log backups don't have anything to do with the data file groups. If the third group is read only, then no log activity will be recorded against it. When you back up your logs, you simply back up your logs. The activity therein will only reflect the logged activity, which, if you've got one group marked as read only, will exclude that group. It's that easy.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 28, 2009 at 12:10 pm
Thanks. I shall take the log backup for complete DB and apply the same in case of any failure. You are quite correct as when the DB is used as readonly then nothing would be logged...
-MJ
Please do not print mails and docx unless it is absolutely necessary. Spread environmental awareness.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply