Viewing 15 posts - 6,376 through 6,390 (of 9,244 total)
ananda.murugesan (10/14/2011)
after that I have successfully installed cluster failover setup in corporate domain controller.
not sure what you mean by this?
ananda.murugesan (10/14/2011)
also add second node.
so you ran sql server setup...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 14, 2011 at 5:24 am
bailifei2011 (10/14/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 14, 2011 at 2:50 am
there's probably a way through Powershell to do this but i just havent had time to explore it yet 🙂
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 14, 2011 at 2:41 am
yes execute in a job step as ActiveX VB script, paste the code straight into the job step dialog
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 13, 2011 at 4:05 pm
i use a simple VBScript to prune files
Option Explicit
'Delete all SQL Server backup files more than x days old
Dim oFS, oSQLBackupFol, oFol, oFil
Set oFS = CreateObject("Scripting.FileSystemObject")
Set oSQLBackupFol = oFS.GetFolder("D:\MSSQL\Backup") ...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 13, 2011 at 8:59 am
currently the trace file is set to reach 5MB and not rollover, is this your desired action
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 13, 2011 at 8:50 am
have you checked the stack dump files to see whats in there
D:\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump03xx.txt
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 13, 2011 at 3:47 am
but you should gather all details immediately as logs will not last for ever as you have found out.
Next time you have an issue take a copy of the cluster.log
Do...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 13, 2011 at 3:17 am
just out of interest, why are you worrying about an event that happened 2 weeks ago. Why did you not tackle this at that time
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 13, 2011 at 3:09 am
sqlfriends (10/12/2011)
The thing I concerned is reporting service, we...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 13, 2011 at 3:05 am
srilu_bannu (10/12/2011)
Sounds easy.But i was unable to script it.
I went to file menu and then opened file and went to script file.
It is not working.
Best to start a new thread...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2011 at 1:38 pm
daniel.b.handy (10/12/2011)
Hi,The logs don’t go back enough, on a side note, i found the following in the application log:
There is only 1 log, its called cluster.log
This details cluster failure events
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2011 at 12:38 pm
sorry, my bad.
check
C:\Windows\cluster
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2011 at 9:25 am
the TUF file is the standby file. Do not delete it
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2011 at 9:23 am
check the cluster.log at the following location
C:\Windows\system32\cluster
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2011 at 8:46 am
Viewing 15 posts - 6,376 through 6,390 (of 9,244 total)