"!!bogus" <hello@microb.com> wrote in message
news:%23Ymp2CKfFHA.3164@TK2MSFTNGP15.phx.gbl...
> Hi,
>
> I am setting up a disaster recovery server and I need to configure it so
> that databases on the main server get copied every few days. I thought of
> doing an export with DTS and then saving the package and set it to run on
> the specified dates, but the problem is I would have to remember to do
> this for each new database that is created.
>
> Is replication the solution?
>
> I tried to use replication, but it doesn't seem to work for me. It creates
> some tables, but none of those tables look like my original tables.
> Actually the whole database structure is different.
>
> Is there an example of how to do this step by step. May be i am expecting
> the wrong results. I did transactional replication (just to see how it
> works).
>
> --
> Thank you
> Please post only
>

"Matt" <mattnj@hotmail.com> wrote in message
news:d9uc9d$mjt$1@news.freedom2surf.net...
> thats the best way...
>
> http://www.sql-server-performance.com/sql_server_log_shipping.asp
>
> "!!bogus" <hello@microb.com> wrote in message
> news:%23Ymp2CKfFHA.3164@TK2MSFTNGP15.phx.gbl...
>> Hi,
>>
>> I am setting up a disaster recovery server and I need to configure it so
>> that databases on the main server get copied every few days. I thought of
>> doing an export with DTS and then saving the package and set it to run on
>> the specified dates, but the problem is I would have to remember to do
>> this for each new database that is created.
>>
>> Is replication the solution?
>>
>> I tried to use replication, but it doesn't seem to work for me. It
>> creates some tables, but none of those tables look like my original
>> tables. Actually the whole database structure is different.
>>
>> Is there an example of how to do this step by step. May be i am expecting
>> the wrong results. I did transactional replication (just to see how it
>> works).
>>
>> --
>> Thank you
>> Please post only
>>
>
>

"!!bogus" <hello@microb.com> wrote in message
news:uEcVVeajFHA.3256@TK2MSFTNGP12.phx.gbl...
> Would I have to do all those steps for every database I create? Or is it
> possible to apply those steps for all databases (like in the "Maintenance
> plans"). I am particularly concerned about databases that would be created
> in the future and possibly get forgotten to be backed up.
>
> --
> Thank you
> Please post only
> "Matt" <mattnj@hotmail.com> wrote in message
> news:d9uc9d$mjt$1@news.freedom2surf.net...
> > thats the best way...
> >
> > http://www.sql-server-performance.com/sql_server_log_shipping.asp
> >
> > "!!bogus" <hello@microb.com> wrote in message
> > news:%23Ymp2CKfFHA.3164@TK2MSFTNGP15.phx.gbl...
> >> Hi,
> >>
> >> I am setting up a disaster recovery server and I need to configure it
so
> >> that databases on the main server get copied every few days. I thought
of
> >> doing an export with DTS and then saving the package and set it to run
on
> >> the specified dates, but the problem is I would have to remember to do
> >> this for each new database that is created.
> >>
> >> Is replication the solution?
> >>
> >> I tried to use replication, but it doesn't seem to work for me. It
> >> creates some tables, but none of those tables look like my original
> >> tables. Actually the whole database structure is different.
> >>
> >> Is there an example of how to do this step by step. May be i am
expecting
> >> the wrong results. I did transactional replication (just to see how it
> >> works).
> >>
> >> --
> >> Thank you
> >> Please post only
> >>
> >
> >
>
>

"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:Ow7EVydjFHA.1428@TK2MSFTNGP10.phx.gbl...
> its something you would have to do on a database by database basis.
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "!!bogus" <hello@microb.com> wrote in message
> news:uEcVVeajFHA.3256@TK2MSFTNGP12.phx.gbl...
>> Would I have to do all those steps for every database I create? Or is it
>> possible to apply those steps for all databases (like in the "Maintenance
>> plans"). I am particularly concerned about databases that would be
>> created
>> in the future and possibly get forgotten to be backed up.
>>
>> --
>> Thank you
>> Please post only
>> "Matt" <mattnj@hotmail.com> wrote in message
>> news:d9uc9d$mjt$1@news.freedom2surf.net...
>> > thats the best way...
>> >
>> > http://www.sql-server-performance.com/sql_server_log_shipping.asp
>> >
>> > "!!bogus" <hello@microb.com> wrote in message
>> > news:%23Ymp2CKfFHA.3164@TK2MSFTNGP15.phx.gbl...
>> >> Hi,
>> >>
>> >> I am setting up a disaster recovery server and I need to configure it
> so
>> >> that databases on the main server get copied every few days. I thought
> of
>> >> doing an export with DTS and then saving the package and set it to run
> on
>> >> the specified dates, but the problem is I would have to remember to do
>> >> this for each new database that is created.
>> >>
>> >> Is replication the solution?
>> >>
>> >> I tried to use replication, but it doesn't seem to work for me. It
>> >> creates some tables, but none of those tables look like my original
>> >> tables. Actually the whole database structure is different.
>> >>
>> >> Is there an example of how to do this step by step. May be i am
> expecting
>> >> the wrong results. I did transactional replication (just to see how it
>> >> works).
>> >>
>> >> --
>> >> Thank you
>> >> Please post only
>> >>
>> >
>> >
>>
>>
>
>