Taking databases offline

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

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
>
>