Something related to Tail-Log Backup (just came across it)

MSSQL SP2

Link; http://support.microsoft.com/kb/2958429

KB 1184332

"If a tail log backup is performed against the model database, model database will freeze in restoring state...

😀 Definitely I am not one of them; even though I had my...

Thank you dave, for the post, very good one.

I just went with eliminating the odds method and then I was stuck with 2 and 4, I read the deprecated features...

Thank you Sean, for the post, interesting one.

+1 (had same thought)

twin.devil (7/21/2014)

---

The answer is Yes.

Nice and...

Thank you for the post, good one.

(even if one does not have the knowledge on the actual question it still can be answered by eliminating the odds if one...

raulggonzalez (7/18/2014)

---

twin.devil (7/18/2014)

---

Tail log backup WITH CONTINUE_AFTER_ERROR works only if the database goes offline in case during the start up of the database is fail to come online due to...

Thank you for the post, very interesting one.

I had an idea on 8k size but never had an idea that there will-be/can-be a change option or can be changed and...

SQLRNNR (7/16/2014)

---

Yea... as the CI is created at first and a table can have one...

Thank you sknox and Keon. I know this, it a classic method which I doing in my current project for few tables. Actually I was expecting more like NO PRIMARY...

Koen Verbeeck (7/16/2014)

---

how you mean? "already"

this simple statement creates a clustered index

CREATE TABLE TT1

(

ID INT PRIMARY KEY,

NAME VARCHAR(10)

);

pmadhavapeddi22 (7/15/2014)

---

This is my understanding. primary key is a constraint not an index, but it creates an index automatically by default, but primary key is called a constraint not an...

Thank you for the post, simply good one. (for me the question was simple enough)

thank you for the post, interesting one.

this is all due to the "negative" sign... remove that sign, all we get is 2, as the tinyint stores only 0 to 255...