Friday, September 14, 2012

Screencast sobre Continuidad del Negocio en SQL Azure

Les comparto este screencast sobre opciones de continuidad del negocio en SQL Azure http://www.youtube.com/watch?v=5ADs0ISbZ1w&feature=youtu.be

image

 

Saludos,

 

Ing. Eduardo Castro

Microsoft SQL Server MVP

Wednesday, September 12, 2012

Scripts para instalar SQL Server 2012 en Windows Server Core

Les comparto los comandos para instalar SQL Server 2012 en Windows Server Core 2012.




sconfig

tzutil /l
tzutil /s "Central America Standard Time"

netsh interface ip show config
netsh interface set interface name="Ethernet" newname="LAN"
netsh interface ip set address "LAN" static 192.168.210.9 255.255.255.0 192.168.200.200 1
netsh interface ip set dnsservers "LAN" static 192.168.210.200

hostname
netdom renamecomputer %COMPUTERNAME% /newname:CONTOSOCORE02
shutdown /r

netdom join CONTOSOCORE02 /domain:CONTOSO.local /userD:administrator /passwordD:P@ssw0rd
shutdown /r

--enable Remote Desktop

cscript C:\Windows\System32\Scregedit.wsf /ar 0
netsh advfirewall firewall set rule group="Remote Administration" new enable=Yes

-- remote shell
WinRM quickconfig

-- Add the .NET Framework 2.0 and 3.5
dism /online /enable-feature /all /featurename:NetFX3 /source:D:\sources\sxs
DISM.exe /online /enable-feature /featurename:MicrosoftWindowsPowerShell



-- insertar disco SQL Server Core
d:\setup.exe

setup.exe /UIMODE=EnableUIonServerCore


Setup.exe /QS /ACTION=Install /FEATURES=SQLENGINE,REPLICATION,CONN,IS /INSTANCENAME=MSSQLSERVER /SQLSVCACCOUNT=CONTOSO\SQLServer /SQLSVCPASSWORD=P@ssw0rd /SQLSYSADMINACCOUNTS=CONTOSO\Administrator /AGTSVCACCOUNT=CONTOSO\SQLServer /AGTSVCPASSWORD=P@ssw0rd /TCPENABLED=1 /IACCEPTSQLSERVERLICENSETERMS=1 /UPDATEENABLED=False

netsh firewall set portopening TCP 1433 "SQLServer"







SQL Server 2016 Stretch Databases

El SQL Server Stretch Database permite que los datos históricos o de bitácoras puedan ser movidos hacia Azure, específicamente permite mover...