Create Test Database

Recovery model = FULL

Insert 1,000,000 rows into a table

Physical size
test.mdf   214,208 KB
test_log.ldf   579,008 KB

Database Logical Name File Name                                                                                                                                                       Size MB        Space Used MB Free Space MB
test            test                 C:\Program...

Very Confused!

Is it that it releases the log space but doesn't change the physical file size?  Confused

DBCC SHRINKFILE (Transact-SQL)

2012 both file types ??

Good question, there is a common misconception that this role has a much wider scope.

Had no idea about this one, but guessed correctly. Phew!

Yeah 0 is no backups, so it's more of a status than a back-up priority.

I wuz robbed

:0(

But 1 is the lowest priority, isn't it?

Must be too many mince pies, muddled my brain cell.

I got it wrong, because I read it as wanting the possible back up priorities, which start at 1 and go to 100.

I made the same interpretation

:o(

I agree I thought it was only to occur on the Secondary when it was running and not the primary.

Doh!

I had no idea about this one it took some research. :w00t: