Estimating the transaction log size  Moving the transaction log to another device

Chapter 6: Creating and Managing User Databases

Default log size and device

If you omit the size parameter from the log on clause, Adaptive Server locates the minimum permitted amount of storage. If you omit the log on clause entirely, Adaptive Server places the transaction log on the same database device as the data tables.





Copyright © 2005. Sybase Inc. All rights reserved. Moving the transaction log to another device

View this book as PDF