-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
SQL Server 2014 CTP2(All new,shiny shiny !) availability was announced yesterday at #SQLPASS Summit. Native backup encryption is one of the key features which was announced with this release, and…
Care about RPO’s and RTO’s? Then you should be backing up your Windows Azure SQL Databases(Formerly SQLAzure). Windows Azure SQL Database is highly available and data is redundant(3 copies of…
Page level restore is not something new for us, however page restore via SSMS (GUI) is something new, and it’s a feature available for SQL Server 2012. Page level restores…
Partial database availability is an exiting feature,and I decided to write this blog post after observing many doubts related to this feature in forums. Lets assume a situation like mentioned…
Today I witnessed yet another user who was dealing with BACKUP LOG [database] WITH TRUNCATE_ONLY. This is one of the features which got discontinued from SQL Server 2008 and above,and this was…
Standby mode will leave the DB in restoring mode,writes are not allowed but user can connect and give select statements. restore database adventureworksLTfrom disk=’c:\backup\adventureworksLTfull.bak’with replace,standby =’c:\backup\adventureworksLT ful.stn’ With recovery mode…
Solution :When we restore the database system should have Exclusive lock. The error means that some process is using this database,we should kill those process which are using database, Otherwise…
Cloud & SQLSailor 