InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 23:55:05 GMT20http://www.sqlservercentral.com/Forums/Topic735859-146-1.aspxIf you have the .mdf and .ldf you can simply attach the database, no restore involved. If it's truly a .bak, then it's restore database.Tue, 16 Jun 2009 12:54:40 GMT tosscrosbyhttp://www.sqlservercentral.com/Forums/Topic735859-146-1.aspxTried it but no luck..any other ideas?Tue, 16 Jun 2009 11:56:26 GMTsaad_Ahmad1http://www.sqlservercentral.com/Forums/Topic735859-146-1.aspxIf I make a copy of the .mdf and .ldf of the StandBy Database and then drop the Standby Databse, how do I restore it?Tue, 16 Jun 2009 11:45:52 GMTsaad_Ahmad1http://www.sqlservercentral.com/Forums/Topic735859-146-1.aspxBy doing that, you have broken the log chain from the source database (client). About the only way I can see around this would be do shut SQL Server down and then make a copy of the mdf/ldf files. Not sure if this will work, but it is worth a try.Tue, 16 Jun 2009 11:11:36 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic735859-146-1.aspxsee if this can be of some help!![url]http://www.mssqltips.com/tip.asp?tip=1464 [/url]Tue, 16 Jun 2009 11:10:55 GMTps.http://www.sqlservercentral.com/Forums/Topic735859-146-1.aspxI have restored a DB backup image sent to us from our client in Standby mode.After I have restored the DB backup image in Standby mode, I restore daily transaction logs that are shipped to me.Every month I would like to a backup of this Database so that if something fails, I only have to restore the backup taken at the end of the month rather then catching up on 4-5 months of T-logs.What I tried to do is as follows:-Restore the DB backup image (sent by client) in Standby Mode for Jan 1/09.-Apply T-logs (sent by client) to this Standby Database up until Jan 30/09-For the Jan 31 T-log, I applied this against the DB but the option I selected to apply this T-log was in Restore Recovery mode-Purpose was to be able to take a backup image.-After I took the backup image, I restored the backup image into Standby Mode so that it can accept the Feb 1/09 T-log-When I tried to apply the T-log I got the error'This backup set cannot be applied because it is on a recovery path that is inconsistent with the database'Why is that? Anyone have a workaround?Tue, 16 Jun 2009 11:01:14 GMTsaad_Ahmad1