"Ed" <E*@discussions.microsoft.com> wrote in message
news:96DCEC95-6391-4BFA-A236-D04F26D5BD1E@microsoft.com...
> Hi,
>  Does the Log Shipping Setup wizard provide any options to do the database
> backup and restore after the initialization?  what if the table structures
> are changed and stored procedures are added?  If not, does that mean I
> have
> to start over the setup process again?
>
> THanks
>
> Ed

"Andrew J. Kelly" wrote:

> I am a little confused as to what you are asking as Log shipping is simply
> Backup and Restore that is somewhat automated. If you add a sp then when the
> backup gets applied to the other server it will create that sp there as
> well. You might want to read the sections in BooksOnLIne under Log Shipping.
>
>
> --
> Andrew J. Kelly  SQL MVP
>
>
> "Ed" <E*@discussions.microsoft.com> wrote in message
> news:96DCEC95-6391-4BFA-A236-D04F26D5BD1E@microsoft.com...
> > Hi,
> >  Does the Log Shipping Setup wizard provide any options to do the database
> > backup and restore after the initialization?  what if the table structures
> > are changed and stored procedures are added?  If not, does that mean I
> > have
> > to start over the setup process again?
> >
> > THanks
> >
> > Ed
>
>
>

"Ed" wrote:

> Sorry for the confused question.
>
> I have the log shipping setup and everything works fine.  However, the
> current database structure needs to be changed, do I need to start over to
> setup the log shipping again or I can just easily copy and restored the
> altered database to the standby server?
>
> "Andrew J. Kelly" wrote:
>
> > I am a little confused as to what you are asking as Log shipping is simply
> > Backup and Restore that is somewhat automated. If you add a sp then when the
> > backup gets applied to the other server it will create that sp there as
> > well. You might want to read the sections in BooksOnLIne under Log Shipping.
> >
> >
> > --
> > Andrew J. Kelly  SQL MVP
> >
> >
> > "Ed" <E*@discussions.microsoft.com> wrote in message
> > news:96DCEC95-6391-4BFA-A236-D04F26D5BD1E@microsoft.com...
> > > Hi,
> > >  Does the Log Shipping Setup wizard provide any options to do the database
> > > backup and restore after the initialization?  what if the table structures
> > > are changed and stored procedures are added?  If not, does that mean I
> > > have
> > > to start over the setup process again?
> > >
> > > THanks
> > >
> > > Ed
> >
> >
> >

"Mike Epprecht (SQL MVP)" wrote:

> Hi
>
> The log contains both DML and DDL events, so if you make a change to a SP,
> or a table, or a row of data, on the source server, the change will be in the
> log backup, and since you are using log shipping, the change will be applied
> to the destination database automatically.
>
> Get "Inside SQL Server 2000" by Kalen Delaney to get a full unserstanding
> how SQL Server works internally.
>
> Regards
> --------------------------------
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
>
> MVP Program: http://www.microsoft.com/mvp
>
> Blog: http://www.msmvps.com/epprecht/
>
>
>
> "Ed" wrote:
>
> > Sorry for the confused question.
> >
> > I have the log shipping setup and everything works fine.  However, the
> > current database structure needs to be changed, do I need to start over to
> > setup the log shipping again or I can just easily copy and restored the
> > altered database to the standby server?
> >
> > "Andrew J. Kelly" wrote:
> >
> > > I am a little confused as to what you are asking as Log shipping is simply
> > > Backup and Restore that is somewhat automated. If you add a sp then when the
> > > backup gets applied to the other server it will create that sp there as
> > > well. You might want to read the sections in BooksOnLIne under Log Shipping.
> > >
> > >
> > > --
> > > Andrew J. Kelly  SQL MVP
> > >
> > >
> > > "Ed" <E*@discussions.microsoft.com> wrote in message
> > > news:96DCEC95-6391-4BFA-A236-D04F26D5BD1E@microsoft.com...
> > > > Hi,
> > > >  Does the Log Shipping Setup wizard provide any options to do the database
> > > > backup and restore after the initialization?  what if the table structures
> > > > are changed and stored procedures are added?  If not, does that mean I
> > > > have
> > > > to start over the setup process again?
> > > >
> > > > THanks
> > > >
> > > > Ed
> > >
> > >
> > >

"Ed" <E*@discussions.microsoft.com> wrote in message
news:BC2E60AA-5D35-4A7A-B992-50E7B782A267@microsoft.com...
> Yes, this is the case.  It is something that I don't know...
> How about Trasactional Replication?  I don't think the transfered Reader
> Log
> contains all the DML and DDL, am I right?
>
> Ed
>
> "Mike Epprecht (SQL MVP)" wrote:
>
>> Hi
>>
>> The log contains both DML and DDL events, so if you make a change to a
>> SP,
>> or a table, or a row of data, on the source server, the change will be in
>> the
>> log backup, and since you are using log shipping, the change will be
>> applied
>> to the destination database automatically.
>>
>> Get "Inside SQL Server 2000" by Kalen Delaney to get a full unserstanding
>> how SQL Server works internally.
>>
>> Regards
>> --------------------------------
>> Mike Epprecht, Microsoft SQL Server MVP
>> Zurich, Switzerland
>>
>> MVP Program: http://www.microsoft.com/mvp
>>
>> Blog: http://www.msmvps.com/epprecht/
>>
>>
>>
>> "Ed" wrote:
>>
>> > Sorry for the confused question.
>> >
>> > I have the log shipping setup and everything works fine.  However, the
>> > current database structure needs to be changed, do I need to start over
>> > to
>> > setup the log shipping again or I can just easily copy and restored the
>> > altered database to the standby server?
>> >
>> > "Andrew J. Kelly" wrote:
>> >
>> > > I am a little confused as to what you are asking as Log shipping is
>> > > simply
>> > > Backup and Restore that is somewhat automated. If you add a sp then
>> > > when the
>> > > backup gets applied to the other server it will create that sp there
>> > > as
>> > > well. You might want to read the sections in BooksOnLIne under Log
>> > > Shipping.
>> > >
>> > >
>> > > --
>> > > Andrew J. Kelly  SQL MVP
>> > >
>> > >
>> > > "Ed" <E*@discussions.microsoft.com> wrote in message
>> > > news:96DCEC95-6391-4BFA-A236-D04F26D5BD1E@microsoft.com...
>> > > > Hi,
>> > > >  Does the Log Shipping Setup wizard provide any options to do the
>> > > > database
>> > > > backup and restore after the initialization?  what if the table
>> > > > structures
>> > > > are changed and stored procedures are added?  If not, does that
>> > > > mean I
>> > > > have
>> > > > to start over the setup process again?
>> > > >
>> > > > THanks
>> > > >
>> > > > Ed
>> > >
>> > >
>> > >