Solved

SQL recovery model and merge replication

Posted on 2013-02-05
2
639 Views
Last Modified: 2013-05-13
Hi All,

I have a database that I wish to temporarily change the recovery mode on to simple so that I may forcefully shrink the transaction log(due to maintenance tasks screwing up and not reducing the file)

My question is :-

Can i change the recovery model to simple without breaking the merge replication on this database?? Then change it back to full?

Server : SQL 2008 server
Compatability level : SQL server 2000 (80)
Recovery model currently : Full
0
Comment
Question by:gardmanIT
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 4

Accepted Solution

by:
jjjosef earned 500 total points
ID: 38854836
Merge will not be impacted by changing the recovery model.

You don't need to follow any extra steps for Merge, just manage the T-Log of the Database the same was as you do for other non replicated databases.

~ Edit by Modulus_Twelve - This post is unattributed content from http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/eb157294-5888-48da-91d9-1c8bb5e25486 ~
0
 
LVL 4

Author Comment

by:gardmanIT
ID: 38855236
Thank you.. it got to 185Gb and I dont have the spare room to get that down.. i assume to get that down "normal way" I would just backup the transaction log and then do a shrink returning freed space to operating system..??

I am going to run the following command out of hours...



-- Truncate the log by changing the database recovery model to SIMPLE.
ALTER DATABASE KLSTOCK
SET RECOVERY SIMPLE;
GO
-- Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE (KLSTOCK_log, 1);
GO
-- Reset the database recovery model.
ALTER DATABASE KLSTOCK
SET RECOVERY FULL;
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question