If I understand your question right, you have a database mirroring set up. On the mirrored database, you have snapshot scheduled every hour, and the snapshot runs 3 seconds...

Check books online "ALTER DATABASE (Transact-SQL)". The example:

USE master;

GO

ALTER DATABASE AdventureWorks

SET SINGLE_USER

WITH ROLLBACK IMMEDIATE;

GO

I prefer restricted_user to single_user. Just leave yourself extra doors in case any process takes...

How about build the new cluster first, set up logins, restore a copy of databases, set up all the linked server/replication/jobs for testing purpose, also should have application testing on...

A very good article. I booked mark it 2 weeks ago and just got a chance to read today.

For “General comments on my first two mistakes” section,...

You may need to reset SPN to the new domain user account that the instance of SQL Server is running under.

Log reader agent stopped working, so the published data in the transaction log will not be sent/marked as being read. They remain in the transaction log.

You may need to...

If your table has one index, it should be a clustered index.

"Problems with not having a clustered index"

http://www.sqlservercentral.com/articles/Performance+Tuning/clusterthatindex/952/

Another point to verify restore is to get how long it takes to complete the restore, 2 minutes or 2 hours. Better to know than no idea.

You can also...

Have you created publication/subscription? Then need to run snapshot agent and distribution agent first, after that log reader agent will take care of the rest.

If you have problem on...

First time hear about this product.

I would read their whitepaper/manual and see how it works. Check their case studies and see which companies are using this product. Download...

Take a look here: http://www.informit.com/articles/article.aspx?p=599700

I doubt whether all steps have been implemented on your end.

check sp_helpsegment or sp_helpsegment mysegment

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15.0.sprocs/html/sprocs/sprocs141.htm

"1.2.12: How to Shrink a Database"

http://www.isug.com/Sybase_FAQ/ASE/section1.2.html#1.2.12

It is difficult. That is why sybase dba adds space/device very carefully. It should be well planned.

what type of replication? snapshot, transactional or merge?

Have you created publication? then create subscription?

I was searching error 625 and come across this post.

Does anyone know how to find this link, I would like to see how PSS says about this error.

"This may be...