Viewing 15 posts - 3,916 through 3,930 (of 9,244 total)
Firstly, don't use administrative shares for file\folder access, create a new share at the appropriate folder level and ensure you set the following for the account the SQL Server agent...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 3, 2013 at 11:31 am
another user encountered this previously and the recommendation from Microsoft was the following (in order from highest to lowest priority)
Public
Private
iSCSI
Personally I have always used the following
Public
iSCSI
Private
The Public network is usually...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 3, 2013 at 11:28 am
the first item to tackle is why the network connection is lost. Also, the implementation of an extra network may help to maintain connectivity between sites.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 3, 2013 at 11:24 am
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
Viewing 15 posts - 3,916 through 3,930 (of 9,244 total)