Shrinking the transaction log beneath its original size in SQL 2000 or 2005- February 23, 2005 OK, it's been so long since my last blog that I'm surprised my last blog is still here! I am, however, glad it still is, and whilst this might not be the most revolutionary entry, I hope you find it useful. So the scenerio is this: I have a database that has mulitple file groups and I would like to move to another machine with less disk space, or the log has grown too big and needs shrinking below its original size. In SQL 2000, and as far as I could tell, in SQL 2005, its not possible to..http://blogs.msdn.com/ryans/archive/2005/02/23/378883.aspx |