OK, so you've got past the point where you specify the various components you want to install and the authentication mode screen. What authentication method are you using?

Is port 1433...

There is nothing specific that you need to do in a clustered environment that you wouldn't do in a non-clustered environment as far as replication is concerned.

First things first, you'll...

I don't know whether your Principal and Mirror servers are on the same LAN, but if not and you have a firewall configured, check that your Principal server has access...

Look up 'partitioning' in BOL or on the Microsoft Technet site. I suggest you need to implement what is known as a 'sliding window' type of partitioning whereby data to...

You could achieve want you want using a Powershell script executed via a Scheduled Task. Have a look at this post:

http://www.sqlteam.com/article/monitoring-sql-server-agent-with-powershell

Regards

Lempster

At what stage of the install process do you get this error? Are you installing a default or named instance? What port are you using and is that port available?

Regards

Lempster

The replies you've been given so far plus the Release Notes for the Service Pack should be all you need to carry out a successful install of SP2. No one...

Eh? How would that provide a clue as to why backups are bigger than the database? :unsure:

KathyGibson96 (7/9/2009)

---

...we plan on only replicating a few high volume tables (our database has over 300). This means we'll need to be able to sync from a fresh backup...

Also be aware that backing out a Service Pack pre-SQL Server 2008 is not a simple matter; you have to uninstall and reinstall SQL Server!

Regards

Lempster

I think TRACEY is probably right here - the NUM column was added on the Publisher after replication was set up and that column already existed for the replicated table...

Perhaps you have deleted some data since you took that particular backup..?

What version of SQL Server are you using? If it's 2008 then you might be using one of the...

Hello Ning,

Well done for tracking down that it is the 'Distribution clean up' job that removes the old snapshot files and folders! I had considered that, but discounted it because...

I would say that if your replication scenario demands that you generate a new snapshot every hour, you are using the wrong type of replication and should consider Transactional Replication...

Thanks very much to both of you. 🙂