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

Question

Navigation

#1 by (0 votes)

0

I have a SQL Server and I need to send the Log file to one of our Clients, however this file has 24 gigabyte,

How to extract this logo file in csv format?

sql-server

asked by anonymous 08.11.2018 / 14:21

1 answer

score 0 · Answer 1

0

Sample command to reduce the Sql Server log file

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

08.11.2018 / 16:36