[MS SQL Server] Adding New Node to exisiting SQL Server 2008 R2 Cluster |
- Adding New Node to exisiting SQL Server 2008 R2 Cluster
- Cluster backup drives
- delete old SSIS log files using maintenance plan
- LCK_M_RIn_NL lock blocking inserts
- Webservice to establish connection with SQL Server
| 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 |
| 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. |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / SQL Server 2008 Administration To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment