Restore SYSTEM databases to a named instance???



Does anyone know if it's possible to restore SYSTEM databases from a default
instance of SQL 2000 Enterprise to a named instance? If so, can you tell me
what the restore script would look like for the master db?

Thanks


.



Relevant Pages

  • sql browser and named instance connection issue
    ... Checking file permisisons on:\Program Files\Microsoft SQL ... Restart SQLBrowser and then your named instance. ... The suggestions in the blog post include setting the Port property in SSAS ...
    (microsoft.public.sqlserver.olap)
  • login fails when connecting to named instance from different subnet
    ... I have a default instance and a named instance of SQL ... Server 2000 on the same PC running NT server. ... the "Test Connection" button is able to connect ...
    (microsoft.public.sqlserver.security)
  • Cant connect to named instance across subnets
    ... I have a default instance and a named instance of SQL ... Server 2000 on the same PC running NT server. ... the "Test Connection" button is able to connect ...
    (microsoft.public.sqlserver.security)
  • Re: AUTHENTICATION TO APPLY SP3
    ... Did you try starting the SQL Server in single user mode? ... > cannot get past the validation portion of the SP3 ... >>> it from default to my named instance. ... >>>>If you're getting an error message about setup being ...
    (microsoft.public.sqlserver.security)
  • RE: Query output is always in UNICODE... need ANSI ... Help?
    ... This is a server level configuration. ... > UNICODE and the application that subsequently consumes the attachment ... Is there a way to tell SQL Server to output its results with ANSI ...
    (microsoft.public.sqlserver.programming)