Redirecting Physical Database Files at Reboot

[Amy Boyd]

Is there a method in SQL Server 2k to re-locate the physical database
files at the time the server reboots. Currently, the only way I know to
do this is by scripting some OS-level commands.

Thanks in advance for your help.

Amy Boyd
Database Administrator
Network Associates

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Greg D. Moore \(Strider\)]

"Amy Boyd" <ab***@nai.com> wrote in message
news:3f*********************@news.frii.net...

Is there a method in SQL Server 2k to re-locate the physical database
files at the time the server reboots. Currently, the only way I know to
do this is by scripting some OS-level commands.
Not that I can think of.

I mean you might have a task at start up (I forget exactly how to do this)
that does it, but my real question would be: "why?"

Thanks in advance for your help.

Amy Boyd
Database Administrator
Network Associates

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!