Sample T-SQL Code for creating a database snapshot. use AdventureWorks2012 go sp_helpfile — used to get the logical database name needed for below CREATE DATABASE AWSnapshot ON ( NAME = ‘AdventureWorks2012_Data’, FILENAME=’d:tlogAWSnapshot.ss’ ) AS SNAPSHOT OF AdventureWorks2012; –using it USE AWSnapshot; GO SELECT * FROM Sales.SalesOrderDetail WHERE ProductID = 53; –reverting from snapshot RESTORE DATABASE […]
Prefered long term solution for this suggested by Microsoft is using AlwaysOn High Availablilty. T-SQL Code for mirroring [note the port numbers have to be different. /****** Object: Endpoint [mirroring] on Server1 Script Date: 4/27/2014 3:32:37 AM ******/ CREATE ENDPOINT [mirroring] STATE=STARTED AS TCP (LISTENER_PORT = 7575, LISTENER_IP = ALL) FOR DATA_MIRRORING (ROLE = PARTNER, […]
Excellent training videos on Microsoft Big Data overview, implementation and infrastructure. Click here. Below is part 1.
Below shows a step by step install of Microsoft SQL Server 2014 which was releases on April 1st 2014. in pictures with some notes. Notes: For a server install, Microsoft recommends using separate domain accounts for each sql service. Below setup is the same for a server environment install, but works best for a developer […]
Click here for this very funny website detailing in an interesting way things database administrators deal with. 🙂