LogShipping question

Hi guys
I am about to create a logshipping plan to keep a db updated in Server2 from
Server1.
I know that Server1 must run the Enerprise edition in order to enable the
logshipping. Does server2 need to be Enterprise edition too or standard
edition is sufficient.
thanks
Standard is sufficient.
"aolxp" <sa@.anonymous.com> wrote in message
news:ugSubz0rFHA.2212@.TK2MSFTNGP15.phx.gbl...
> Hi guys
> I am about to create a logshipping plan to keep a db updated in Server2
> from Server1.
> I know that Server1 must run the Enerprise edition in order to enable the
> logshipping. Does server2 need to be Enterprise edition too or standard
> edition is sufficient.
> thanks
>
|||Both need to be EE. If you want to involve SE in log shipping, use your own scripts. You can Google
and you will probably find examples of home-grown log shipping.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"aolxp" <sa@.anonymous.com> wrote in message news:ugSubz0rFHA.2212@.TK2MSFTNGP15.phx.gbl...
> Hi guys
> I am about to create a logshipping plan to keep a db updated in Server2 from Server1.
> I know that Server1 must run the Enerprise edition in order to enable the logshipping. Does
> server2 need to be Enterprise edition too or standard edition is sufficient.
> thanks
>

LogShipping question

Hi guys
I am about to create a logshipping plan to keep a db updated in Server2 from
Server1.
I know that Server1 must run the Enerprise edition in order to enable the
logshipping. Does server2 need to be Enterprise edition too or standard
edition is sufficient.
thanksStandard is sufficient.
"aolxp" <sa@.anonymous.com> wrote in message
news:ugSubz0rFHA.2212@.TK2MSFTNGP15.phx.gbl...
> Hi guys
> I am about to create a logshipping plan to keep a db updated in Server2
> from Server1.
> I know that Server1 must run the Enerprise edition in order to enable the
> logshipping. Does server2 need to be Enterprise edition too or standard
> edition is sufficient.
> thanks
>|||Both need to be EE. If you want to involve SE in log shipping, use your own scripts. You can Google
and you will probably find examples of home-grown log shipping.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"aolxp" <sa@.anonymous.com> wrote in message news:ugSubz0rFHA.2212@.TK2MSFTNGP15.phx.gbl...
> Hi guys
> I am about to create a logshipping plan to keep a db updated in Server2 from Server1.
> I know that Server1 must run the Enerprise edition in order to enable the logshipping. Does
> server2 need to be Enterprise edition too or standard edition is sufficient.
> thanks
>sql

LogShipping question

Hi guys
I am about to create a logshipping plan to keep a db updated in Server2 from
Server1.
I know that Server1 must run the Enerprise edition in order to enable the
logshipping. Does server2 need to be Enterprise edition too or standard
edition is sufficient.
thanksStandard is sufficient.
"aolxp" <sa@.anonymous.com> wrote in message
news:ugSubz0rFHA.2212@.TK2MSFTNGP15.phx.gbl...
> Hi guys
> I am about to create a logshipping plan to keep a db updated in Server2
> from Server1.
> I know that Server1 must run the Enerprise edition in order to enable the
> logshipping. Does server2 need to be Enterprise edition too or standard
> edition is sufficient.
> thanks
>|||Both need to be EE. If you want to involve SE in log shipping, use your own
scripts. You can Google
and you will probably find examples of home-grown log shipping.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"aolxp" <sa@.anonymous.com> wrote in message news:ugSubz0rFHA.2212@.TK2MSFTNGP15.phx.gbl...[vb
col=seagreen]
> Hi guys
> I am about to create a logshipping plan to keep a db updated in Server2 fr
om Server1.
> I know that Server1 must run the Enerprise edition in order to enable the
logshipping. Does
> server2 need to be Enterprise edition too or standard edition is sufficien
t.
> thanks
>[/vbcol]

LogShipping Copy and Load Question

Hi,
I have established a LogShipping plan with Secondary
Server DB set as Standby, 15 minutes interval of Backup
Log, Load and Restore. Questions:
(1) Inside Log Shipping History, it seems that the Copy
will always copy NEWER Log (in my case, 15 minutes later,
eg. 1815), and Load will always Load OLDER Log (in my
case, 15 minuutes earlier eg. 1800). How can I resolve
this?
(2) Most importantly, The Logshipping will have errors
after a while and it reaches a stage where NO file(s) will
be processed and "Last File" in Log Shipping History
always remains the same file (Eg. ...200407090615.TRN). I
suspect it is all related to the frequency that I set.
I just find it hard to maintain a good Log Shipping plan
which does not require close monitoring.
I would appreciate any help for me here. Thanks a lot in
advance.
Tom
Tom,
making the load frequency every 5 mins should solve the issues you are
experiencing.
I always have a more frequent load than copy to prevent backlogs of the log
files.
HTH,
Paul Ibison
sql