InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 11:29:40 GMT20http://www.sqlservercentral.com/Forums/Topic1456600-1549-1.aspxTrying to get developer edition 2008R2 to mirror AdventureWorks with a monitor as an experiment on my PC. Is it possible to do this on one PC or do I need to setup VM's?I have three instances installed. AdventureWorks on 'MSSQLSERVER', a copy of AdventureWorks in recovery state on 'TWO' and 'THREE' setup as the monitor. The listener ports default to 5022, 5023 and 5024. SQL Server Browser is running.Been playing with this for a couple of days and just not getting it to work. I've tried to follow using the wizard and I always get to the point of starting to synchronize, then an error saying "TCP://desktop:5023" can not be reached or does not exist.TCP is enabled on all three instances and services restarted.I just have the home version of Windows 7 so no domain.Is this possible? If so, any hints to what I need to do to make this work?I'm thinking I need to do something with the listener ports but not sure what. Instance 'MSSQLSERVER' (the default) is set to port 1433 and 'TWO' and 'THREE' are dynamic.Thanks!NormanFri, 24 May 2013 10:06:16 GMTn.heyenhttp://www.sqlservercentral.com/Forums/Topic1456217-1549-1.aspxQuick question...I have an alert set up to email me whenever one of my mirrors move into state 6 ("connection with mirror lost"). Most times it loses the connection for a very brief time and doesn't reach the threshold for a failover (a network issue). This of course triggers an alert, when really I don't want to be alerted until the connection's been lost for 5 seconds.Will the "Delay Between Responses" option on the alert properties dialog box (set to 5 seconds of course) get me where I want to be, or will I have to employ some more complicated solution? Or, should I simply not monitor for state 6 and only monitor for when failovers have occurred (states 7 & 8)??Thanks!Thu, 23 May 2013 14:29:51 GMTThe Grateful DBAhttp://www.sqlservercentral.com/Forums/Topic928822-1549-1.aspxHi All, I have installed SQL on one of the nodes of a 2 node cluster but it failed, this was due to the service account not being a local admin, thought it was a member of the AD group that was a local admin. Anyway, I granted permission to that group, but still couldn't add the second node, because of the error after I installed. I can get the instance it is running, but there is no SQL agent present. I Tried a repair but that didn't work, so I decided to remove the node through the setup, but the instance does not appear, there is nothing in the dropdown list. Never seen that before. I have located this articlehttp://msdn.microsoft.com/en-us/library/ms180973(SQL.90).aspxNot sure about this, but it is an option.http://magmainteractive.net/weblogs/post/SQL-Server-2008-November-CTP-Uninstall-Headaches.aspxThis is probably not applipacable to a cluster.Any advice appreciatedAny advise would be appreciated.Thu, 27 May 2010 03:02:10 GMThenners72http://www.sqlservercentral.com/Forums/Topic1454510-1549-1.aspxHi Friends,I have a scenario where there are two servers A and B. A act as a publisher and B acts as a subscriber and transactional replication runs from A to B and B is used for reporting work.Now, I have a request from the business to create a new server C with the same replicated data. I have two choices here:1) I create Server-C as a subscriber and let server Server-A continue acting as publisher, therefore acting as subscriber for Server-B and Server-C. But I am not sure how this is going to be maintained?Let's say I need to re-initialize subscriber-C with a new snapshot, will it mean that it will apply same snapshot to existing and old subscriber Server-B.Can these two subscribers work independently?2) Another option in front of me is to treat Server-B as a publisher and have it replicate the data to Server-C. So for me it will become something like a daisy chain:A--->B---CI am worried here because what happens if I want to re-initialize subscriber B. In that case a snapshot from Server-A will run and the distributor agent by default drops all the tables in the subscriber and populate them again and since Server-B will be acting as a publisher for Server-C, it may not be allowed for distributor agent to work normally.Please give your inputs to this situation. Thanks in advance!RegardsChandan JhaMon, 20 May 2013 06:53:00 GMTchandan_jha18http://www.sqlservercentral.com/Forums/Topic1455707-1549-1.aspxCan someone direct me to a Microsoft article or possibly a SQL Server Central article showing the suggested process to install a Windows Service Pack on a multi node SQL Server Cluster? Our three node cluster is running Windows Server 2008 SP1 with 8 SQL Server 2008 Instances, and we'd like to install Win Server 2008 SP2 on each Node. Also MS DTC is on Node 1. We have 4 Instances active on Node 1, 4 instances on Node 2, and Node 3 is passive only. My thought is to Pause Node 3 and install SP3, when it's back up move what's on Node 1 to Node 3 then pause the cluster on Node 1 and update it. And finally do the same thing to Node 2 moving what it has back to Node 1.Is this feasible or is there some other way to do this? Thanks.Wed, 22 May 2013 14:34:16 GMTsamalexhttp://www.sqlservercentral.com/Forums/Topic1455013-1549-1.aspxHi,i am getting the below mentioned error for one of my database which is in replication, please help what needs to be done.Command attempted:{call sp_MSensure_single_instance (N'server1\SQLSERVE-DB1_Server1\SQLSERVE-6', 4)}Error messages:The merge process could not connect to the Publisher ' '. Check to ensure that the server is running. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199368)Get help: http://help/MSSQL_REPL-2147199368Another merge agent for the subscription or subscriptions is running, or the server is working on a previous request by the same agent. (Source: MSSQLServer, Error number: 21036)Get help: http://help/21036The merge process could not connect to the Publisher ' '. Check to ensure that the server is running.With RegardsDakshina MurthyTue, 21 May 2013 07:44:39 GMTdakshinamurthy-655138http://www.sqlservercentral.com/Forums/Topic1454504-1549-1.aspxHi guys,I have this issue when I installed a SQL 2008 cluster instance on the Windows 2012 OS. I have successfully installed the SQL 2012 cluster instances on the server and it fails over successful but the SQL 2008 instance does not failover to the secondary node.I get the following error in the system error logs:Cluster resource 'SQL Server (<instance name>)' of type 'SQL Server' in clustered role 'SQL Server (<instance name>)' failed.Based on the failure policies for the resource and role, the cluster service may try to bring the resource online on this node or move the group to another node of the cluster and then restart it. Check the resource and group state using Failover Cluster Manager or the Get-ClusterResource Windows PowerShell cmdlet.Can anyone please assist!.RegardsICMon, 20 May 2013 06:33:07 GMTImke Cronjehttp://www.sqlservercentral.com/Forums/Topic1454645-1549-1.aspxWe have a Alwayson availibility group setup on two clustered Windows 2008R2 machines. There is no shared storage setup, the database files reside on each nodes local drive. We stopped the sql service on one of them and it failed over fine. We started the service and it caught up. We next rebooted the replica machine. When the machine came back up the drive that held the database files and logs was completely empty. So the databases on the rebooted machine say recovery pending. Is this normal?Mon, 20 May 2013 11:09:33 GMTlmacdonaldhttp://www.sqlservercentral.com/Forums/Topic1454554-1549-1.aspxhi all, i would like to create a login on snapshot database on mirroring server.i have tried to create a login on snapshot database via principal database and when login on mirroring server , it s saying that the snapshot database is on ready only. any help please. thanks. regard.Mon, 20 May 2013 08:22:54 GMTdnguhttp://www.sqlservercentral.com/Forums/Topic1396403-1549-1.aspxOk,I've used CRYSTALDISKMARK before, bot never on a drive or LUN with mount points.I am about to validate performance on the SAN was delivered to me but I setup the cluster with mount points.Will the CRYSTALDISKMARK check on the root drive, let's call it "M" for this post, hit the mount points located under the same letter as well?I see no options to specify a folder or path ...Thu, 13 Dec 2012 14:32:16 GMTsql-loverhttp://www.sqlservercentral.com/Forums/Topic1453330-1549-1.aspxNeed to install sqlserver service pack sp4 in a cluster server 1.what are the pre-requesties i have to follow 2.cluster is in Active/Active also it is running for primary [ DC ] and secondary [ DR ] servers3. if i install service pack in the DB server [ DC ]is it necessary to install in the AP [ DR ] server also ?4. logshipping is running in primary server [ DC ]and secondary server [ DR ] 1. in this case we want to install sp4 in [ DR ] sever after monitoring for few days we want to install in the [ DC ] server.is it possible 2. if we install in [ DR ] server for both AP and DB servers [both nodes ] is it required to reconfigure the logshipping from DC to DR again ?Wed, 15 May 2013 23:36:21 GMTnaga.rohitkumarhttp://www.sqlservercentral.com/Forums/Topic1450879-1549-1.aspxWe have configured the log shipping.here backup job and copy jobs are working fine but restoring is not happening in secondary serverwhat could be the reasonWed, 08 May 2013 22:34:33 GMTNew persopnhttp://www.sqlservercentral.com/Forums/Topic1453181-1549-1.aspxI have four databases (size between 20MB to 1300MB) which has (Principal, Synchronized) next to there name And on the Witness Server they have (mirror, synchronized, restoring). It's been like this for two days. I belive this happen when one of our guys took the database offline to move the Log file. What do I need to do so the (Principal ,Synchronized) state isn't there next to the database name when I look at it in Studio Management?Wed, 15 May 2013 09:30:25 GMTkd11http://www.sqlservercentral.com/Forums/Topic1452002-1549-1.aspxMorning Everyone :-)I know this is a topic that has been widely discussed and I have read through a few articles on it but I cant seem to find an answer to my issue :unsure: I'm hoping some of the great minds here may be able to lend me a helping hand :-D I am working with the following setup listed below:[b]Server A:[/b] Principal - Publisher[b]Server B:[/b] Mirror[b]Server C:[/b] Distributor - SubscriberMirroring is setup and works fine with no issues, however I'm trying to make the system automatically failover to the following setup should Server A fail:[b]Server A:[/b] Failed.[b]Server B:[/b] Principal - Publisher. [b]Server C:[/b] Distributor - Subscriber. I have read up on setting the [b]-PublisherFailoverPartner[/b] to be Server B but the information I have gone through has left me fairly confused :ermm: I cant seem to figure out how the local publication on Server A will transfer to Server B when the -PublisherFailoverPartner comes into effect? I would really appreciate any help you can give :-) Oh and the specs for the servers are also listed below, thanks again.[b]Specs:[/b]Windows Server 2008 R2 StandardSQL Server 2008 R2Mon, 13 May 2013 02:54:36 GMTcraig.dixonhttp://www.sqlservercentral.com/Forums/Topic1447991-1549-1.aspxBefore I watched CBT Nuggets dicussing replication & mirroring. In it he described the following scenario (pictured below as I drew a diagram to help me understand his tongue twister. [url=http://www.pasteall.org/pic/show.php?id=50377]http://www.pasteall.org/pic/show.php?id=50377[/url]Paraphrasing, he said: "If the principal is mirrored then in the case of a failover it will still continue as expected; going from the mirrored server (new principal) to the subscribers. However, if it is a subscriber that is mirrored & that becomes avaiable then that subscriber will no longer be reached."This makes sense because it is sending to servers rather than cluster names. However, my question is (or rather seeking confirmation) this outcome detailed is only true when the replication uses the PUSH model. If the replication was done in a PULL model then opposite would occur (subscriber could no longer find the failed over publisher but a failed over subscriber would still locate the publisher just fine). Am I right in this assumption?DirdTue, 30 Apr 2013 06:39:53 GMTDirdhttp://www.sqlservercentral.com/Forums/Topic1450942-1549-1.aspxI have a database mirrored using async mirroring.Last night "something" happened to cause a large amount of unsent log on the principal.What is strange, is in Mirror monitor, although it shows unsent log of many GB's, the databases still show "synchronized". I would have thought they should be "synchroniz[b]ing[/b]Anyone experience this? Is my definition of "Synchronized" in async mirroring incorrect?Thu, 09 May 2013 02:58:53 GMTwinston Smithhttp://www.sqlservercentral.com/Forums/Topic1451617-1549-1.aspxWe use database mirroring ( high safety) for our HA needs.Our application uses db_datareader & db_datawriter role for running the applications.I had set up the application user account on mirror using the SID of primary.But when ever the fail-over happens, I have to explicitly assign the role to the new primary.(old mirror)Am i missing something? Is there any way that I should not involve myself when ever the fail-over happens?Environment :- SQL Server 2008 R2 Standard Edition.Fri, 10 May 2013 08:14:54 GMTNeeraj Dwivedihttp://www.sqlservercentral.com/Forums/Topic1445450-1549-1.aspxMy Cluster went down again. I don't have to say... I am having a not so good morning already ... :-(Here's the Cluster's error:[quote]Ownership of cluster disk 'Cluster Disk xxx' has been unexpectedly lost by this node. Run the Validate a Configuration wizard to check your storage configuration.[/quote]This looks to me as a Os or SAN error. The LUN is gone, then SQL goes down. Now, following our SAN admin's advice, we did apply this patch: [url]http://support.microsoft.com/?id=2718576[/url] ... but does not look like it resolved the main issue.We just started having this issue few weeks ago. But it was running fine for a two month period, maybe a bit more but with less workload.Has someone experienced this problem before?Tue, 23 Apr 2013 08:09:32 GMTsql-loverhttp://www.sqlservercentral.com/Forums/Topic1451819-1549-1.aspxHi,I am looking into setting up mirroring for DR purposes. What I want to know is the correct location for the Witness server at our DR site? The primary server will be in our office and the target server will be at our DR site.Thanks in advance.RussellSat, 11 May 2013 03:39:20 GMTRussell101http://www.sqlservercentral.com/Forums/Topic1448448-1549-1.aspxWe are investigating using database mirroring as a DR solution for sharepoint 2010. the sharepoint documentation states that high availability mirroring MUST be used to achieve automatic redirection of the client. However I don't agree with this as I don't believe a witness is required to get the [b]CLIENT [/b]to redirect, so high safety would be good enough.Except in a few blogs I cannot find it definitely stated in MS articles that the witness is not required for client redirect, reading between the lines you would say not, but it goes unstated, so can anyone back me up?ITs not that I am against a witness per se, its just I want to know what my options are in achieving automated client redirection.Anyone got feedback on mirroring with SharePoint 2010?Wed, 01 May 2013 08:51:45 GMTgeorge sibbaldhttp://www.sqlservercentral.com/Forums/Topic1447990-1549-1.aspxcluster validation test failing at Validate SCSI Device Vital Product Data (VPD) test. There's a hot fix to resolve this issue(http://support.microsoft.com/kb/2531907/en-us?sd=rss&spid=14134) But when we apply this hotfix, server is not responding and the sql installation is taking too long. Not sure how to over come this issue. Adding a node to the existing active passive cluster. Any suggestions???Tue, 30 Apr 2013 06:39:18 GMTdeep_kkumarhttp://www.sqlservercentral.com/Forums/Topic1451020-1549-1.aspxHere in my sql server Temp db is full and there is no disk spaceso here we are going to shrink the temp db but it is not workingwe don't have the another disk here i want to find out the global variables and stored procedures and kill themHow to find outThu, 09 May 2013 04:58:46 GMTNew persopnhttp://www.sqlservercentral.com/Forums/Topic1269630-1549-1.aspxI am installing SQL Server 2008 r2 SP1 on a 64-BIT Windows Server 2008 r2 SP1 Enterprise server in an Active/Passive failover cluster environment.I am trying to cover all my bases and following the documentation provided by msdn...I am going through the 'Before Installing Failover Clustering' ( [url]http://msdn.microsoft.com/en-us/library/ms189910.aspx [/url]) My question pertains to the following part of this article:[quote]Install Microsoft Distributed Transaction CoordinatorBefore installing SQL Server on a failover cluster, determine whether the Microsoft Distributed Transaction Coordinator (MSDTC) cluster resource must be created. If you are installing only the Database Engine, the MSDTC cluster resource is not required. If you are installing the Database Engine and SSIS, Workstation Components, or if you will use distributed transactions, you must install MSDTC. Note that MSDTC is not required for Analysis Services-only instances.Configure Microsoft Distributed Transaction CoordinatorAfter you install the operating system and configure your cluster, you must configure MSDTC to work in a cluster by using the Cluster Administrator. Failure to cluster MSDTC will not block SQL Server Setup, but SQL Server application functionality may be affected if MSDTC is not properly configured.[/quote]I am installing the Database Engine and SSIS which puts me into the must install MSDTC category.My question pertains to the statement 'you must configure MSDTC to work in a cluster by using the Cluster Administrator'.Can someone provide an article for a best practice for how to do this?Do I need to also (is it required/can I get away without)?...Enable Network Access Securely For MS DTC ([url]http://technet.microsoft.com/en-us/library/cc753620(WS.10).aspx[/url])Enable Network DTC Access ( [url]http://technet.microsoft.com/en-us/library/cc753510(WS.10).aspx[/url] )For now I will not be doing the two items above, but I feel that I will need to configure MSDTC to work in a cluster.I really do not want to over configure this environment for features which I do not need.Any advice would be useful.Tue, 20 Mar 2012 09:05:33 GMTEric1/2aBhttp://www.sqlservercentral.com/Forums/Topic1451104-1549-1.aspxDoing first 2012 active/passive cluster install. On the screen which looks the same as 2008 where it needs to validate the cluster network I put in the IP I was give to link to the sql instance name. It fails and tells me it can not validate the ip address. I can't even ping the IP from a command prompt. Am I missing something, I don't think this will work and validate if I can't ping it. Thu, 09 May 2013 07:19:13 GMTtimscroninhttp://www.sqlservercentral.com/Forums/Topic1450989-1549-1.aspxHello FriendsI want this type output.Here I want in first column how many members are join today(registration),and in second column sum of member before today,and third column the sum of two columns.I want to display this records in c#where user can pass current date(today date) and according to this he/she will get this output.If this possible in single query?Thu, 09 May 2013 04:16:57 GMTkishor.patgirhttp://www.sqlservercentral.com/Forums/Topic1450148-1549-1.aspxhi,i'm in the process of automating the database restore using powershell....but before getting the default paths of data and log files of an instance...i would like to check if database already exists or not ?Please let me know how to get that information...IF EXISTS (select d.name,f.physical_name from sys.master_files f, sys.databases d where f.database_id = d.database_id and d.name = 'Test_Restore')select f.physical_name from sys.master_files f, sys.databases d where f.database_id = d.database_id and d.name = 'master'before the restore i would like to check if db exist, if it's in it should generate the data and log file path . if it's not in we need to get default path of instance or master db path.please let me knowThanks in advanceTue, 07 May 2013 07:52:35 GMTRobin35http://www.sqlservercentral.com/Forums/Topic1445870-1549-1.aspxHi,Log shipping (backup job) failed after we change SQL service account in our production database and DR database server. Earlier its was working fine with existing account name (Account name having domain admin rights) but current a/c name doesn't have domain admin rights its normal domain account.Is it having any chances to failed log shipping process?Pls advice on this...thanks.Wed, 24 Apr 2013 05:35:44 GMTpradeep.mohanhttp://www.sqlservercentral.com/Forums/Topic1445717-1549-1.aspxHi Guys,We have got a active passive cluster. and I am getting service account trying to access the master database on the active node using the database mail. That's what i found through the profiler trace. I am getting error logged into the active node sql server logs saying Login failed for user . Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: ]This error logs very often, we can say every 1 -2 minutes.Can anyone please throw some light that what is trying to access this? and how can i find more info?ThanksTue, 23 Apr 2013 16:44:21 GMTzombihttp://www.sqlservercentral.com/Forums/Topic1448977-1549-1.aspxGot some iSCSI issues on my Cluster. After reviewing the case with Microsoft and apply a MS hotfix (see my other thread about it) ... a Microsoft Engineer suggest the following to us:iSCSI changes:-Under Discovery, select Discover Portal, and re-enter the iSCSI targets by manually typing them.-Go to Targets tab, select each target, hit Connect, then Advanced. Instead of Default, change local adapter to Microsoft iSCSI Initiator-Specify actual IP addresses on "Initiator IP" and "Target portal IP". Specify "Microsoft iSCSI initiator" on "Local Adapter"-Accept changes. Click ok and reboot. -Repeat on other nodeI guess that above changes should be applied like any other regular and normal Os change or patch, is that correct? Here the additional Cluster steps, to make it safe:-Remove passive node from list of owners-Perform iSCSI changes-Add removed node back to Cluster-Failover all resources to the node with new iSCSI changes-Check SQL-Remove other node from list of owners-Perform iSCSI changes-Add removed node back to Cluster-Check SQLAny comments or suggestions? Thu, 02 May 2013 14:22:53 GMTsql-loverhttp://www.sqlservercentral.com/Forums/Topic1448554-1549-1.aspxI have a few questions regarding mirroring:1. is the data laid down page for page on the mirror? I.e if there is a very fragmented index on the primary, will it be fragmented on the secondary?2. Is the buffer cache mirrored? i.e will all pages in cache on the primary be in cache on the mirror, so the cache is not "cold" on failover?Thanks!Wed, 01 May 2013 12:13:25 GMTwinston Smithhttp://www.sqlservercentral.com/Forums/Topic1447531-1549-1.aspxsqlserver 2008 R2.The error is:TITLE: Database Properties------------------------------An error occurred while starting mirroring.------------------------------ADDITIONAL INFORMATION:Alter failed for Database 'FASTContent_CrawlStoreDB_2d3e9be9ef044393a736f16d569f0952'. (Microsoft.SqlServer.Smo)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.2500.0+((KJ_PCU_Main).110617-0038+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+Database&LinkId=20476------------------------------An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)------------------------------Database 'FASTContent_CrawlStoreDB_2d3e9be9ef044393a736f16d569f0952' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details. (Microsoft SQL Server, Error: 945)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.2500&EvtSrc=MSSQLServer&EvtID=945&LinkId=20476------------------------------BUTTONS:OK------------------------------Mon, 29 Apr 2013 07:50:07 GMTronnigodfreyhttp://www.sqlservercentral.com/Forums/Topic1448173-1549-1.aspxWe have SQL Server 2008 SP1 running a [b]single[/b] node cluster SQL 2008 R2 SP2. We've had multiple attempts to install Cumulative Update 3. When I rebooted this morning, I noticed that the cluster disks initially showed Failed in Cluster Manager. I stared the SQL upgrade anytay, thinking that if SQL service was off, it woulsn't matter. Minutes later I was able to start the disks manually, but the update still failed. After unintalling the SQL CU and rebooting, ALL of the cluster resources showed offline. was able to manually turn on the Network Name & Disks, but left SQL off. The SQL upgrade again failed, with Details.txt containning the following: 2013-04-30 07:16:02 Slp: Taking cluster group 'SQL Server (MSSQLSERVER)' offline2013-04-30 07:16:04 Slp: Configuration action failed for feature SQL_Engine_Core_Inst during timing ShutdownNonInstance and scenario ShutdownNonInstance.2013-04-30 07:16:04 Slp: The cluster group 'SQL Server (MSSQLSERVER)' could not be taken offline. Error: The group or resource is not in the correct state to perform the requested operation. (Exception from HRESULT: 0x8007139F)2013-04-30 07:16:04 Slp: The configuration failure category of current exception is ConfigurationFailure2013-04-30 07:16:04 Slp: Configuration action failed for feature SQL_Engine_Core_Inst during timing ShutdownNonInstance and scenario ShutdownNonInstance.2013-04-30 07:16:04 Slp: Microsoft.SqlServer.Configuration.Cluster.ClusterException: The cluster group 'SQL Server (MSSQLSERVER)' could not be taken offline. Error: The group or resource is not in the correct state to perform the requested operation. (Exception from HRESULT: 0x8007139F) ---> System.Runtime.InteropServices.COMException (0x8007139F): The group or resource is not in the correct state to perform the requested operation. (Exception from HRESULT: 0x8007139F)After uninstalling & rebooting again, I though I would attempt the upgrade with the SQL Service running, it would fail to start via Cluster Manager, saying "The module cannot be found." I showed this to our SAN guy, and he started SQL via the Services Applet. The Next CU install failed again.Now The SQL Server Item in Cluster Manager is inoperative. It will not start SQl or load the properties tab (Error loading properties for this item). The second tab reads "The specified node does not support a resource of this type. This may be due to version inconsistancies or the absence of the resource dll on this node."SQL Failed to start from SQL Configuraiton Manager but did start (as did SQL Agent) from the Windows Services window. Connections can be made through the Clustered Network Name & IP and users are back in the apps.Naturally we'd like to fix this without breaking it more first. Since the Clustered resources were built by the SQL Installation Wizard, we're reluctant to delete & rebuild it. The SAN guy recomends to a Repair from SQL Setup, but this looks like a Cluster issue to me. We could also run the Cluster What's the best approach at this point with the least risk of breaking it further? Tue, 30 Apr 2013 11:50:16 GMTdan-572483http://www.sqlservercentral.com/Forums/Topic1445742-1549-1.aspxHi ,Im using an Active/Passive SQL Cluster 2008 R2 Standard Edition.In my task to relocate the System Databases, I messed up the db names and file paths ( so stupid of me ) of msdb and model.Just prior to start, I have taken a backup of the 3 databases model, msdb and maste.Since i realised that I made a mistake and I was still connected to SSMS , i restored the backup of msdb but the SQL database fails to start.I tried connecting using : net start mssqlserver /f /m /t3608That started the database. Then i proceeded to connect to the database using:sqlcmd -eThis resulted in the following error.HResult 0x2, Level 16, State 1Named Pipes Provider: Could not open a connection to SQL Server [2].Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online..Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : Login timeout expired.I then navigated to the SQL logs and found the following erros logged. Please advice how i should proceed or How i can get the database up and running (SQL cluster) and restore the backup for msdb and model if necessary.Error Log:2013-04-24 08:53:50.73 Server Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)2013-04-24 08:53:50.73 Server (c) Microsoft Corporation.2013-04-24 08:53:50.73 Server All rights reserved.2013-04-24 08:53:50.73 Server Server process ID is 4428.2013-04-24 08:53:50.73 Server System Manufacturer: 'VMware, Inc.', System Model: 'VMware Virtual Platform'.2013-04-24 08:53:50.73 Server Authentication mode is WINDOWS-ONLY.2013-04-24 08:53:50.73 Server Logging SQL Server messages in file 'P:\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG'.2013-04-24 08:53:50.73 Server This instance of SQL Server last reported using a process ID of 1424 at 4/24/2013 8:53:49 AM (local) 4/24/2013 12:53:49 AM (UTC). This is an informational message only; no user action is required.2013-04-24 08:53:50.73 Server Registry startup parameters: -d P:\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf -e P:\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG -l P:\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\mastlog.ldf2013-04-24 08:53:50.73 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.2013-04-24 08:53:50.73 Server Detected 4 CPUs. This is an informational message; no user action is required.2013-04-24 08:53:51.44 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.2013-04-24 08:53:51.60 Server Node configuration: node 0: CPU mask: 0x000000000000000f:0 Active CPU mask: 0x000000000000000f:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.2013-04-24 08:53:51.96 spid7s Starting up database 'master'.2013-04-24 08:53:52.03 spid7s CHECKDB for database 'master' finished without errors on 2013-04-02 13:52:09.170 (local time). This is an informational message only; no user action is required.2013-04-24 08:53:52.06 spid7s FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.2013-04-24 08:53:52.08 spid7s SQL Trace ID 1 was started by login "sa".2013-04-24 08:53:52.09 spid7s Starting up database 'mssqlsystemresource'.2013-04-24 08:53:52.10 spid7s The resource database build version is 10.50.1600. This is an informational message only. No user action is required.2013-04-24 08:53:52.37 spid7s Server name is 'SQLCLUSTER'. This is an informational message only. No user action is required.2013-04-24 08:53:52.37 spid7s The NETBIOS name of the local node that is running the server is 'NODE02'. This is an informational message only. No user action is required.2013-04-24 08:53:52.44 spid11s Starting up database 'model'.2013-04-24 08:53:52.46 spid11s Error: 5173, Severity: 16, State: 1.2013-04-24 08:53:52.46 spid11s One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files. If this is an existing database, the file may be corrupted and should be restored from a backup.2013-04-24 08:53:52.46 spid11s Error: 5173, Severity: 16, State: 1.2013-04-24 08:53:52.46 spid11s One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files. If this is an existing database, the file may be corrupted and should be restored from a backup.2013-04-24 08:53:52.46 spid11s Log file 'P:\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\modellog.ldf' does not match the primary file. It may be from a different database or the log may have been rebuilt previously.2013-04-24 08:53:52.46 spid11s Error: 945, Severity: 14, State: 2.2013-04-24 08:53:52.46 spid11s Database 'model' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.2013-04-24 08:53:52.46 spid11s Could not create tempdb. You may not have enough disk space available. Free additional disk space by deleting other files on the tempdb drive and then restart SQL Server. Check for additional errors in the event log that may indicate why the tempdb files could not be initialized.2013-04-24 08:53:52.46 spid11s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.Many Thanks,JaiTue, 23 Apr 2013 19:29:36 GMTmJaihttp://www.sqlservercentral.com/Forums/Topic1437595-1549-1.aspxWe have a two node cluster. In order to utilize the max resources we are planning to add more instances to this cluster by adding few more nodes. Let us assume--server A - cluster node--100 GB ram and 24 core cpu (active)server B - cluster node--100 GB ram and 24 core cpu( active)server C - new node -- 50 GB ram and 12 core cpu( passive)server D - new node -- 50 GB ram and 12 core cpu (passive)What we are planning to do is to run sql instance of server C and D on server B and make use of the resources. When server A fails we need it to failover to server B and if this happens we can manually failover the two instances running on server B to node C and node D respective. Is this possible? I know in cluster all the nodes should have same resources. Need suggestions?Mon, 01 Apr 2013 13:46:19 GMTdeep_kkumarhttp://www.sqlservercentral.com/Forums/Topic1447050-1549-1.aspxHi All,I have created the sql job refering to the microsoft article.http://technet.microsoft.com/en-us/library/cc966392.aspx#XSLTsection129121120120For the step: Record state changeINSERT INTO dbo.[DB Mirroring State Changes] ( [Event Time], [Event Description], [New State], [Database] ) VALUES ( $(WMI(StartTime)), '$(WMI(TextData))', $(WMI(State)), '$(WMI(DatabaseName))' )I am getting this error message and sql job is failing:[i]Unable to start execution of step 2 (reason: The job step contains tokens. For SQL Server 2005 Service Pack 1 or later, you must use the appropriate ESCAPE_xxx macro to update job steps containing tokens before the job can run.). The step failed.[/i]Any help is appreciated. Thanks.Fri, 26 Apr 2013 09:01:41 GMTmuthyala_51http://www.sqlservercentral.com/Forums/Topic1447408-1549-1.aspxIn High safety mode without automatic failover, Principal database waits for the acknowledgement from the mirror database. If changes has been made on the mirror and acknowledgement is sent but it could not reach the principal due to some network/hardware issue , transaction on principal will be rolled back as it could not get acknowledgement . Now what will happen to the data committed on the mirror database ( IN a DR Scenario where no principal is available)Thanks in advanceMuraliMon, 29 Apr 2013 02:55:38 GMTmurali.jillellamudi 85871http://www.sqlservercentral.com/Forums/Topic1447198-1549-1.aspxHi I have configured db mirroring successfully without witness.later when im adding witness server i have constantly failed with the following error"Alter Database command couldn't sent to remote server instance 'TCP://FKBSUB:5022'.The database mirroring configuration is not changed.Verify Server is connected and try again (Microsoft SQL Server,Error:1456)"my principal in on sp2mirror on sp1witness on sp1all enterprise editionthanksFri, 26 Apr 2013 16:32:38 GMTkkarthik117http://www.sqlservercentral.com/Forums/Topic1446764-1549-1.aspxHi,Would help if you could provide the procedure to move the master database from one drive to another in a SQL 2008 cluster.Thanks,JaiThu, 25 Apr 2013 19:35:19 GMTmJaihttp://www.sqlservercentral.com/Forums/Topic1445353-1549-1.aspxHi there,We currently have an issue with one of our SQL 2008 R2 Clusters. The cluster contains 2 virtual nodes with 2 SQL instances, and both of the nodes are identical in terms of build and updates/hotfixes etc. (The only difference is that the primary node has more memory and processors allocated to it, as the second node is just kept as a passive node).The issue is that when all the resource groups are running on the primary node, the disk performance seems very poor. For example, when the databases are backed up (whether to another server or even to a local drive) it runs slowly, as the read/write performance is so slow. Also, even when just copying and pasting files between drives on the server it is very slow, so it does not appear to be just a SQL issue.Initially it appeared there was an issue with the disks, but when the cluster is failed over to the secondary node the read/write performance is suddenly fine, so it seems the issue is with the primary node.We have removed, rebuilt and re-added the node to the cluster but the issue remains. I'm not quite sure where to go next....any thoughts?Thanks,MattTue, 23 Apr 2013 04:56:01 GMTmatt.gytonhttp://www.sqlservercentral.com/Forums/Topic1446314-1549-1.aspxHi,Iam tasked to move our System Databases (master,model & msdb) to a new storage location onto a different LUN / drive. Its a SQL Server 2008 R2 Active/Passive failover SQL Cluster.I'm assuming that the process for moving all the 3 databases are same. Is the procedure any different for moving the master database? Please advise.Aside, I'm planning to proceed it in this order: Model and then MSDB and then move the master. Is that okay?Other than taking a backup of these 3 System Database files, is there any thing else that I should safe guard so i can revert back the database in the event of a calamity?As for the Cluster, am I required to do anything, take any resource offline, etc?Thanks,JaiThu, 25 Apr 2013 00:58:34 GMTmJai