Hi,

It tries to open model to re create tempdb, and then as it can't create tempdb, it stops. If you want to specify a new location for model, you may...

Hi Kim,

Not aware of a formula of any kind. A good start is to identify the amount of transactions per hour during business and off-business hours. Taking regular log backups...

Hi,

Just a quick trick to pinpoint such problems, when windows error numbers cannot be resolved:

System.Data.SqlClient.SqlError: A nonrecoverable I/O error occurred on file "C:\PROCES.bak:" 112(failed to retrieve text for this error....

Hey ,

Good to know

Most of the best books on SQL Server do not explore the MSCS part. The only one I have dealing with it is Ken Henderson's SQL2005 Practical...

Hi,

You cannot take a mirrored database offline, even when the session is paused. Maybe it is suggesting to manually failover 1 database on 7. The WMI-based alert then detects...

Hi David,

Not easy to predict the resources you will need from an armchair. If memory is a problem, go to 64 bits Enterprise Edition if affordable, you won't have to...

Hi Jon,

From the White paper for SQL 2008 :

Licensing Note: If you install SQL Server 2008 on a separate computer or as a separate instance on the same computer as...

Ooops

Looks like the term 'active-active' has been banished from MS vocabulary. The preferred terms are now single instance clusters and multi-instances clusters. This is because a clustered SQL Server Cluster...

Hi all,

Sorry to get back to you this late, I was travelling last week, not a chance to have a look at the forums.

Anyway, I followed Mike's piece of advice...

Yes, exactly.

There are no huge transactions opened at the publisher, the other subscriber (in Germany) is replicating with no latency at 600 cmd/s.

I've also noticed that when initializing just after...

Hi Roy,

I agree on the RAID stuff, but you know how it works. DBA's are barely involved from the project's kickoff. The server was already set up with this RAID...

Hang on, we have eventids 129 from HpCISSs2 on the bow, I assume it refers to the raid controller. It could indicate a problem with the on-board cache.

Let you know.

Thanks,

Daivd...

Thanks Ian,

I'd like nevertheless to let the distribution agent complete its reading on MSrepl_commands and start applying before I consider stopping it to try a different configuration. FYI, the replication...

Thanks Mike,

I realized I didn't mention two things in the design:

- There are two subscribers on this publication (so 2 distrib.exe): one is the matter of concern, and is local...

Thanks Mike,

You are right, I've considered once to split the single publication into multiple ones, but for some reason it didn't happen.

I've disabled the distrib cleanup temporarily to let the...