Step1:
ALTER DATABASE BASE SET RECOVERY SIMPLE
--Execute this line.
Step2:
-- Find the log file of data base.
SELECT name
FROM sys.database_files
WHERE type_desc = 'LOG'
Step3:
DBCC SHRINKFILE ('FINANCE_log', 1000)
OR
Go to object browser-> then select database and make right click->Select TASK->SHRINK->Files
shrink window will open.
Choose File Type as LOG from dropdown control. Then click OK
DO it your OWN RISK.
ALTER DATABASE BASE SET RECOVERY SIMPLE
--Execute this line.
Step2:
-- Find the log file of data base.
SELECT name
FROM sys.database_files
WHERE type_desc = 'LOG'
Step3:
DBCC SHRINKFILE ('FINANCE_log', 1000)
OR
Go to object browser-> then select database and make right click->Select TASK->SHRINK->Files
shrink window will open.
Choose File Type as LOG from dropdown control. Then click OK
DO it your OWN RISK.
No comments:
Post a Comment