Hi,
I have installed sql server on one of my box as a named installation and now
I want to change it to default one without re-installing sql server.
Please suggest how should I go for it. Also, whether it is possible or not.
Thanks in advance
Manu JaidkaHello,
You will have to install a default instance and copy the databases including
system databases over to default instance
using Backup and restore or detach and Attach.
Thanks
Hari
"manu" <manu@.discussions.microsoft.com> wrote in message
news:7A299083-671F-4457-B9CE-263AE17838C0@.microsoft.com...
> Hi,
> I have installed sql server on one of my box as a named installation and
> now
> I want to change it to default one without re-installing sql server.
> Please suggest how should I go for it. Also, whether it is possible or
> not.
> Thanks in advance
> Manu Jaidka
>
Showing posts with label nowi. Show all posts
Showing posts with label nowi. Show all posts
Tuesday, March 27, 2012
Default installation to named one
Default installation to named one
Hi,
I have installed sql server on one of my box as a named installation and now
I want to change it to default one without re-installing sql server.
Please suggest how should I go for it. Also, whether it is possible or not.
Thanks in advance
Manu Jaidka
Hello,
You will have to install a default instance and copy the databases including
system databases over to default instance
using Backup and restore or detach and Attach.
Thanks
Hari
"manu" <manu@.discussions.microsoft.com> wrote in message
news:7A299083-671F-4457-B9CE-263AE17838C0@.microsoft.com...
> Hi,
> I have installed sql server on one of my box as a named installation and
> now
> I want to change it to default one without re-installing sql server.
> Please suggest how should I go for it. Also, whether it is possible or
> not.
> Thanks in advance
> Manu Jaidka
>
I have installed sql server on one of my box as a named installation and now
I want to change it to default one without re-installing sql server.
Please suggest how should I go for it. Also, whether it is possible or not.
Thanks in advance
Manu Jaidka
Hello,
You will have to install a default instance and copy the databases including
system databases over to default instance
using Backup and restore or detach and Attach.
Thanks
Hari
"manu" <manu@.discussions.microsoft.com> wrote in message
news:7A299083-671F-4457-B9CE-263AE17838C0@.microsoft.com...
> Hi,
> I have installed sql server on one of my box as a named installation and
> now
> I want to change it to default one without re-installing sql server.
> Please suggest how should I go for it. Also, whether it is possible or
> not.
> Thanks in advance
> Manu Jaidka
>
Subscribe to:
Posts (Atom)