Alwayson availability groups failover monitoring - Part 1
There are a lot of ways to monitor AG, sql server errorlog, window event log, cluster log......, here I list...
2013-08-04
6,492 reads
There are a lot of ways to monitor AG, sql server errorlog, window event log, cluster log......, here I list...
2013-08-04
6,492 reads
Found a gap issue when using IDENTITY column in SQL Server 2012, every time I restarted sql server service, the current...
2013-07-23
3,736 reads
Sometimes you detach databases, or you delete a database which is in restoring status, the data and log file will...
2013-07-09
2,328 reads
1. 3004
show the internal backup/restore operation for every step.
ex.
dbcc traceon(3004,3605,-1)
GO
3605 means output the message to errorlog. you can use 3604...
2013-07-02
4,135 reads
4. Setup 2 nodes alwayson availability group
a) Enable alwayson on both 2 nodes
enable-sqlalwayson -Path "SQLSERVER:\SQL\SQL2012-01\DEFAULT"
enable-sqlalwayson -Path "SQLSERVER:\SQL\SQL2012-02\DEFAULT"
b) Restore...
2013-06-25
2,231 reads
3. Install SQL Instance
a) Configure the firewall setting on both 2 nodes.
echo Default Instance
netsh advfirewall firewall add rule name="SQLServer"...
2013-06-25
2,059 reads
Here are some scripts which can be used for setting up 2 nodes AlwaysOn Availability Groups, you can make your own...
2013-06-25
2,493 reads
I must share it, there are many useful resource
http://blogs.msdn.com/b/mssmallbiz/archive/2013/06/18/huge-collection-of-free-microsoft-ebooks-for-you-including-office-office-365-sharepoint-sql-server-system-center-visual-studio-web-development-windows-windows-azure-and-windows-server.aspx?Redirected=true
http://blogs.msdn.com/b/mssmallbiz/archive/2012/07/27/large-collection-of-free-microsoft-ebooks-for-you-including-sharepoint-visual-studio-windows-phone-windows-8-office-365-office-2010-sql-server-2012-azure-and-more.aspx
http://blogs.msdn.com/b/mssmallbiz/archive/2012/07/30/another-large-collection-of-free-microsoft-ebooks-and-resource-kits-for-you-including-sharepoint-2013-office-2013-office-365-duet-2-0-azure-cloud-windows-phone-lync-dynamics-crm-and-more.aspx
Thank you , Eric
2013-06-21
1,891 reads
when using table variable, please note table variable doesn't support transaction rollback. here is the words from BOL
Because table variables...
2013-06-20
2,647 reads
Say if you have a management server or a script repository server, sometimes users save/test/run their script from different path,...
2013-04-28
1,351 reads
By Brian Kelley
In information security (INFOSEC), there several foundational concepts and principles. One of the ones...
By Steve Jones
the standard blues– n. the dispiriting awareness that the twists and turns of your...
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
I'm tracing activity on one database and would like to include the client_app_name in...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I'm only processing 50,000 records not everything from the Table where there are 250,00...
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers