Disclaimer The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway. The content of this website represents a personal opinion and is of the nature of general comment only, and neither purports nor intends to be advice. Readers should not act on the basis of any matter in this website or any related parts without considering and if appropriate taking professional advice with due regard to their own particular circumstances. The author expressly disclaims, to the fullest extent permitted by law, all and any liability to any person or entity for the results of any actions taken based on information on this website or any related parts.
1. DBCC SHRINKFILE(mydbname_log, 1)2. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da2_1uzr.asp3. Quick and dirty: using sp_detach_db and sp_attach_db system stored procedures.http://www.swynk.com/friends/krishnan/movedatabase.asp
Remember Me
