After 6 good years and 1 not so good, 3NF Consulting is shutting down. I want to thank all of my former clients, vendors and most of all the outstanding crew of Access, SQL Server and Windows guys I have farmed work out to over the years. We did some good work, saved a few necks and put out more than few fires along the way.
Despite the demise of the company, I’ll still be doing some side work as Kevin3NF, the 1099 guy, on a 1-2 hour basis. No long-term stuff as I am quite content at my full-time gig.
Thanks for reading…
In my environment, i am running logshipping. So how to reduce the size of data file.
If i am using DBCC shrinkdatabase command then it will affect logshipping.
Can i stop the logshipping and do the shrinkdatabse?
Please tell me.
I successfully ran
DBCC Shrinkdatabase(‘MyTestDB’,10) on my logshipped db in SQL 2005.
It worked just fine, as I would suspect since the operation does not break the LSN chain.
I did not test growing/shrinking an .ldf file