Viewing 15 posts - 3,916 through 3,930 (of 9,241 total)
It's the Database!!! (10/18/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2013 at 6:56 am
what you're seeing there is just the AlwaysOn listener resource. In the same group\application you should have a Virtual IP and networkname, this network name will be registered in AD...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2013 at 6:54 am
changing the VNN is fairly easy, just edit the VNN resource in failover cluster manager. Once renamed take the resource offline which will take the instance offline too. Restart the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2013 at 5:29 am
logicinside22 (10/17/2013)
Looking for Steps to perfrom for shrinking Data and log files for Mirrored Database. Can any one give insturction step by step . would...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2013 at 5:22 am
The reason for this is because of what happens when a failover of a virtual name resource occurs under Windows Server Failover clusters.
The virtual network name is unregistered in DNS...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2013 at 5:17 am
Dont bother with SQL agent or anything else, just use the following all within the same session
[Code="sql"]USE (mydatabase)
GO
ALTER DATABASE (mydatabase)
SET SINGLE_USER with rollback immediate;
GO
ALTER DATABASE (mydatabase) SET CONTAINMENT = NONE
GO
ALTER...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 17, 2013 at 3:56 pm
You should run the sp_configure last not first.
If you want to disable containment at the instance level then for each database that has containment enabled do the following
alter database...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 17, 2013 at 7:34 am
I prefer this
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 * 8...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 16, 2013 at 7:57 am
mssqlsrv (10/16/2013)
3. Transfer data from datafile 'A' to specific data file in other file group.
data is only transferred between files in the same filegroup using the emptyfile parameter
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 16, 2013 at 7:34 am
when configuring the secondary and you specify the primary server\instance specify the dedicated NIC IP
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 16, 2013 at 7:33 am
george sibbald (10/16/2013)
Perry, can you confirm my post is visible please?🙂
Ananda, if it is, see my post
your post is visible :hehe:
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 16, 2013 at 4:36 am
Calling the index physical stats dmv in a cursor could have serious ramifications on a large database, you should bear this in mind.
Query sys.partitions and sys.allocation_units for details of index...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 15, 2013 at 3:54 pm
Ted Zatopek (10/15/2013)
we could be operating at the DR site for an extended period of time.
Rare, but possible i suppose. Failover to DR should be considered a short term...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 15, 2013 at 3:25 pm
Ted Zatopek (10/15/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 15, 2013 at 12:44 pm
Ted Zatopek (10/15/2013)
It sounds like what I could do then is have one geographically "stretched" cluster that includes all 4 nodes.
Correct, that's what i said above 😉
Ted Zatopek...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 15, 2013 at 9:20 am
Viewing 15 posts - 3,916 through 3,930 (of 9,241 total)