SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Replicating Database
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Feras82
Starting Member

Kuwait
3 Posts

Posted - 12/16/2010 :  01:46:28  Show Profile  Reply with Quote
I have an application server with SQL Server 2005 database.
I want to replicate one of my databases on a remote server for reporting purpose.

The problem here, the recovery mode of the master database should be FUll where I have a volume of 1.3 GB data (MS CRM database),

now after changing the recovery mode to be full I will get an occupied space of hundreds GBs on the hard disk of the application server.

Kindly advice;

Syrian4ever

Bustaz Kool
Flowing Fount of Yak Knowledge

USA
1600 Posts

Posted - 12/20/2010 :  19:19:39  Show Profile  Reply with Quote
Which files are taking up the space? Have you tried to shrink them?

=======================================
Elitism is the slur directed at merit by mediocrity. -Sydney J. Harris, journalist (1917-1986)
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5071 Posts

Posted - 12/20/2010 :  20:36:23  Show Profile  Visit russell's Homepage  Reply with Quote
You can still leave the subscriber in simple recovery model.

Recovery model and replication are seperate issues.

If you must leave the subscriber in full, just run frequent transaction log backups on the subscriber and discard them.

Edit: by the way, just changing the recovery model will not change the footprint in and of itself.

Edited by - russell on 12/20/2010 20:37:30
Go to Top of Page

Bustaz Kool
Flowing Fount of Yak Knowledge

USA
1600 Posts

Posted - 12/21/2010 :  18:37:47  Show Profile  Reply with Quote
Is it possible that the log file is growing now that you are in full recovery mode?

=======================================
Elitism is the slur directed at merit by mediocrity. -Sydney J. Harris, journalist (1917-1986)
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000