Log Shipping with SQL Server 2000 STD Edition?

Hi SQL Server MVPs,
I just get into a sql server 2000 (std edition) environment, and they will
stay with the std edition for a while. Here are some questions about the Log
shipping:
1. Does SQL server 2000 STD version support Log Shipping?
(I know EE Edition and Developer Edition do.)
2. If tasks like the Transaction Log backup, transfering log from primary
server to secondary server, restore the log from the standby server were all
handled by scheduled scripts, and the syslogins was transfered by DTS, will
this approach work in a SQL server 2k std environment? Will the logins
resolving process work?
3. How can we setup the Log shipping monitor in SQL 2000 STD server?
Your expertise confirming information and any possible instruction documents
will be appreciated.
FD
Hi,
(a) Log-shipping is not supported in standard version of SQL server. However
I have read that basic log-shipping is supported in the standard version,
didn't get chance to get to know more about this.
(b) IMO, this approach should work, as long as the database is in the
NORECOVERY mode in the standby server.
HTH
Yogish
|||The Enterprise Edition (and dev) just have a wizard to set
it all up for you. It doesn't mean you can't write your own
version on any edition. You can find sample scripts in the
SQL Server Resource Kit - I think it's called Simple Log
Shipper. You can also find examples of implementations of
custom log shipping routines on various web sites.
You'll need to create your own method for monitoring log
shipping.
-Sue
On Wed, 16 Mar 2005 14:43:07 -0800, "Frank"
<Frank@.discussions.microsoft.com> wrote:

>Hi SQL Server MVPs,
>I just get into a sql server 2000 (std edition) environment, and they will
>stay with the std edition for a while. Here are some questions about the Log
>shipping:
>1. Does SQL server 2000 STD version support Log Shipping?
> (I know EE Edition and Developer Edition do.)
>2. If tasks like the Transaction Log backup, transfering log from primary
>server to secondary server, restore the log from the standby server were all
>handled by scheduled scripts, and the syslogins was transfered by DTS, will
>this approach work in a SQL server 2k std environment? Will the logins
>resolving process work?
>3. How can we setup the Log shipping monitor in SQL 2000 STD server?
>Your expertise confirming information and any possible instruction documents
>will be appreciated.
>FD
|||1) Yes. You have to set it up yourself, however.
2) Yes and Yes. By the way, you can move the logins using this method:
HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
http://www.support.microsoft.com/?id=246133
3) To monitor the process you could use the jobs that perform the log
backups and restores. Have them email you if there is a failure. This is a
great way to email from SQL Server: XPSMTP --
http://sqldev.net/xp/xpsmtp.htm
You may find these KB articles helpful:
314515 INF: Frequently Asked Questions - SQL Server 2000 - Log Shipping
http://support.microsoft.com/?id=314515
323135 INF: Microsoft SQL Server 2000 - How to Set Up Log Shipping (White
Paper)
http://support.microsoft.com/?id=323135
325220 Support WebCast: Microsoft SQL Server 2000 Log Shipping
http://support.microsoft.com/?id=325220
821786 Support WebCast: Microsoft SQL Server 2000: Using Log Shipping
http://support.microsoft.com/?id=821786
321247 HOW TO: Configure Security for Log Shipping
http://support.microsoft.com/?id=321247
329133 INF: Troubleshooting SQL Server 2000 Log Shipping "Out of Sync"
Errors
http://support.microsoft.com/?id=329133
Keith
"Frank" <Frank@.discussions.microsoft.com> wrote in message
news:BBB0D86B-D4C9-4FFA-A496-C60FE8DEE0D3@.microsoft.com...
> Hi SQL Server MVPs,
> I just get into a sql server 2000 (std edition) environment, and they will
> stay with the std edition for a while. Here are some questions about the
Log
> shipping:
> 1. Does SQL server 2000 STD version support Log Shipping?
> (I know EE Edition and Developer Edition do.)
> 2. If tasks like the Transaction Log backup, transfering log from primary
> server to secondary server, restore the log from the standby server were
all
> handled by scheduled scripts, and the syslogins was transfered by DTS,
will
> this approach work in a SQL server 2k std environment? Will the logins
> resolving process work?
> 3. How can we setup the Log shipping monitor in SQL 2000 STD server?
> Your expertise confirming information and any possible instruction
documents
> will be appreciated.
> FD
|||All,
Thanks for the confirming information. I will start working in our testing
environment.
Frank
"Frank" wrote:

> Hi SQL Server MVPs,
> I just get into a sql server 2000 (std edition) environment, and they will
> stay with the std edition for a while. Here are some questions about the Log
> shipping:
> 1. Does SQL server 2000 STD version support Log Shipping?
> (I know EE Edition and Developer Edition do.)
> 2. If tasks like the Transaction Log backup, transfering log from primary
> server to secondary server, restore the log from the standby server were all
> handled by scheduled scripts, and the syslogins was transfered by DTS, will
> this approach work in a SQL server 2k std environment? Will the logins
> resolving process work?
> 3. How can we setup the Log shipping monitor in SQL 2000 STD server?
> Your expertise confirming information and any possible instruction documents
> will be appreciated.
> FD
sql