Log shipping / Standby

Hi,
I have to create a standby Server for the Production Server using Log
Shipping. These are the details:
Production Server:
OS: Windows 2000 Server SP4
SQL Server: SQL Server Enterprise Edition 8.00.650(SP2)
Standby Server:
OS: Windows 2003 Server Standard Edition
SQL Server: SQL Server Enterprise Edition 8.00.760(SP3)
Production Server do not have any DTS packages but there are a couple of
jobs and DTS packages that import and export data from the Production server.
They do not reside on the Production server. Is it a good idea to recreate
all these jobs and DTS packages on the same server using the name of standby
server and once the Production Server goes down - disable jobs referencing
Production server and enable jobs referencing standby server? Can I create
the logins on the standby server and start using them once the Production
Server goes down?
Thanks in advance.
Hi
Yes you cam move jobs and packages to the standby server, you sure , you
will have to create a login for connection
Remember,Log shipping failover is not automatic.
http://www.sql-server-performance.com/sql_server_log_shipping.asp
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:2884B662-4101-4385-9E58-25978961C48D@.microsoft.com...
> Hi,
> I have to create a standby Server for the Production Server using Log
> Shipping. These are the details:
> Production Server:
> OS: Windows 2000 Server SP4
> SQL Server: SQL Server Enterprise Edition 8.00.650(SP2)
> Standby Server:
> OS: Windows 2003 Server Standard Edition
> SQL Server: SQL Server Enterprise Edition 8.00.760(SP3)
> Production Server do not have any DTS packages but there are a couple of
> jobs and DTS packages that import and export data from the Production
> server.
> They do not reside on the Production server. Is it a good idea to recreate
> all these jobs and DTS packages on the same server using the name of
> standby
> server and once the Production Server goes down - disable jobs referencing
> Production server and enable jobs referencing standby server? Can I create
> the logins on the standby server and start using them once the Production
> Server goes down?
> Thanks in advance.