Hi all,

I notice that EM provides an option to leave a db read-only and able to restore additional logs during a restore. How would I accomplish this with T-SQL? I'm using:

restore database DBName from full_backup with norecovery

I didn't see a read-only attribute in BOL. I want to be able to write the results of each restore operation to a file as I restore the full backup and each individual transaction log.

Also, is there any option in EM for 'stopatmark' to stop the restore at a named transaction.

Seems like half of what I want is avaiable via EM GUI options and the other half requires script.

Thanks for the help.

Bob

I don't think you can do it from the RESTORE command. But, you can set the database READ_ONLY property with the ALTER DATABASE SET <optionspec> command. You can also use the system stored procedure sp_dboption, but its use is deprecated as of SQL Server 2000.

I'm not aware of any option in EM to handle named marks in the log.

Nothing's perfect :(

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

Thanks Jeff,

ALTER DATABASE <dbname> SET READ_ONLY WITH ROLLBACK IMMEDIATE

seems like a way to go. I'll give it a whirl.

Bob