Viewing 15 posts - 4,246 through 4,260 (of 9,244 total)
use either
computername\instancename
computername, portnumber
IPaddress\instancename
IPaddress, portnumber
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 16, 2013 at 8:04 am
GilaMonster (3/15/2013)
MyDoggieJessie (3/15/2013)
so there's no difference between 2 files of 140GB and 4 files of 70GB, it's still 280GB total space.
To add to the above, remember that when adding multiple...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 16, 2013 at 8:01 am
The shared databases represent only the upper layer of the shared objects. At the base level, each cluster node that is part of the failover instance shares the virtual IP,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 16, 2013 at 7:57 am
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
Viewing 15 posts - 4,246 through 4,260 (of 9,244 total)