Dan Guzman
3/9/2007 12:16:00 PM
It depends on the type of restore. A page, file or piecemeal restore is
online by default.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"prince" <prince@discussions.microsoft.com> wrote in message
news:A4D85337-02F5-4F86-9838-9275D23B93C1@microsoft.com...
> Hi,
> Is the restore of a database in SQL 2005 is online by default or is there
> any special procedure to make the restore of a database as online?
>
> thanks and regards
> prince
>