Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Delete log file without affecting Replication

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-05-27 : 08:11:38
whizkid writes "Hi all,

I was checking my database log file size when i suddenly saw it had grown up to 12 GB.
It seems that my predecessor had already done a shrink database. Hence shrink is not working at all. So i decided to recreate the log file by attaching and dettaching the database.
But needless to say, the database in cofigured to replicate to another SQL Server.

i was wondering how to do it without affecting the replication.

In fact another alternative for this method also will do. My ultimate aim is to decrease the size of the Log file.

Thanks in advance."
   

- Advertisement -