Viewing 15 posts - 4,666 through 4,680 (of 9,253 total)
What monitoring stats have you collected so far to supply to your SAN and infrastructure teams.
In between the SAN and the SQL Server you have all the other software\hardware components,...
November 7, 2012 at 4:28 am
chewychewy (11/7/2012)
For example only.
I have a daily full db backup via SQL maintenance plan to file system at 10pm.
I also have a daily direct backup of database via arcserve...
November 7, 2012 at 4:25 am
The Windows cluster name and the sql server virtual network name have to be separate unique values
November 7, 2012 at 4:21 am
arkiboys (11/6/2012)
We are also taking regular end of day backups.
Question:
Is it necessary to do backups since mirroring is in place or...
November 6, 2012 at 1:29 am
arkiboys (11/6/2012)
Can the ReportServerTempDB database be mirrored onto the DR server?Thanks
Why are you considering mirroring on these databases?
Use scale out deployments and clustered instances of SQL Server to provide HA...
November 6, 2012 at 1:27 am
What disk type are you using, what does Windows think the type is?
November 5, 2012 at 11:50 pm
consecutive pageids, you may want to run a storage health check too.
November 5, 2012 at 1:52 pm
jvkondapalli (11/5/2012)
We have APP1, APP2. When I create Windows Server Failover Cluster(WSFC) with 3 nodesnode 1 - Primary Replica - APP1 is connected with cluster name
The WSFC name is...
November 5, 2012 at 1:40 pm
OK, just tested it myself. If your mirror instances all run as the same service account leaving the boxes blank is fine, you won't see any GRANTs as the service...
November 5, 2012 at 1:21 pm
scogeb (11/5/2012)
That returns the user that was used to connect to the pincipal, mirror and witness when mirroring was set up using the wizard.
Yes, that's what I'm expecting 😉
Are...
November 5, 2012 at 8:22 am
CuriousDBA (11/4/2012)
I have created maintenance...
November 5, 2012 at 6:37 am
yes, from SQL Server 2012 mirroring is superseded by AlwaysOn
November 4, 2012 at 11:31 am
deebabat (11/4/2012)
I don't really know what information you want me to provide
This will do for starters
Whay...
November 4, 2012 at 9:51 am
Perry Whittle (11/4/2012)
Can you supply more detail about your mirror setup?
November 4, 2012 at 6:33 am
Can you supply more detail about your mirror setup?
Can you post details of this query run against the principal
Select name, user_access_desc, state_desc,
recovery_model_desc
from sys.databases
November 4, 2012 at 4:53 am
Viewing 15 posts - 4,666 through 4,680 (of 9,253 total)