SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-08-2008, 02:50 PM
| ||||
| ||||
 Re: how to seperate log and data device? Anthony Mandic wrote: > > Kenneth wrote: > > > > If one of the segments of my database is mix with data and log, how can I > > fix this segment to seperate the data and log? > > There should be a writeup in the FAQ (http://www.isug.com/Sybase_FAQ/). > Otherwise, try a Google search here but basically, you wait until > the log pointer in master..sysdatabases for that database is out of > the range of that segment (you'll need to check this against the > master..sysusages table for that database), then dump the log and > drop the log allocation off that segment. You could also fill the > log if you don't wish to wait. It gets a bit trickier if you can't > do an sp_dropsegment, but not impossible. I forgot to mention that the log pointer only advances after a log dump or truncate. So you will need to do one first to determine which fragment the log starts from now and then advance it with logged activity and dumps or truncates to move it off the traget fragment if its sitting there at the time. If not, you can skip that part. -am © 2003      |
 |
« Re: sp_placeobject of image types reported as dbcc soft faults ??
|
multiple backup in multiple cpu ???? »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 08:22 AM.
