|
Posted by Robert Klemme on 10/02/01 11:56
On 24.08.2006 17:01, Jack Vamvas wrote:
> One thing you can do is:
> 1)Full backup of db
> 2)DETACH db
> 3)change the actual name of the ONLY the log file
> 4)Do a REATTACH , and when the pop up occurs enter a new name for a
> transaction log file. This will create a new log file
Why do you not recommend a BACKUP LOG WITH NO_LOG (or a normal backup)
and then DBCC SHRINKFILE? Deleting the TX log seems a rather drastic
measure here.
Btw, please don't top post.
robert
Navigation:
[Reply to this message]
|