You also have an opportunity to upgrade from log shipping to mirroring where the failover and tailback is pretty simpler as compared to Logshipping. Food for thought.

In high safety mode, if mirror db becomes unavailable, you need to break mirroring, since you don't need to block ur user transactions happening on ur principal which do a...

Yes, this is the same behavior I see in my SQL 2012 AG setup as well. Not sure why its not displaying roles for primary replicas on the secondary server....

Check your firewall settings - it shud be either disabled or you shud allow SQL port in the firewall exception list.

Since you are using Reporting in your application, you could offload your reporting load to Secondary Replica in SQL Server 2012 Availability group. Secondary Replica's can be made read-only in...

how many database files is your DB divided in?

Is your DB a OLTP or reporting DB?

Backup and restore strategies will depend on what should be your availability SLA and how...

For SQL 2008, we can enable trace flag 1448 on the instance of the publisher database. Then, Log Reader Agent will always copy the transactions that are marked for replication...

You can consider using some of the advanced replication parameters like:

CommitBatchSize, CommitBatchThreshold and SubscriptionStreams.

SubscriptionStreams is a interesting and useful parameter to make data move from Distributor to Subscriber in multiple...

I have been working with Clustering and DB Mirroring for 4 years now. Some points to consider in setting up mirroring also depend on how much latency is allowed on...

Allright, so here is the problem and I managed to fix it.

The DB was created ok, but then it was altered to increase the maxsize for the files.

ALTER DATABASE xyzStaging...

SQL does not allow to use "Alter database" on a snapshot db.

Finally, I got it.

I have used a Monitoring server to run the monitors pointing to my cluster name using a domain account. Advantages are that if there is a...

You may use the Query analyser to specify the UNC path. it works well.

I am not sure about the GUI in 2005

If you need to get your secondary databases online, then you will break log shipping. There is no need to run any log restores on your secondary databases.

You could just...

Can it be done as a part of failover? I mean as we have other resources depending on sql server, we can alsp have perfmon setup as dependent on sql.

So,...