Search Results | SQL Server Performance Forums

Security account for log shipping in cluster environment

Thread by: arka, Nov 4, 2011, 1 replies, in forum: SQL Server 2005 Log Shipping

We need to set up a log shipping for SQL-2005 SP3 instance in clustered environment to DR server. The cluster and DR are in absolutely different...

Performance monitoring script for SQL-2000

Thread by: arka, Jun 24, 2010, 3 replies, in forum: General DBA Questions

We are planning to set up performance monitoring tools/scripts to monitor daily activities of our SQL servers. For SQL-2005 and 2008 we will be using...

SQL Management Studio got frozen after saving maint plan

Thread by: arka, Sep 30, 2009, 1 replies, in forum: SQL Server 2008 General DBA Questions

We have couple of Windows 2008 servers with SQL-2008. After creating a new maintenance plan and pressing Save button, the Studio got frozen for...

SQL-2000 linked server to SQL-2005

Thread by: arka, Sep 22, 2009, 2 replies, in forum: SQL Server 2005 General DBA Questions

I'm having troubles creating a linked server. In SQL-2000 environment I need to create a linked server to SQL-2005 Named Instance. Iâ€™m able to see...

Changing published database question

Thread by: arka, May 12, 2008, 1 replies, in forum: Performance Tuning for SQL Server Replication

Our vendor gave us a script to apply changes to their application and a database that is being published in transactional and snapshot replications....

Maintenance Plans - Unhandled exception message in scheduling

Thread by: arka, Mar 18, 2008, 1 replies, in forum: SQL Server 2005 General DBA Questions

I just applied SP2 to our SQL2005 cluster environment. When I try to schedule a maintenance plan it produces:"Unhandled exception has occurred in a...

Remove instance from cluster

Thread by: arka, Apr 30, 2004, 2 replies, in forum: SQL Server Clustering

We have two Win2K SQL clustered servers. I need to remove one SQL instance from the cluster without affecting the other SQL instance. Unfortunately,...