Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Restore Master, msdb to new Server
Message
 
To
15/09/2006 13:11:15
General information
Forum:
Microsoft SQL Server
Category:
Recovery
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01154206
Message ID:
01154337
Views:
14
>Scenario: A given SQL server has all data and log files on an external disc array (including master and msdb data and log files). The server fails. A new server is stood up, and the external array is connected to it. How is SQL installed to point to the existing master and msdb files??
>
>What are the disadvantages of setting it up this way?
>
>Could / Should SQLs other internal files be installed on the external array as well (i.e. none of SQL on the C drive but all external)??
>
>All help is greatly appreciated.


Why you need to mess with system files? Can't you just copy your DBs and then attach them to new instance?
I am pretty sure that SQL Server can not access DataBases which not reside on the same computer where it is installed, and I think this is right, because somethimes external drives can't be accessible (networks fails, other computer is not turned on etc.).
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform