Comparing query performance from different server/SQL edition? It is supposed to compare based on the same server setting/configuration.

Microsoft has a tool "SSMA Access" for the migration.

http://www.microsoft.com/sql/solutions/migration/access/default.mspx

http://cfpayne.wordpress.com/2006/07/23/how-to-import-microsoft-access-into-sql-server-2005/

an early post about this topic:

http://www.sqlservercentral.com/Forums/Topic281187-146-1.aspx

Yes. The data will be restored to the standby server.

Once log shipping is set up, it backs up the transaction log from the primary server and restore to the...

My collections about Repl:

http://www.sqlservercentral.com/articles/Replication/2690/

http://www.informit.com/authors/bio.aspx?a=be0470b3-ab7f-4cc5-8f97-7c0ae88ff5de

http://www.code-magazine.com/Article.aspx?quickid=0311101

http://www.replicationanswers.com/Transactional.asp

What happened to that free admission? If you set a on sale on this site, it would go very fast.

I believe.

This article discusses three common problems DBAs are likely to encounter when columns have the identity property,...

http://www.simple-talk.com/sql/database-administration/the-identity-crisis-in-replication/

Create a view and try to replicate the view.

"You can replicate SQL Server 2000 database tables, views, and stored procedures. When you replicate a table or view, you are sending...

Thank Damon. It is a very handy resouce.

I am wondering whether M$ should have this kind of webpage rather than the other creates for M$.

Thank you for sharing. A lot of efforts. I thought it could be a simple script to migrate roles.

I used sp_help_revlogin for login migration to another server. ...

Restoring the backup to another server to do the integrity check is an option. This also helps to verify your backup. The check is against the restored database...

In theory as frequently as possible so you can detect the error early (if any). In reality, do you have window to run it every day? how big...

Thank you George. Good to know those unexpected events.

I tried to search build 2162 so I can set up a test. But I could not find...

MS has writepaper about performance considerations, including a lot of information.

http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/dbm_best_pract.mspx

Impact of long and log-intensive transactions

Long and log-intensive transactions can impact performance and failover time. Some common examples...

May try this out:

Set up the backup job on both servers (principal & mirror). Disable/enable them while server failover. The failover event can be detected, so to...