Subscribe to this blog
SQLSailor.com
Archives: October 2012
PASS Summit 2012 Countdown Begins !!!
All roads lead to Seattle!
If you are a SQLServer professional, then you don’t want to miss this event.
Over 190 technical sessions, 2 days of pre-conf sessions with in-depth learning opportunities, networking with MVPs/Microsoft CSS/SQLCAT members! This is what PASS Summit is all about, and the great news is… Read more
3 comments, 352 reads
Posted in SQLSailor.com on 23 October 2012
Tale of detaching a database which was enabled for replication!
In development environments I prefer to use ‘detach’ database option to move around databases. It’s simple, fast and easy.
Almost all the time when I detached a database earlier the feeling was like something which I mentioned before “Simple, fast and easy”, however today it was more sort of a… Read more
0 comments, 416 reads
Posted in SQLSailor.com on 4 October 2012
Backing up the “log” of a database which is in Simple recovery model ! – Watch out for this!
In theory we cannot backup the log of a database which is in Simple recovery model, however there is a small bug in SQL 2012 which allows you to do this, and you need to be very careful about this.
Below is the detailed repro steps for this issue and… Read more
2 comments, 317 reads
Posted in SQLSailor.com on 1 October 2012