Are you still having any issues, or did you resolve everything on your own? Sounds like you have it well in hand.

If not, perhaps you would have better luck doing...

Do the maintenance plans show up in msdb.dbo.sysssispackages? do the subplans show up in msdb.dbo.sysmaintplan_subplans?

What is the output of this query?:

Use msdb;

Select SP.name, SP.folderid, SPF.parentfolderid, SPF.foldername

From dbo.sysssispackages SP

Left Join dbo.sysssispackagefolders...

Yes, filestream has to be enabled at the server level first using SQL Server Configuration Manager. Make sure you enable and configure filestream identically on both servers.

Agree 100% with Daxesh. There is increased CPU due to the compression, but the decreased IO offsets most of the CPU hit. The big exception is if the database is...

Codezilla-292868 (5/31/2012)

---

Did the restore complete? If it did how long did it take. I am in a similar kinda of situation. The restore says 100% processed but it is still...

Actually, it depends on the storage type during install. If using shared drives, it's 25 instances and if using SMB fileshares, it's 50 instances.

Using SMB fileshares is an edgecase though,...

I laughed very hard at the replies here, but if we're posting serious answers now, I think the OP should start with this post by Paul Randal: http://www.sqlskills.com/BLOGS/PAUL/post/The-art-of-asking-email-questions-or-not.aspx

This post is...

I really like the way you demonstrated the difference in times in the restore process. I'm sure smeone will point out that you can skip zeroing out the log file...

Please post your merge statement.

+1000 Nobody has ever gotten fired...

Correct. Automatic failover is not required to use the Failover Partner attribute in the connection string.

For replication, I recommend using load balancing in front of the replicated servers. This gives...

Compression of log backups is very minimal. The CPU cost of compression is mostly balanced out by the reduced cost of IO (which is also CPU).

Security isn't set up correctly. How is the distribution agent connecting to the subscriber? Check the accounts and permissions.

Thanks for the update! This is a very interesting case.

Sounds like it may be a problem that is causing the snapshot to fail. Can you try running CheckDB with the TABLOCK option?

DBCC CHECKDB ('WSS_Content_8e01f4f2-eabb-404f-939e-90d3b9a633dc') WITH TABLOCK, ALL_ERRORMSGS, NO_INFOMSGS;