Thursday, July 25, 2013

[MS SQL Server] Adding New Node to exisiting SQL Server 2008 R2 Cluster

[MS SQL Server] Adding New Node to exisiting SQL Server 2008 R2 Cluster

Adding New Node to exisiting SQL Server 2008 R2 Cluster

Posted: 25 Jul 2013 05:08 AM PDT

Hi,I hope someone will be able to assist me. I currently have an active/passive cluster setup on SQL Server 2008 R2. My active node has 2 named instances that are running on the same machine. Both named instances are failing over to my single passive node. I want to add a new node and move one of the named instances to the new node and then add that node to my cluster. So the end result i would like to have 2 active nodes and one passive node. So my question is do i need to physically move or re-install one of the instances on the new node and then add that node to the cluster, or do i first add the new node to the cluster and then just use the cluster manager to move one of the instances to run on the new node?Thanks in advance

Cluster backup drives

Posted: 25 Jul 2013 03:24 AM PDT

I cannot see the main backup drive in SQL cluster when attempting to do a restore. The backups for the cluster is stored on this drive. I only see three of the four SAN mapped drives (which are desiegnated as reserve drive in disk manager). Is there somewhere in SSMS I add the drive I cannot see or is this something to do with SAN?Thanks in advance.

delete old SSIS log files using maintenance plan

Posted: 24 Jul 2013 05:21 AM PDT

We have a SSIS log folder that has a lot of daily log files for SSIS packages.I am hoping to use maintenance plan to delete the files.So I chose the task of maintenace clean up task, and browse to the folder, and put the extension txt.and select older than one hour to test.But no files are deleted,is it because this only applies to backup filea nd maintenance plan report file?but look at the SQl it genreate: it is :EXECUTE master.dbo.xp_delete_file 1,N'D:\_SSISFILES\Log\' ,N'txt',N'2013-07-24T10:19:31',1So I guess it should not matter what files are they, as log as it has an extension of txt.But why it is not working?THanks

LCK_M_RIn_NL lock blocking inserts

Posted: 16 Jan 2012 07:36 AM PST

Has anyone seen this specific lock contributing to a significant wait/blocking time? What could be the cause/solution?The description here is not very helpful: "Occurs when a task is waiting to acquire a NULL lock on the current key value, and an Insert Range lock between the current and previous key. A NULL lock on the key is an instant release lock. For a lock compatibility matrix, see sys.dm_tran_locks (Transact-SQL)."http://msdn.microsoft.com/en-us/library/ms179984.aspxIs it possible that multiple threads trying to insert records in the same table at the same time end up blocking each other with this lock?Thanks

Webservice to establish connection with SQL Server

Posted: 24 Jul 2013 08:13 PM PDT

Hi,Can i get a sample [b]webservice [/b] which can:1. Connect to SQL Server 20082. Take 'Database table name' as input and return its recordsPlease help.
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog