Restore Options?

When I restore a db do the options of the source db get restored also?
BarryYes, the db options will be restored too.
--
Stephen Jiang
Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
<barryfz@.home.com> wrote in message
news:#sOY3pOnEHA.1152@.TK2MSFTNGP11.phx.gbl...
> When I restore a db do the options of the source db get restored also?
> Barry
>|||Database Settings and Restoring
When using the RESTORE DATABASE statement, the restorable database options
(which are all the settable options of ALTER DATABASE except offline and the
merge publish, published, and subscribed replication options) are reset to
the settings in force at the time the BACKUP operation ended
See RESTORE in Transact-SQL Reference in BOL.
<barryfz@.home.com> wrote in message
news:%23sOY3pOnEHA.1152@.TK2MSFTNGP11.phx.gbl...
> When I restore a db do the options of the source db get restored also?
> Barry
>|||Generally yes, but restoring a database does not affect the settings of
the server.
Adrian
barryfz@.home.com wrote:
> When I restore a db do the options of the source db get restored also?
> Barry
>|||Thanks all for the feedback.
<barryfz@.home.com> wrote in message
news:%23sOY3pOnEHA.1152@.TK2MSFTNGP11.phx.gbl...
> When I restore a db do the options of the source db get restored also?
> Barry
>|||Hi,
Yes, ALL the database options set in source database will be copied to the
restored destination database.
Thanks
Hari
MCDBA
"barryfz@.home.com" wrote:
> When I restore a db do the options of the source db get restored also?
> Barry
>
>