Monday 11 April 2011

ASE : Moving the transaction log to another device

1> alter database dbname log on device19 = 10
2>go

1> sp_logdevice dbname, device19
2>go
The last-chance threshold for database dbname is now 1232 pages.

... sql inserts, to fill old log segment ...
1> dump tran dbname with truncate_only
2>go

1> sp_helplog dbname
2> go
In database 'dbname', the log starts on device 'device19'.
(return status = 0)

No comments:

Post a Comment