InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 22:03:27 GMT20http://www.sqlservercentral.com/Forums/Topic1045829-146-1.aspxHi,I got my ans and i am going to implement this.If I get any issue then let you know.T & R,ShikhaThu, 13 Jan 2011 09:34:02 GMTshikha.in.2http://www.sqlservercentral.com/Forums/Topic1045829-146-1.aspx[quote][b]shikha.in.2 (1/11/2011)[/b][hr]if db crashses then how we recover backup and log file with proper reason Please.[/quote]I don;t understand what are you trying to say by this statement../* How we recover backup and log file */Sorry we don;t recover backup and log files..But yes with your given scenario if i understood it well we can recover your database with no data loss because you did n't metioned any timelines for recovery.Any Change you make in the database is considered as a transaction and hence it is written in you active transaction log file. So as you mentioned if your log backup are running normally then you can most definitely recovery your database and also all data files and log files will be there...Going forward pls make sure that you are mentioning your problem more clearily.I hope the reply will help you..Wed, 12 Jan 2011 00:10:51 GMTsachnamhttp://www.sqlservercentral.com/Forums/Topic1045829-146-1.aspxI may have misunderstood but...As stated, as long as you have the full back up and relevant transaction log backup files then I dont think there is any reason why you cant reapply these to go bring the database to the state prior to the point of failure.Tue, 11 Jan 2011 12:53:00 GMTdavid.alcockhttp://www.sqlservercentral.com/Forums/Topic1045829-146-1.aspxI would think that the steps of adding a new file (ALTER DATABASE) are captured in the transaction logs and would occur when you restore the transaction logs after first restoring the full ..... I've never tried it though.Tue, 11 Jan 2011 12:25:05 GMThomebrew01http://www.sqlservercentral.com/Forums/Topic1045829-146-1.aspxHi,There is a need to do the same.Is this possible to recover the .ldf file in any case.Regards,ShikhaTue, 11 Jan 2011 09:37:28 GMTshikha.in.2http://www.sqlservercentral.com/Forums/Topic1045829-146-1.aspxOne question first. Why would you be adding another log file?Tue, 11 Jan 2011 06:01:48 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1045829-146-1.aspxNot sure i understand.You would need to restore your last full backup (.bak), then re-apply (restore) each log backup (.trn) up until the failure.If you dont have a log backup from after you added the new ldf file, its gone.HTHTue, 11 Jan 2011 05:57:07 GMTSchadenfreude-Meihttp://www.sqlservercentral.com/Forums/Topic1045829-146-1.aspxhi ,i need help regarding one question In Sql Server.If i take full backup daily,ransaction log backup hourly.If suppose:I have taken full backup at 11amthen added new log file(.ldf)and hourly backup running as usual.if db crashses then how we recover backup and log file with proper reason Please.Please do the needful.regards,Shikha SrivstavaTue, 11 Jan 2011 05:46:49 GMTshikha.in.2