Thursday, July 20, 2006

logins and passwords between instances of SQL Server

How to transfer logins and passwords between instances of SQL Server

How to resolve permission issues when you move a database between servers that are running SQL Server

"Troubleshooting Orphaned Users" topic in Books Online is incomplete


How to move databases between computers that are running SQL Server

Monday, July 17, 2006

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

SQL Server 2005 Features Comparison

There was an error in this gadget
There was an error in this gadget