SQL Server 2000 - Log Shipping

- 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

-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

SQL Server 2005 Features Comparison

The basics of asynchronous processing

http://www.simple-talk.com/dotnet/windows-forms/asynchronous-processing-in-.net-part-1-fundamentals/

Designing and building a robust data access layer

http://www.simple-talk.com/dotnet/.net-framework/.net-application-architecture-the-data-access-layer/

http://www.sql-server-performance.com/

Forrester Research: Technology research and advice.

SQL Server Replication Consultancy

SQL Server Replication Consultancy

MSSQLCity.Com

About MSSQLCity.Com