Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Restore Master, msdb to new Server
Message
From
18/09/2006 06:55:45
 
General information
Forum:
Microsoft SQL Server
Category:
Recovery
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01154206
Message ID:
01154591
Views:
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.).

Actually, consider the active-active clustered servers with an external disc array. Each server in the cluster uses the discs in the external array. The databases do not reside on the server itself. SQL does do this, and in large environments it is more dependable. SANs (storage area networks) can be 99.999% up. The concern is being ready if one of the motherboards goes down etc.. Also, just copying the database(s) over does not copy the jobs or users permissions, etc.
Thank You

Rollin Burr

Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.
Previous
Reply
Map
View

Click here to load this message in the networking platform