0

My friend (who doesn't use stackoverflow) asked me a peculiar and interesting question just now.

Is there a way to "disconnect a Log file, or shrink a log file without affecting Point in Time Recovery"? as I quote his exact words. He is working against a live system, and somehow, the Log file has grown to 72GB

All I know is you can Delete a log file (as indicated in the snippet below from technet)

USE master;
GO
ALTER DATABASE AdventureWorks2012
REMOVE FILE test1dat4;
GO

And Truncate it

DBCC SHRINKFILE(<log_file_name_Log>)
BACKUP LOG <database> WITH TRUNCATE_ONLY
DBCC SHRINKFILE(<log_file_name_Log>)

I am no SQL Server wiz, and from my experience which I have, I cannot help him - though this is something I want to know the answer myself -

Any advice?

Kenneth Fisher
  • 24,307
  • 13
  • 63
  • 116
Eon
  • 101
  • 1

0 Answers0