var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Restore to read-only mode
EM has the following restore option:
"Leave database read-only and able to restore additional transaction logs."
Using this, I can restore to a named transaction, then run a SELECT statement that outputs the current state of my data to a file while the db is still in load mode.
What is the T-SQL version of this EM property, if it exists. I'm using:
restore log MyDatabase from MyDiskDevice with file=1, norecovery,
stopatmark = 'mymark'
I can't find a read-only attribute in BOL though to use with the RESTORE statement. Can I do this in script???
ALTER DATABASE <dbname> SET READ_ONLY WITH ROLLBACK IMMEDIATE
Thanks Brett. I'll give it a try.