January 17, 2009 at 9:57 pm
Thankyou very much-- Gail Shaw.. I got the point Now..
Still I have lot of confustion and lot my friends as all as we are new to database part
1)When we backup a T-log does it have both active and In-active transactions? If yes ,what is the purpose of In -active transactions ?(Since In-active trans are already written in mdf )
2)In simple mode suppose the ldf is 80 gb and got truncated by sql server checkpoint process,
then space will get back to Operating system or I have to shrink the log file?
3) In Full Mode after taking t-log backup does OS get space back automatically or we have to shrink it?
4)You mentionted that when we backup the T-log with Truncate only or No_log then log chain breaks and I agree with this point.
***
Let say we have a TestDB where we have Full backup scheduled every day and T-logs scheduled every hour ..,Suppose If 16 th hour T-log got corrupted( may be any reason ) and then log chain breaks ..then the 17 th hour will contain the chain form last FUll backup or Last T-lOg backup?
I know that T-log will have changes from previous last backup(May be FUll/Diff/T-log).. But what happens in the above scenario?
5)Any idea how to uninstal a HOT-FIX ?
Any help is really appreciated
Thanks- Kiran
January 18, 2009 at 2:52 am
Please don't start new threads for existing questions. It just leads to duplicate replies and wastes people's time.
Asked and answered - http://www.sqlservercentral.com/Forums/FindPost638856.aspx
No replies to this thread please.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 18, 2009 at 9:11 am
Closed to prevent replies
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply