Viewing 15 posts - 4,246 through 4,260 (of 9,241 total)
SQLCrazyCertified (3/15/2013)
GilaMonster (3/15/2013)
Check log_reuse_wait_desc in sys.databases for why...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 16, 2013 at 7:45 am
pradeep.mohan (3/15/2013)
I configured log shipping based on server host name in both production and DR server and its working fine. Now our company decided to change server IP's for both...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 16, 2013 at 7:42 am
why do you feel the need to backup to multiple files, do you have multiple backup devices?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 16, 2013 at 7:28 am
No problem, mine doesn't give object schema but that would be easy to obtain by joining to the sys.schemas catalog.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 14, 2013 at 12:50 pm
I prefer mine below
SELECTOBJECT_NAME(i.object_id) AS TableName
, ISNULL(i.name, 'HEAP') AS IndexName
, i.index_id as IndexID
, i.type_desc AS IndexType
, p.partition_number AS PartitionNo
, p.rows AS NumRows
, au.type_desc AS InType
, au.total_pages AS NumPages
, au.total_pages *...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 14, 2013 at 7:34 am
Is it a custom script, can you post details of what it does?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 12, 2013 at 4:20 am
Aside what Kevin has said, what size are the 12 x SAS drives?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 11, 2013 at 5:14 am
is there anything else that your backup does apart from backing up the database?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 11, 2013 at 5:08 am
muthyala_51 (3/9/2013)
One more doubt on the cluster setting? Do we have to go with the default node majority or node and disk majority as we will be adding the second...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 10, 2013 at 5:30 am
muthyala_51 (3/8/2013)
So we are planning to install the failover cluster on single node and add the other node when it's available. Will there be any issues ?
Apart from the fact...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 8, 2013 at 7:14 pm
BuntyBoy (3/5/2013)
you need to freeze the cluster to do this task
Only if using veritas cluster server, wsfc does not have a freeze action
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 6, 2013 at 8:10 am
sej2008 (3/4/2013)
endpoint allowed per instance then how can i use different port number for...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 4, 2013 at 6:32 am
If you're mirrirong between instances on the same server you cannot use the same port number, the port number must be different.
With regards to an endpoint it is instance wide...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 4, 2013 at 4:19 am
can you provide more info on the cluster disk setups please
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 4, 2013 at 4:15 am
You don't have to reboot there and then just defer it until you get the opportunity to reboot
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 1, 2013 at 4:05 pm
Viewing 15 posts - 4,246 through 4,260 (of 9,241 total)