We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

"Shrink" Goldmine

Medium Priority
943 Views
Last Modified: 2013-11-15
Hi,

Im getting problems with my log shipping breaking evey day and its proving to be a bit of a pain setting up the log shipping each time. Ive started to look at the GM database which is being shipped and see the database is 5.6gb whilst the log file is 3.5gb. I have a maintenance plan of the db which backups and reindexes the db and there is also a weekly backup of the transaction logs.

After reading some articles on various websites which relate to shippinglog  large db's, a suggestion to Shrink the database prior to setting up the log shipping is a prerequisite.

Question is, can you simply right click on the Goldmine DB in SQL Server Manager and select Shrink|Files or would I have to Shrink|Database ? Also, can I do either during the day?

Thanks
DW

Comment
Watch Question

CERTIFIED EXPERT
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
GMGeniusSoftware Development Manager/Developer
CERTIFIED EXPERT
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
Thank you guys.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.