How to install a passive node on an active/active SQL Server cluster
We have a SQL cluster server running with SQL Server 2005 Enterprise Edition SP2 on Windows 2003 Enterprise Edition. Currently the cluster has 2 nodes with Active/Active. Now I need to add a new node as a Passive node. So once I’m done, the cluster will be a Active/Active/Passive cluster. ...
View Answer
| May 14 2008 3:09 AM GMT
| asked by
SQL Server Ask the Experts
SQL Server clustering, SQL Server availability, Installation
What are the pros and cons for log shipping vs. replication in SQL Server? When is one favored over the other?
What are the pros and cons for log shipping vs. replication in SQL Server? When is one favored over the other?
View Answer
| Apr 30 2008 5:21 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server availability, SQL Server replication, Log Shipping
Looking for a stored procedure to monitor size of Transaction Log file
Is there any way I can create a stored procedure which will check for the Transaction Log file size - where we have a specified limit to grow - and if the Log file reached 80 percent of total size, email alerts can be sent to DBAs?
View Answer
| Apr 18 2008 1:11 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server transaction logs, SQL Server stored procedures, SQL Server availability
Are there any issues with setting up SQL Server 2005 log shipping with TDP & TSM?
Are there any issues with setting up SQL Server 2005 log shipping with TDP & TSM?
View Answer
| Apr 4 2008 1:53 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server backup, SQL Server availability, TSM
