Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Restore Master, msdb to new Server
Message
 
À
15/09/2006 13:11:15
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Recouvrement
Versions des environnements
SQL Server:
SQL Server 2000
Divers
Thread ID:
01154206
Message ID:
01154337
Vues:
15
>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform