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