Home » 2014 » September (Page 2)

Monthly Archives: September 2014

Creation & Deletion of Database Snapshot by SQL Agent Job

Some days back, I received one query on my facebook page that user want to create Database Snapshot frequently & want to delete the oldest with same frequency. Quite interesting scenario. I did not go in deep why he has such requirement but I am clear that It can be done very easily. So let’s … Continue reading

How to Start SQL Server in Single User Mode ?

Sometime, We caught in a situation where we need to run SQL server in single user mode. Issues like Master DB restore, Sysadmin locked out etc. Steps to start SQL Server in Single User Mode :- 1) Stop SQL Server Services 2) Add [-m] startup parameter in SQL Services from configuration manager Parameter [-m] Starts … Continue reading

%d bloggers like this: