Gurus,
Can one rename the underlying physical file name of a SQL 2000 database?
I.E., bring the database offline, rename the physical file MDF and LDF name,
then safely bring the database back online again?
--
SpinYou can detach, rename, then re-attach.
Do have a good backup just in case.
--
-oj
"Spin" <Spin@.spin.com> wrote in message
news:4go8juF1ok79lU1@.individual.net...
> Gurus,
> Can one rename the underlying physical file name of a SQL 2000 database?
> I.E., bring the database offline, rename the physical file MDF and LDF
> name, then safely bring the database back online again?
> --
> Spin
>
No comments:
Post a Comment