ports for what

SQL Server

DNS

NetBIOS?????

tnpich (10/7/2015)

---

This still includes some non-user created objects, like the below. See the attachment for details.

fn_diagramobjects

sp_alterdiagram

sp_creatediagram

How can I get rid of these type of objects without filtering on SAO.name...

kiril.lazarov.77 (10/6/2015)

---

Thanks for your response. What do you mean by "computer account"? Do I have to create a new domain account on the Secondary and assign folder permissions on the...

Yes that is correct

humbar-a (10/7/2015)

---

However i'm nearly sure that i've seen before...

gingerdazza (10/6/2015)

---

Just wondered what people's thoughts and experiences are of deploying a 2 node SQL AAG, with one VM each DC, in sync mode, in an active-active DC layout, with...

That cannot be considered a true disaster recovery datacentre, 500 miles would be more preferable

You'll first need to apply service...

DNS settings are first to check,...

have you consulted your network admins?

the t-log file is the problem, the error clearly states this!

Please post results of the following;

PowerShell query

Get-Volume | ?{$_.drivetype -EQ "Fixed"} | ft DriveLetter,FileSystemLabel,HealthStatus,SizeRemaining,Size

TSQL query

SELECTname

, size / 128 AS SizeMBs

,...

I'm sorry its not clear what you're asking?

mahi123 (10/6/2015)

---

Hello experts,

Message

Executed as user: NT AUTHORITY\SYSTEM. The transaction log for database 'tempdb' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column...

Yes,...

You'll need to add the computer account to the share and ntfs permissions lists

Firstly, read my stairway to Alwayson starting at this link

http://www.sqlservercentral.com/articles/Failover+Clustered+Instance+(FCI)/107536/[/url]

SQL Galaxy (10/5/2015)

---

Node 1 -IP Address 10.xx.xxx.11

Node 2 -IP Address 10.xx.xxx.12

while create cluster wizard in access Point for administering the cluster...