Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-02 : 10:19:10
|
| Aouiche writes "Hi.How could I extract the transaction log file of DB under SQL server 2000.Thank you." |
|
|
Kevin Snow
Posting Yak Master
149 Posts |
Posted - 2002-05-02 : 12:59:14
|
| Extract the Log file-For what reason? Assuming you are not using the TRUNCATE ON CHECKPOINT option, you may backup the transaction log at any time.Are you planning to ship the log to a back up server? There is a nice aricle on one method of doing this at http://www.sql-server-performance.com/sql_server_log_shipping.aspIf this doens't help, can you be more specific about what you are trying to do? |
 |
|
|
|
|
|
Transaction Log file