Post reply

named instance

  • October 14, 2008 at 6:32 pm

    #199370

    how can I find if an instance was installed as named instance or local ?

    I initially installed an instance as local and then restored a database from remote site but I kept getting this error that online said happens when you import from named instance into a local instance.

    but some people think that the remote database who's backup I restored is installed as Local and not named,, how can I verify that ?? is there a sql command to do it ?

    thanks

  • October 15, 2008 at 2:38 am

    #885072

    First of all I'd like to say it shouldn't make any difference when restoring a database from another server if it's a from a named instance or a default instance. Only exception would be the master database.

    But for your request about how to find out the instance name use

    SELECT SERVERPROPERTY('InstanceName')

    If the result is 'NULL' it's a default instance.

    [font="Verdana"]Markus Bohse[/font]

  • October 19, 2008 at 3:45 pm

    #886936

    You can check the same from services.msc too..

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply