Posted on 2011-04-26
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?