|
|
Posted by Mike Epprecht \(SQL MVP\) on 06/14/05 19:07
Naturally, that is when you use Enterprise Manager or use the built in T-SQL
backup command.
Never backup the LDF, NDF and MDF files directly using a backup software.
--
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message
news:42af0082_3@news.bluewin.ch...
> No.
>
> Backups are done online and normal operations can continue against it. You
> will only notice it is running when it slows your server down slightly due
> to the additional Disk IO.
>
> Regards
> --------------------------------
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
>
> IM: mike@epprecht.net
>
> MVP Program: http://www.microsoft.com/mvp
>
> Blog: http://www.msmvps.com/epprecht/
>
> "debian mojo" <debian_mojo@yahoo.com> wrote in message
> news:v2Dre.10$GU5.4871@news.uswest.net...
>> Hello Faculties,
>> Is it necessary to set a database to RESTRICTED USER before taking
>> backups?
>>
>>
>>
>> *** Sent via Developersdex http://www.developersdex.com ***
>
>
Navigation:
[Reply to this message]
|