SQL Server Performance Forum – Threads Archive

Archive Data Retrieval

Hi, one my colleague said me that in Oracle their is a Archive log from where you can retrive your data back , is anything their in SQL Server like this archive log, i have tried to get the data using red-gate sqllogbackp and log pi … its working but is their anything builtin ? [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] Regads. hsGoswami [email protected]

nothing built in as far as i am aware!

As far as I know SQL analysis services support archiving and
even in that only MOLAP partition saves copy of source data.

BACKUP LOG ? —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)

<blockquote id="quote">quote:<hr height="1" noshade id="quote">Originally posted by FrankKalis BACKUP LOG ? – Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de</a> Ich unterstÃ¼tze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>) <hr height="1" noshade id="quote"></blockquote id="quote"> Sir , he said me that their is a Archive Log (T-Log )in Oracle that can be used to revert / retrieve back the data even if T-Log get currepted and we lost data and this is buil-in feature with Oracle . Is it True ? [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] Regards. hsGoswami [email protected]

I have little experience with Oracle. Can you give a link where I can read more about this. From what I understand now, I would say BACKUP LOG looks kinda similar, but I might be wrong —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)

I’m not aware of such facilities until SQL 2000, and not sure about SQL 2005.
In SQL Server if log file gets corrupted then database will be under suspect mode and only the way of recovery is to restore from last good known backup or attach/detach process. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

<blockquote id="quote">quote:<hr height="1" noshade id="quote">Originally posted by FrankKalis I have little experience with Oracle. Can you give a link where I can read more about this. From what I understand now, I would say BACKUP LOG looks kinda similar, but I might be wrong – Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de</a> Ich unterstÃ¼tze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>) <hr height="1" noshade id="quote"></blockquote id="quote"> <a href=’http://www.orafaq.com/faqdbabr.htm’ target=’_blank’ title=’http://www.orafaq.com/faqdbabr.htm'<a target="_blank" href=http://www.orafaq.com/faqdbabr.htm>http://www.orafaq.com/faqdbabr.htm</a></a> <a href=’http://www-rohan.sdsu.edu/doc/oracle/server803/A54640_01/ch9_osba.htm’ target=’_blank’ title=’http://www-rohan.sdsu.edu/doc/oracle/server803/A54640_01/ch9_osba.htm'<a target="_blank" href=http://www-rohan.sdsu.edu/doc/oracle/server803/A54640_01/ch9_osba.htm>http://www-rohan.sdsu.edu/doc/oracle/server803/A54640_01/ch9_osba.htm</a></a><a href=’http://expertanswercenter.techtarget.com/eac/knowledgebaseAnswer/0,295199,sid63_gci976577,00.html’ target=’_blank’ title=’http://expertanswercenter.techtarget.com/eac/knowledgebaseAnswer/0,295199,sid63_gci976577,00.html'<a target="_blank" href=http://expertanswercenter.techtarget.com/eac/knowledgebaseAnswer/0>http://expertanswercenter.techtarget.com/eac/knowledgebaseAnswer/0</a>,295199,sid63_gci976577,00.html</a> <a href=’http://www.lsbu.ac.uk/oracle/oracle7/server/doc/SAD73/ch23.htm’ target=’_blank’ title=’http://www.lsbu.ac.uk/oracle/oracle7/server/doc/SAD73/ch23.htm'<a target="_blank" href=http://www.lsbu.ac.uk/oracle/oracle7/server/doc/SAD73/ch23.htm>http://www.lsbu.ac.uk/oracle/oracle7/server/doc/SAD73/ch23.htm</a></a> <a href=’http://www.cs.uvm.edu/oracle9doc/rac.901/a89869/recover.htm’ target=’_blank’ title=’http://www.cs.uvm.edu/oracle9doc/rac.901/a89869/recover.htm'<a target="_blank" href=http://www.cs.uvm.edu/oracle9doc/rac.901/a89869/recover.htm>http://www.cs.uvm.edu/oracle9doc/rac.901/a89869/recover.htm</a></a> [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] Regards. hsGoswami [email protected]

<blockquote id="quote">quote:<hr height="1" noshade id="quote">Originally posted by ghemant <blockquote id="quote">quote:<hr height="1" noshade id="quote">Originally posted by FrankKalis I have little experience with Oracle. Can you give a link where I can read more about this. From what I understand now, I would say BACKUP LOG looks kinda similar, but I might be wrong – Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de</a> Ich unterstÃ¼tze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>) <hr height="1" noshade id="quote"></blockquote id="quote"> <a href=’http://www.orafaq.com/faqdbabr.htm’ target=’_blank’ title=’http://www.orafaq.com/faqdbabr.htm'<a target="_blank" href=http://www.orafaq.com/faqdbabr.htm>http://www.orafaq.com/faqdbabr.htm</a></a> <a href=’http://www-rohan.sdsu.edu/doc/oracle/server803/A54640_01/ch9_osba.htm’ target=’_blank’ title=’http://www-rohan.sdsu.edu/doc/oracle/server803/A54640_01/ch9_osba.htm'<a target="_blank" href=http://www-rohan.sdsu.edu/doc/oracle/server803/A54640_01/ch9_osba.htm>http://www-rohan.sdsu.edu/doc/oracle/server803/A54640_01/ch9_osba.htm</a></a><a href=’http://expertanswercenter.techtarget.com/eac/knowledgebaseAnswer/0,295199,sid63_gci976577,00.html’ target=’_blank’ title=’http://expertanswercenter.techtarget.com/eac/knowledgebaseAnswer/0,295199,sid63_gci976577,00.html'<a target="_blank" href=http://expertanswercenter.techtarget.com/eac/knowledgebaseAnswer/0>http://expertanswercenter.techtarget.com/eac/knowledgebaseAnswer/0</a>,295199,sid63_gci976577,00.html</a> <a href=’http://www.lsbu.ac.uk/oracle/oracle7/server/doc/SAD73/ch23.htm’ target=’_blank’ title=’http://www.lsbu.ac.uk/oracle/oracle7/server/doc/SAD73/ch23.htm'<a target="_blank" href=http://www.lsbu.ac.uk/oracle/oracle7/server/doc/SAD73/ch23.htm>http://www.lsbu.ac.uk/oracle/oracle7/server/doc/SAD73/ch23.htm</a></a> <a href=’http://www.cs.uvm.edu/oracle9doc/rac.901/a89869/recover.htm’ target=’_blank’ title=’http://www.cs.uvm.edu/oracle9doc/rac.901/a89869/recover.htm'<a target="_blank" href=http://www.cs.uvm.edu/oracle9doc/rac.901/a89869/recover.htm>http://www.cs.uvm.edu/oracle9doc/rac.901/a89869/recover.htm</a></a> [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] Regards. Hi , have you read it ? [?] hsGoswami [email protected] <hr height="1" noshade id="quote"></blockquote id="quote"> hsGoswami [email protected]

Oops, sorry. Have lost track of this thread. Will read them on Monday. [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] – Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de</a> Ich unterstÃ¼tze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>)

You can also subscribe to the Oracle subscription at www.lazydba.com and get millions and gazillions of email each day. [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] It’s a decent way to build your Oracle script library though if you are willing to attempt to keep up. MeanOldDBA [email protected] When life gives you a lemon, fire the DBA.

Thankx derrick for the link i’ll subscibe it also , but my question is :
in Oracle their is a Archive log from where you can retrive your data back and it is built in , for that you have to set archive log mode on and even if your database file get corrupted / damaged one can recover / retrieve data back to its origin. Regards. hsGoswami
[email protected]

Hello Hemant, I have experience with Oracle too. In oracle actually you can archive Redo log file and archival of redo log file is called Archive file but in SQL Server you dont have such feature. In case you would like to maintain archival of Transaction log file, first you have to set transaction log back and them write command scripts to archive log file. I hope i have answered you query. Thanks and Regards Ravi K

quote:Originally posted by SQL2000DBA Hello Hemant, I have experience with Oracle too. In oracle actually you can archive Redo log file and archival of redo log file is called Archive file but in SQL Server you dont have such feature. In case you would like to maintain archival of Transaction log file, first you have to set transaction log back and them write command scripts to archive log file. I hope i have answered you query. Thanks and Regards Ravi K

Ravi ,
a question aries in my mind that is Archive Log (with mode enable / on ) is something like T-Log backup ? and will it be (Archive Log ) retriev back our data even if database file get corrupted / damaged ?!! [?]
Regards. hsGoswami
[email protected]

Auto recovery of database depends on the adopted recovery model. The Full Recovery model uses database backups and transaction log backups to provide complete protection against media failure. If one or more data files is damaged, media recovery can restore all committed transactions. In-process transactions are rolled back. Refer to the books online about RECOVERY topics listed. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>