Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Deattaching a replicated subscription database Expand / Collapse
Author
Message
Posted Sunday, September 9, 2012 11:30 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, July 18, 2014 9:11 AM
Points: 317, Visits: 929
hi,

what is the best way of get rid of the log file from subscription database. it is growing big in production db. and i want to make it simple so that it'll not grow further.

shall i deattach & attach again without log file so that a new log file will be created by sql server?
is that a good practice?

Thanks,
Regards,
Ami
Post #1356559
Posted Monday, September 10, 2012 3:36 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 2:55 AM
Points: 1,101, Visits: 5,280
No. Don't do detach/attach. It's not a good practice.

Are you taking the log backup regularly?
Post #1356611
Posted Monday, September 10, 2012 5:10 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, July 18, 2014 9:11 AM
Points: 317, Visits: 929
thanks for your assitance,

though it is a production db. we don;t take log back ups as it is dwhse.

we have another db where one month of data will reside always and we can bring from it.
even if it goes we can get the same from legacy systems.

we take weekly once backup and other days incremental backup.,


Regards,
Ami
Post #1356656
Posted Tuesday, September 11, 2012 4:57 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 2:55 AM
Points: 1,101, Visits: 5,280
You can change the database recovery model to "Simple".
I believe now the database is in "Full" recovery model.
Post #1357311
Posted Tuesday, September 11, 2012 8:17 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, July 18, 2014 9:11 AM
Points: 317, Visits: 929
Thanks.

But how to get rid of current big log file?

Regards,
Ami
Post #1357456
Posted Wednesday, September 12, 2012 12:24 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 2:55 AM
Points: 1,101, Visits: 5,280
Shrink the log file to appropriate size using DBCC SHRINKFILE command.
Post #1357800
Posted Wednesday, September 12, 2012 1:06 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, July 18, 2014 9:11 AM
Points: 317, Visits: 929
can we do that in a subscripted replication database?
will that affect replication?
Post #1357810
Posted Wednesday, September 12, 2012 3:18 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 2:55 AM
Points: 1,101, Visits: 5,280
Yes. Log file of subscriber can be shrinked.
It should not have any impact on replication.
Post #1357853
Posted Wednesday, September 12, 2012 4:30 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, July 18, 2014 9:11 AM
Points: 317, Visits: 929
thanks!!

Regards,
Ami
Post #1357881
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse