Close

database

Deprecated Database Features: SQL 2005 – SQL 2014 Links

Below are reference links to Microsoft documentation web pages listing deprecated database features from SQL 2005 to SQL 2014….   2005   http://msdn.microsoft.com/en-us/library/ms143729(v=sql.90).aspx   2008   http://msdn.microsoft.com/en-us/library/ms143729(v=sql.100).aspx   2012  http://technet.microsoft.com/en-us/library/ms143729(v=sql.110).aspx 2014   http://msdn.microsoft.com/en-us/library/ms143729(v=sql.120).aspx  

Read More

Database Snapshot

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 […]

Read More