How to extract the SQL Server log file from the server?

Asked

Viewed 35 times

0

I have an SQL Server and I need to send the Log file to one of our Clients, but this query has 24 Gigabyte, doubt:

How to extract this logo file in csv format ?

1 answer

0

Example command to reduce Sql Server log file

alter database sh_rodov01
set recovery simple
dbcc shrinkfile (sh_rodov01_log, 10)
alter database sh_rodov01
set recovery full

Browser other questions tagged

You are not signed in. Login or sign up in order to post.