Viewing 15 posts - 6,376 through 6,390 (of 9,241 total)
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
GilaMonster (10/12/2011)
Perry Whittle (10/12/2011)
do you have any log backups happening outside of the log shipping plan?
If there was, the error would be that the log backup is too new to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2011 at 8:40 am
what is providing your shared storage for your cluster, do you have a SAN or some other NAS?
Do you have a storage administrator, someone who looks after said SAN or...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2011 at 8:38 am
To be honest i would just go for this
1. On Node B: Add the required roles and features to enable for failover clustering
2. On Node A: Run the Add node...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2011 at 7:56 am
Viewing 15 posts - 6,376 through 6,390 (of 9,241 total)