hi,
There is anyway or tools that I could read sql log backup(.bak)files?
ThnakaI hopfully understand your question correct. I assume you want to see
history of your backup jobs and you use SQL Server 2005. If not, please let
me know.
Fire up SQL Server Management Studio.
Connect to your instance, expand SQL Server Agent and then expand Jobs.
Right click on the backup job and click View History.
To see about your jobs' last events, go to SQL Server Agent node in SSMS and
double click on the Job Activity Monitor.
--
Ekrem Önsoy
MCBDA, MCTS: SQL Server 2005, MCSD.Net, MCSE, MCT
"mecn" <mecn2002@.yahoo.com> wrote in message
news:%23yg0ufW8HHA.5456@.TK2MSFTNGP05.phx.gbl...
> hi,
> There is anyway or tools that I could read sql log backup(.bak)files?
> Thnaka
>|||mecn,
I believe that you are asking to read the transaction logs, is that correct?
SQL Server itself does not provide a facility, but others sell software:
http://www.apexsql.com/sql_tools_log.asp
http://www.red-gate.com/products/SQL_Log_Rescue/index.htm - For SQL Server
2000, Free.
http://www.lumigent.com/Products/le_sql.html
Check it out.
RLF
"mecn" <mecn2002@.yahoo.com> wrote in message
news:%23yg0ufW8HHA.5456@.TK2MSFTNGP05.phx.gbl...
> hi,
> There is anyway or tools that I could read sql log backup(.bak)files?
> Thnaka
>|||In article <#yg0ufW8HHA.5456@.TK2MSFTNGP05.phx.gbl>, mecn2002@.yahoo.com
says...
> hi,
> There is anyway or tools that I could read sql log backup(.bak)files?
> Thnaka
>
>
Lumigent Log Reader is excellent if a bit pricey. Also adds several
capabilities to your recovery processing.
--
Graham (Pete) Berry
PeteBerry@.Caltech.edusql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment