Monday 18 April 2011

ASE : How to separate data and log segment

1. use disk init to create the new log device for your database

2. dump tran with truncate_only- to make sure we clear the log

3. use sp_logdevice to move the log to the new device
- sp_logdevice ,
- this will change the sgmaps of 7 to 3 and move the log to the new device which has a segmap of 4

4. dump tran with truncate_only- to make sure we clear any log that might remain on the data device

5. use sp_helplog to make sure that the log starts on the log device

No comments:

Post a Comment