Redirecting Physical Database Files at Reboot

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Amy Boyd
    #1

    Redirecting Physical Database Files at Reboot

    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!
    Tags: None
    • Greg D. Moore \(Strider\)
      #2
      Re: Redirecting Physical Database Files at Reboot


      "Amy Boyd" <aboyd@nai.co m> wrote in message
      news:3f9827d6$0 $201$75868355@n ews.frii.net...[color=blue]
      > 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.[/color]

      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?"
      [color=blue]
      >
      > 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![/color]


        Comment

        Previous template Next
        Working...