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

Will able to shrink MSDB - Log Shipping Expand / Collapse
Author
Message
Posted Thursday, June 13, 2013 4:36 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, July 28, 2014 12:44 AM
Points: 91, Visits: 322
Experts,

In our production server MSDB database growing very huge can we shrinking the log and data files but in that respective server log shipping configured and its working successfully around 700 databases.

Is it having any impact log shipping configuration when we going to shrinking MSDB files?

So pls advice to do further.


Pradeep
Post #1462973
Posted Thursday, June 13, 2013 6:07 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 12:03 AM
Points: 1,380, Visits: 2,708
Shrinking MSDB will not affect your Log Shipping setup. You're not deleting any data from MSDB
Post #1463002
Posted Thursday, June 13, 2013 6:09 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, July 28, 2014 12:44 AM
Points: 91, Visits: 322
Thanks for your quick reply, shall i shrink both MSDB data and log file as well?

Pradeep
Post #1463004
Posted Thursday, June 13, 2013 6:11 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 12:03 AM
Points: 1,380, Visits: 2,708
That's up to you
Post #1463008
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse