Viewing 15 posts - 6,706 through 6,720 (of 9,244 total)
jpSQLDude (8/30/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 30, 2011 at 8:48 am
a failover is entered into the sql server log on the principal. You could capture these events and act on them. Messages will be something along the lines of
The mirrored...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 30, 2011 at 7:56 am
okbangas (8/30/2011)
or you can try the iSCSI target in FreeNAS.
that's exactly what my guide uses 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 30, 2011 at 7:41 am
check the permissions, they should contain ACLs for the sql server service account.
If sql server cant open model it cant create tempdb and so, wont start!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 30, 2011 at 7:11 am
check the sql server log
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 30, 2011 at 7:10 am
matt.bowler (8/30/2011)
Those logins look like the domain accounts setup for running the various SQL Services (engine, agent & full text).
they're not acounts they're local groups and hence invalid when applied...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 30, 2011 at 7:04 am
so, verify the path and filename 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 30, 2011 at 7:03 am
have you checked the Windows application log
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 30, 2011 at 6:43 am
what version of ESX are you using?
I've not used Veem have you tried asking on their forum
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 30, 2011 at 5:59 am
Hi
use this and execute from a sql server agent job step 😎
Option Explicit
'Delete all SQL Server backup files more than 8 days old
Dim oFS, oSQLBackupFol, oFol, oFil
Set oFS =...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 30, 2011 at 5:55 am
check and correct your margins
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 30, 2011 at 5:50 am
the documentation for that revlogin script tells you to carefully examine the output before executing it. There are certain logins that you do not want to re create on the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 30, 2011 at 5:48 am
If you're clustering SQL Server then you need to cluster MSDTC. If the clustered SQL Server instance fails over and the local MSDTC is in use then after failover the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 30, 2011 at 5:44 am
jpSQLDude (8/29/2011)
Tape? You guys are funny!But seriously, most places I've worked do NOT take backups seriously.
you want your data on every media possible. I used to work for a software...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 29, 2011 at 12:03 pm
Can you post a screenshot of what you are trying to change?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 29, 2011 at 10:49 am
Viewing 15 posts - 6,706 through 6,720 (of 9,244 total)