| Mike Epprecht \(SQL MVP\) 2005-12-27, 8:23 pm |
| Hi
Taking them offline, and also at OS disk level, taking the Volumes
offline/dismounting them. Don't forget, there is an OS file system that is
around, and screwing that up will not enable you to access your data.
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/
"Terri" <terri@cybernets.com> wrote in message
news:dos0q4$2np$1@re
ader2.nmix.net...
>I have a SQL Server 2000 server where some of the databases have data and
> transaction files on local drives and some have data and transaction files
> on a SAN. Maintenance is going to be performed on the SAN. I'd like to
> maintain access to my databases whose data and log files are on local
> drives.
>
> What is the best practice for making sure the databases with files on the
> SAN are closed down correctly? Is this as simple as setting the database
> offline.
>
> Thanks
>
>
|