1. From Enterprise Manager, I can choose Read-only model (able to install another transaction log). How to execute same model restore by T-SQL? This script is used by Loading model:
RESTORE DATABASE MyNwind
MOVE 'MyNwind' TO 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\NewNwind.mdf',
MOVE 'MyNwindLog1' TO 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\NewNwind.ldf'
RESTORE LOG MyNwind
2. If a database is in Read-only Warm Stand-by because restore trans log files, how to turn of read-only model?