En faisant un peu de recherche supplémentaire j'ai trouvé ce qui suit, posté par Bret Halford de Sybase Tech Support:
First, drop the log segment from data_2 using sp_dropsegment
this will prevent future allocations of log extents on this device
Then do some logged activity in the database - enough to fill the
current extent of the log (i.e. grow syslogs by 8 pages).
this will cause the log to allocate a new extent, and the log device
will be the only device with the log segment, so it will be allocated there
Then dump tran with truncate_only
this will clean out the existing extents on the data device.
then take a full database dump.
this gives you a fresh starting point with all these changes done, and
lets you take tran dumps if you wish to do that.
Ce qui semble indiquer que la méthode que je suggère doit marcher.
Michael
Partager