Moving Transaction Log after DB Creation ?

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Clive Strong SSChampion Points: 11222 More actions · Answer 1

Yes, to do this I would do the following...

exec sp_detatch_db 'Pubs'

GO

exec sp_attatch_db 'Pubs', @filename1 = 'e:\data\Pubs.mdf', @filename2 = 'f:\logs\Pubs_log.ldf'

That should do it..! For more help lookup sp_detatch_db & sp_attatch_db on BOL

Clive Strong

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 2

detach/attach (as noted above) is the easiest way to do this.

Steve Jones