Delete Primary transaction Log
in [Programming SQL]
|
From: John Couch on 9 Dec 2009 07:41 Does anyone know if this is possible? I want to create a new transaction log, and remove the existing primary one, essential making the new transaction log the primary.
From: Uri Dimant on 9 Dec 2009 08:45 John May I ask why? Anyway detach the database and attach it with single file , since I do not know the version you are using , see details in the BOL "John Couch" <JohnCouch(a)discussions.microsoft.com> wrote in message news:0E5B82B2-6713-4C4E-95A5-3CE29C6DD7C2(a)microsoft.com... > Does anyone know if this is possible? I want to create a new transaction > log, > and remove the existing primary one, essential making the new transaction > log > the primary.
From: Andrew J. Kelly on 9 Dec 2009 09:37 No you cannot delete the primary log file. Just move it to where you want it to be with either a detach & attach or backup restore with move option. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "John Couch" <JohnCouch(a)discussions.microsoft.com> wrote in message news:0E5B82B2-6713-4C4E-95A5-3CE29C6DD7C2(a)microsoft.com... > Does anyone know if this is possible? I want to create a new transaction > log, > and remove the existing primary one, essential making the new transaction > log > the primary.
From: Mark Hickin on 9 Dec 2009 11:19 It sounds as if you want to move your transaction log, or perhaps just rename it. The easiest way to do this is to detach the database (it will cease to be available), move the file, and re-attach specifying the new log file location.
From: Simon Whale on 9 Dec 2009 11:49
even thought not recommended it was something that you could do with SQL 2000.. but its been stopped in 2005 as far as i know "Andrew J. Kelly" <sqlmvpnooospam(a)shadhawk.com> wrote in message news:%233MRc0NeKHA.4636(a)TK2MSFTNGP04.phx.gbl... > No you cannot delete the primary log file. Just move it to where you want > it to be with either a detach & attach or backup restore with move option. > > -- > > Andrew J. Kelly SQL MVP > Solid Quality Mentors > > "John Couch" <JohnCouch(a)discussions.microsoft.com> wrote in message > news:0E5B82B2-6713-4C4E-95A5-3CE29C6DD7C2(a)microsoft.com... >> Does anyone know if this is possible? I want to create a new transaction >> log, >> and remove the existing primary one, essential making the new transaction >> log >> the primary. > |