get real!

Remove log file programming

-- set recovery option to simple higher than SQL2008

ALTER DATABASE [instance name] SET RECOVERY SIMPLE

-- Empty the data file.

DBCC SHRINKFILE ([log file name to remove(no extension)] , EMPTYFILE);

-- Remove the data file from the database.

ALTER DATABASE [instance name]

REMOVE FILE [log file name to remove(no extension)];

--- get it back to the original status

ALTER DATABASE [instance name] SET RECOVERY FULL

태그 : SQLServer

트랙백(0)덧글(0)

1 2 3 4 5 6 7 8 9 10 다음