Dear all these are the query to reduce
size of log file in sql
Query 1
ALTER DATABASE
databasename
SET RECOVERY
SIMPLE;
GO
Query 2
DBCC SHRINKFILE (nameoflogfile, 1)
Query 3
ALTER DATABASE
databasename
SET RECOVERY
FULL;
In this query
Step 1 go to
property of database
Step 2 go to file
option
Step 3 copy file name
of log file
Step 4 replace
that name in above query
And run query in
given sequence
After it check the
size of log file
*** be careful
copy only log file name
0 comments:
Post a Comment