How to create a "copy" of SQL Server transaction log file

Posted by Salman A on Stack Overflow See other posts from Stack Overflow or by Salman A
Published on 2010-04-30T09:31:41Z Indexed on 2010/04/30 9:37 UTC
Read the original article Hit count: 170

Filed under:
|

I want a copy of SQL Server transaction log file for "raw" analysis. What is the safest way to get a copy of that file without shutting down the database and disturbing the existing log/backups/backup schedules and just about everything.

FYI, Its a SQL Server 2000 database server and I can see the log file (its about 4GB in size) and I cannot copy it as is; I get the "access denied" error when copying from explorer or command line.

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about sql-server-2000