I am setting up log shipping according to the "How to Setup Log Shipping" Microsoft White Paper. I want to use log shipping for multiple databases on the same machine and I guess I need to configure each DB separately. My question is do I/should I use s
eparate transaction log backup shares on the primary and secondary machines corresponding to each database. Just wondering if there is a chance for a collison with the log file names between to different DBs? Thanks.
Jeff
Jeff,
I have used both scenarios: separate directories and the same directory for all files. The filenames are prefixed with the database name and the maintenance plan takes it into account, so there's no problem. However, I find maintenance easier (clearer) wi
th several directories.
HTH,
Paul Ibison
Showing posts with label according. Show all posts
Showing posts with label according. Show all posts
Friday, March 23, 2012
Monday, March 19, 2012
Log Shipping in Developer Edition
Hi Firends,
I need log shipping in Developer edition. I do not have Enterprise edition.
According to microsoft all the features of Enterprise edition are availavle
in Developer edition. I have tried a lot but i could not find how to
configure log shipping in Developer edition.
With regards,
LalitHi
Developer Edition is a Enterprise Edition wioth licensing limitations. Log
shipping is configured though Database Maintenance Plan wizard. On the 2nd
page of the wizard is a check box "Ship the transaction logs...". BOL has
good information on it.
Regards
Mike
"Lalit" wrote:
> Hi Firends,
> I need log shipping in Developer edition. I do not have Enterprise edition.
> According to microsoft all the features of Enterprise edition are availavle
> in Developer edition. I have tried a lot but i could not find how to
> configure log shipping in Developer edition.
> With regards,
> Lalit|||Lalit
As opposed,i prefer this approach
http://www.sql-server-performance.com/sql_server_log_shipping.asp
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:12EC5070-9F69-4B5B-8BCB-E1A68F1A9BEA@.microsoft.com...
> Hi
> Developer Edition is a Enterprise Edition wioth licensing limitations. Log
> shipping is configured though Database Maintenance Plan wizard. On the 2nd
> page of the wizard is a check box "Ship the transaction logs...". BOL has
> good information on it.
> Regards
> Mike
> "Lalit" wrote:
> > Hi Firends,
> >
> > I need log shipping in Developer edition. I do not have Enterprise
edition.
> > According to microsoft all the features of Enterprise edition are
availavle
> > in Developer edition. I have tried a lot but i could not find how to
> > configure log shipping in Developer edition.
> >
> > With regards,
> >
> > Lalit|||Hi Friends,
thanks for response. But if LogShipping can not be configured on Developer
edition then why this is said that Developer edition can be used for Log
Shipping. I m having only developer edition then how can i check the log
shipping feature.
With regards,
Lalit
"Uri Dimant" wrote:
> Lalit
> As opposed,i prefer this approach
> http://www.sql-server-performance.com/sql_server_log_shipping.asp
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:12EC5070-9F69-4B5B-8BCB-E1A68F1A9BEA@.microsoft.com...
> > Hi
> >
> > Developer Edition is a Enterprise Edition wioth licensing limitations. Log
> > shipping is configured though Database Maintenance Plan wizard. On the 2nd
> > page of the wizard is a check box "Ship the transaction logs...". BOL has
> > good information on it.
> >
> > Regards
> > Mike
> >
> > "Lalit" wrote:
> >
> > > Hi Firends,
> > >
> > > I need log shipping in Developer edition. I do not have Enterprise
> edition.
> > > According to microsoft all the features of Enterprise edition are
> availavle
> > > in Developer edition. I have tried a lot but i could not find how to
> > > configure log shipping in Developer edition.
> > >
> > > With regards,
> > >
> > > Lalit
>
>|||> thanks for response. But if LogShipping can not be configured on Developer
> edition
Why do you say that? I have configured log shipping with Dev Ed. Have you tried it? How did you try
it? Are both involved SQL servers Dev Ed?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Lalit" <Lalit@.discussions.microsoft.com> wrote in message
news:093CEA41-6028-411A-A8D8-41D0CD9C1C1A@.microsoft.com...
> Hi Friends,
> thanks for response. But if LogShipping can not be configured on Developer
> edition then why this is said that Developer edition can be used for Log
> Shipping. I m having only developer edition then how can i check the log
> shipping feature.
>
> With regards,
> Lalit
> "Uri Dimant" wrote:
>> Lalit
>> As opposed,i prefer this approach
>> http://www.sql-server-performance.com/sql_server_log_shipping.asp
>>
>> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
>> news:12EC5070-9F69-4B5B-8BCB-E1A68F1A9BEA@.microsoft.com...
>> > Hi
>> >
>> > Developer Edition is a Enterprise Edition wioth licensing limitations. Log
>> > shipping is configured though Database Maintenance Plan wizard. On the 2nd
>> > page of the wizard is a check box "Ship the transaction logs...". BOL has
>> > good information on it.
>> >
>> > Regards
>> > Mike
>> >
>> > "Lalit" wrote:
>> >
>> > > Hi Firends,
>> > >
>> > > I need log shipping in Developer edition. I do not have Enterprise
>> edition.
>> > > According to microsoft all the features of Enterprise edition are
>> availavle
>> > > in Developer edition. I have tried a lot but i could not find how to
>> > > configure log shipping in Developer edition.
>> > >
>> > > With regards,
>> > >
>> > > Lalit
>>
I need log shipping in Developer edition. I do not have Enterprise edition.
According to microsoft all the features of Enterprise edition are availavle
in Developer edition. I have tried a lot but i could not find how to
configure log shipping in Developer edition.
With regards,
LalitHi
Developer Edition is a Enterprise Edition wioth licensing limitations. Log
shipping is configured though Database Maintenance Plan wizard. On the 2nd
page of the wizard is a check box "Ship the transaction logs...". BOL has
good information on it.
Regards
Mike
"Lalit" wrote:
> Hi Firends,
> I need log shipping in Developer edition. I do not have Enterprise edition.
> According to microsoft all the features of Enterprise edition are availavle
> in Developer edition. I have tried a lot but i could not find how to
> configure log shipping in Developer edition.
> With regards,
> Lalit|||Lalit
As opposed,i prefer this approach
http://www.sql-server-performance.com/sql_server_log_shipping.asp
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:12EC5070-9F69-4B5B-8BCB-E1A68F1A9BEA@.microsoft.com...
> Hi
> Developer Edition is a Enterprise Edition wioth licensing limitations. Log
> shipping is configured though Database Maintenance Plan wizard. On the 2nd
> page of the wizard is a check box "Ship the transaction logs...". BOL has
> good information on it.
> Regards
> Mike
> "Lalit" wrote:
> > Hi Firends,
> >
> > I need log shipping in Developer edition. I do not have Enterprise
edition.
> > According to microsoft all the features of Enterprise edition are
availavle
> > in Developer edition. I have tried a lot but i could not find how to
> > configure log shipping in Developer edition.
> >
> > With regards,
> >
> > Lalit|||Hi Friends,
thanks for response. But if LogShipping can not be configured on Developer
edition then why this is said that Developer edition can be used for Log
Shipping. I m having only developer edition then how can i check the log
shipping feature.
With regards,
Lalit
"Uri Dimant" wrote:
> Lalit
> As opposed,i prefer this approach
> http://www.sql-server-performance.com/sql_server_log_shipping.asp
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:12EC5070-9F69-4B5B-8BCB-E1A68F1A9BEA@.microsoft.com...
> > Hi
> >
> > Developer Edition is a Enterprise Edition wioth licensing limitations. Log
> > shipping is configured though Database Maintenance Plan wizard. On the 2nd
> > page of the wizard is a check box "Ship the transaction logs...". BOL has
> > good information on it.
> >
> > Regards
> > Mike
> >
> > "Lalit" wrote:
> >
> > > Hi Firends,
> > >
> > > I need log shipping in Developer edition. I do not have Enterprise
> edition.
> > > According to microsoft all the features of Enterprise edition are
> availavle
> > > in Developer edition. I have tried a lot but i could not find how to
> > > configure log shipping in Developer edition.
> > >
> > > With regards,
> > >
> > > Lalit
>
>|||> thanks for response. But if LogShipping can not be configured on Developer
> edition
Why do you say that? I have configured log shipping with Dev Ed. Have you tried it? How did you try
it? Are both involved SQL servers Dev Ed?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Lalit" <Lalit@.discussions.microsoft.com> wrote in message
news:093CEA41-6028-411A-A8D8-41D0CD9C1C1A@.microsoft.com...
> Hi Friends,
> thanks for response. But if LogShipping can not be configured on Developer
> edition then why this is said that Developer edition can be used for Log
> Shipping. I m having only developer edition then how can i check the log
> shipping feature.
>
> With regards,
> Lalit
> "Uri Dimant" wrote:
>> Lalit
>> As opposed,i prefer this approach
>> http://www.sql-server-performance.com/sql_server_log_shipping.asp
>>
>> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
>> news:12EC5070-9F69-4B5B-8BCB-E1A68F1A9BEA@.microsoft.com...
>> > Hi
>> >
>> > Developer Edition is a Enterprise Edition wioth licensing limitations. Log
>> > shipping is configured though Database Maintenance Plan wizard. On the 2nd
>> > page of the wizard is a check box "Ship the transaction logs...". BOL has
>> > good information on it.
>> >
>> > Regards
>> > Mike
>> >
>> > "Lalit" wrote:
>> >
>> > > Hi Firends,
>> > >
>> > > I need log shipping in Developer edition. I do not have Enterprise
>> edition.
>> > > According to microsoft all the features of Enterprise edition are
>> availavle
>> > > in Developer edition. I have tried a lot but i could not find how to
>> > > configure log shipping in Developer edition.
>> > >
>> > > With regards,
>> > >
>> > > Lalit
>>
Log Shipping in Developer Edition
Hi Firends,
I need log shipping in Developer edition. I do not have Enterprise edition.
According to microsoft all the features of Enterprise edition are availavle
in Developer edition. I have tried a lot but i could not find how to
configure log shipping in Developer edition.
With regards,
Lalit
Hi
Developer Edition is a Enterprise Edition wioth licensing limitations. Log
shipping is configured though Database Maintenance Plan wizard. On the 2nd
page of the wizard is a check box "Ship the transaction logs...". BOL has
good information on it.
Regards
Mike
"Lalit" wrote:
> Hi Firends,
> I need log shipping in Developer edition. I do not have Enterprise edition.
> According to microsoft all the features of Enterprise edition are availavle
> in Developer edition. I have tried a lot but i could not find how to
> configure log shipping in Developer edition.
> With regards,
> Lalit
|||Lalit
As opposed,i prefer this approach
http://www.sql-server-performance.co...g_shipping.asp
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:12EC5070-9F69-4B5B-8BCB-E1A68F1A9BEA@.microsoft.com...[vbcol=seagreen]
> Hi
> Developer Edition is a Enterprise Edition wioth licensing limitations. Log
> shipping is configured though Database Maintenance Plan wizard. On the 2nd
> page of the wizard is a check box "Ship the transaction logs...". BOL has
> good information on it.
> Regards
> Mike
> "Lalit" wrote:
edition.[vbcol=seagreen]
availavle[vbcol=seagreen]
|||Hi Friends,
thanks for response. But if LogShipping can not be configured on Developer
edition then why this is said that Developer edition can be used for Log
Shipping. I m having only developer edition then how can i check the log
shipping feature.
With regards,
Lalit
"Uri Dimant" wrote:
> Lalit
> As opposed,i prefer this approach
> http://www.sql-server-performance.co...g_shipping.asp
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:12EC5070-9F69-4B5B-8BCB-E1A68F1A9BEA@.microsoft.com...
> edition.
> availavle
>
>
|||> thanks for response. But if LogShipping can not be configured on Developer
> edition
Why do you say that? I have configured log shipping with Dev Ed. Have you tried it? How did you try
it? Are both involved SQL servers Dev Ed?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Lalit" <Lalit@.discussions.microsoft.com> wrote in message
news:093CEA41-6028-411A-A8D8-41D0CD9C1C1A@.microsoft.com...[vbcol=seagreen]
> Hi Friends,
> thanks for response. But if LogShipping can not be configured on Developer
> edition then why this is said that Developer edition can be used for Log
> Shipping. I m having only developer edition then how can i check the log
> shipping feature.
>
> With regards,
> Lalit
> "Uri Dimant" wrote:
I need log shipping in Developer edition. I do not have Enterprise edition.
According to microsoft all the features of Enterprise edition are availavle
in Developer edition. I have tried a lot but i could not find how to
configure log shipping in Developer edition.
With regards,
Lalit
Hi
Developer Edition is a Enterprise Edition wioth licensing limitations. Log
shipping is configured though Database Maintenance Plan wizard. On the 2nd
page of the wizard is a check box "Ship the transaction logs...". BOL has
good information on it.
Regards
Mike
"Lalit" wrote:
> Hi Firends,
> I need log shipping in Developer edition. I do not have Enterprise edition.
> According to microsoft all the features of Enterprise edition are availavle
> in Developer edition. I have tried a lot but i could not find how to
> configure log shipping in Developer edition.
> With regards,
> Lalit
|||Lalit
As opposed,i prefer this approach
http://www.sql-server-performance.co...g_shipping.asp
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:12EC5070-9F69-4B5B-8BCB-E1A68F1A9BEA@.microsoft.com...[vbcol=seagreen]
> Hi
> Developer Edition is a Enterprise Edition wioth licensing limitations. Log
> shipping is configured though Database Maintenance Plan wizard. On the 2nd
> page of the wizard is a check box "Ship the transaction logs...". BOL has
> good information on it.
> Regards
> Mike
> "Lalit" wrote:
edition.[vbcol=seagreen]
availavle[vbcol=seagreen]
|||Hi Friends,
thanks for response. But if LogShipping can not be configured on Developer
edition then why this is said that Developer edition can be used for Log
Shipping. I m having only developer edition then how can i check the log
shipping feature.
With regards,
Lalit
"Uri Dimant" wrote:
> Lalit
> As opposed,i prefer this approach
> http://www.sql-server-performance.co...g_shipping.asp
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:12EC5070-9F69-4B5B-8BCB-E1A68F1A9BEA@.microsoft.com...
> edition.
> availavle
>
>
|||> thanks for response. But if LogShipping can not be configured on Developer
> edition
Why do you say that? I have configured log shipping with Dev Ed. Have you tried it? How did you try
it? Are both involved SQL servers Dev Ed?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Lalit" <Lalit@.discussions.microsoft.com> wrote in message
news:093CEA41-6028-411A-A8D8-41D0CD9C1C1A@.microsoft.com...[vbcol=seagreen]
> Hi Friends,
> thanks for response. But if LogShipping can not be configured on Developer
> edition then why this is said that Developer edition can be used for Log
> Shipping. I m having only developer edition then how can i check the log
> shipping feature.
>
> With regards,
> Lalit
> "Uri Dimant" wrote:
Log Shipping in Developer Edition
Hi Firends,
I need log shipping in Developer edition. I do not have Enterprise edition.
According to microsoft all the features of Enterprise edition are availavle
in Developer edition. I have tried a lot but i could not find how to
configure log shipping in Developer edition.
With regards,
LalitHi
Developer Edition is a Enterprise Edition wioth licensing limitations. Log
shipping is configured though Database Maintenance Plan wizard. On the 2nd
page of the wizard is a check box "Ship the transaction logs...". BOL has
good information on it.
Regards
Mike
"Lalit" wrote:
> Hi Firends,
> I need log shipping in Developer edition. I do not have Enterprise editio
n.
> According to microsoft all the features of Enterprise edition are availavl
e
> in Developer edition. I have tried a lot but i could not find how to
> configure log shipping in Developer edition.
> With regards,
> Lalit|||Lalit
As opposed,i prefer this approach
http://www.sql-server-performance.c...og_shipping.asp
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:12EC5070-9F69-4B5B-8BCB-E1A68F1A9BEA@.microsoft.com...[vbcol=seagreen]
> Hi
> Developer Edition is a Enterprise Edition wioth licensing limitations. Log
> shipping is configured though Database Maintenance Plan wizard. On the 2nd
> page of the wizard is a check box "Ship the transaction logs...". BOL has
> good information on it.
> Regards
> Mike
> "Lalit" wrote:
>
edition.[vbcol=seagreen]
availavle[vbcol=seagreen]|||Hi Friends,
thanks for response. But if LogShipping can not be configured on Developer
edition then why this is said that Developer edition can be used for Log
Shipping. I m having only developer edition then how can i check the log
shipping feature.
With regards,
Lalit
"Uri Dimant" wrote:
> Lalit
> As opposed,i prefer this approach
> http://www.sql-server-performance.c...og_shipping.asp
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:12EC5070-9F69-4B5B-8BCB-E1A68F1A9BEA@.microsoft.com...
> edition.
> availavle
>
>|||> thanks for response. But if LogShipping can not be configured on Developer
> edition
Why do you say that? I have configured log shipping with Dev Ed. Have you tr
ied it? How did you try
it? Are both involved SQL servers Dev Ed?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Lalit" <Lalit@.discussions.microsoft.com> wrote in message
news:093CEA41-6028-411A-A8D8-41D0CD9C1C1A@.microsoft.com...[vbcol=seagreen]
> Hi Friends,
> thanks for response. But if LogShipping can not be configured on Developer
> edition then why this is said that Developer edition can be used for Log
> Shipping. I m having only developer edition then how can i check the log
> shipping feature.
>
> With regards,
> Lalit
> "Uri Dimant" wrote:
>
I need log shipping in Developer edition. I do not have Enterprise edition.
According to microsoft all the features of Enterprise edition are availavle
in Developer edition. I have tried a lot but i could not find how to
configure log shipping in Developer edition.
With regards,
LalitHi
Developer Edition is a Enterprise Edition wioth licensing limitations. Log
shipping is configured though Database Maintenance Plan wizard. On the 2nd
page of the wizard is a check box "Ship the transaction logs...". BOL has
good information on it.
Regards
Mike
"Lalit" wrote:
> Hi Firends,
> I need log shipping in Developer edition. I do not have Enterprise editio
n.
> According to microsoft all the features of Enterprise edition are availavl
e
> in Developer edition. I have tried a lot but i could not find how to
> configure log shipping in Developer edition.
> With regards,
> Lalit|||Lalit
As opposed,i prefer this approach
http://www.sql-server-performance.c...og_shipping.asp
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:12EC5070-9F69-4B5B-8BCB-E1A68F1A9BEA@.microsoft.com...[vbcol=seagreen]
> Hi
> Developer Edition is a Enterprise Edition wioth licensing limitations. Log
> shipping is configured though Database Maintenance Plan wizard. On the 2nd
> page of the wizard is a check box "Ship the transaction logs...". BOL has
> good information on it.
> Regards
> Mike
> "Lalit" wrote:
>
edition.[vbcol=seagreen]
availavle[vbcol=seagreen]|||Hi Friends,
thanks for response. But if LogShipping can not be configured on Developer
edition then why this is said that Developer edition can be used for Log
Shipping. I m having only developer edition then how can i check the log
shipping feature.
With regards,
Lalit
"Uri Dimant" wrote:
> Lalit
> As opposed,i prefer this approach
> http://www.sql-server-performance.c...og_shipping.asp
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:12EC5070-9F69-4B5B-8BCB-E1A68F1A9BEA@.microsoft.com...
> edition.
> availavle
>
>|||> thanks for response. But if LogShipping can not be configured on Developer
> edition
Why do you say that? I have configured log shipping with Dev Ed. Have you tr
ied it? How did you try
it? Are both involved SQL servers Dev Ed?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Lalit" <Lalit@.discussions.microsoft.com> wrote in message
news:093CEA41-6028-411A-A8D8-41D0CD9C1C1A@.microsoft.com...[vbcol=seagreen]
> Hi Friends,
> thanks for response. But if LogShipping can not be configured on Developer
> edition then why this is said that Developer edition can be used for Log
> Shipping. I m having only developer edition then how can i check the log
> shipping feature.
>
> With regards,
> Lalit
> "Uri Dimant" wrote:
>
Subscribe to:
Posts (Atom)