Viewing 15 posts - 4,681 through 4,695 (of 9,244 total)
How are the disks presented to the OS, (iscsi, fibre channel, local raid,etc)?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 2, 2012 at 12:47 pm
Furthermore, the script targets files with ".ldf" extension. What happens if a DBA creates a database and gives one of the data files on a database the ".ldf" extension 😉
At...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 2, 2012 at 12:13 pm
OK, you're joking right??
Firstly, TRUNCATEONLY does not apply to T-log files!
A wholesale shrink of all log files on the instance, and you believe this will be beneficial?
What do you do...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 2, 2012 at 12:06 pm
runal_jagtap (11/1/2012)
thank you everyone for quick response n help 🙂
I will like to add one more thing
We have one Rack Space server & other...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 1, 2012 at 4:18 am
runal_jagtap (11/1/2012)
coz if DB wont start how to check Error logs then??
More over coming...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 1, 2012 at 3:47 am
can you supply the results of this query please against primary and secondaries
selectar.replica_server_name
, ar.endpoint_url
, ar.replica_server_name
, ar.availability_mode_desc
, ar.failover_mode_desc
, ar.session_timeout
, ar.primary_role_allow_connections_desc
, ar.secondary_role_allow_connections_desc
, ar.backup_priority
, ar2.read_only_routing_url
from sys.availability_replicas ar
inner join sys.availability_read_only_routing_lists avr
on ar.replica_id =...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 31, 2012 at 9:21 am
you're welcome 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 31, 2012 at 8:37 am
check your event logs for more info, there'll be some errors there that will be relative.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 31, 2012 at 4:52 am
normally stopping and restarting the endpoints will cure the issue
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 31, 2012 at 4:19 am
SQLSACT (10/31/2012)
Perry Whittle (10/31/2012)
SQLSACT (10/31/2012)
Please help me understand something the Cluster Quorum and specifically Node and Disk Majority
I understand that if you have an even amount on nodes on...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 31, 2012 at 4:09 am
scogeb (10/30/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 31, 2012 at 2:51 am
SQLSACT (10/31/2012)
Please help me understand something the Cluster Quorum and specifically Node and Disk Majority
I understand that if you have an even amount on nodes on your cluster, it's...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 31, 2012 at 2:47 am
raheelr 63130 (10/29/2012)
I think sql 2012 provides redundancy at DB level as well?
SQL Server 2012 also supports database mirroring although this feature is now deprecated and marked for removal in...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 31, 2012 at 2:40 am
you asked why you were getting the error, i told you 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 29, 2012 at 4:05 pm
check the windows application log for more detail
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 29, 2012 at 8:50 am
Viewing 15 posts - 4,681 through 4,695 (of 9,244 total)