| Author |
Topic |
|
kerrycorcoran
Starting Member
38 Posts |
 Posted - 2008-02-26 : 15:27:13
|
| Is it possible to change a 'Default' instance to a unique name?Am thinking I shouldn't have to re-install SQL 2005? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-26 : 15:31:53
|
| No. |
 |
|
|
kerrycorcoran
Starting Member
38 Posts |
Posted - 2008-02-26 : 15:39:58
|
| So the only way to change the instance name is to re-install SQL 2005? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-26 : 15:47:49
|
| You can setup alias name of Default instances to friendly name if you want. But you need to install second time for named instances |
|
|
|
kerrycorcoran
Starting Member
38 Posts |
Posted - 2008-02-26 : 16:05:39
|
| If I run (Maintenance Plan)a full backup of the data and log file.Reimage the server. Reinstall SQL 2005.Can I restore the database to a different named instance?Thanks for the help.Kerry |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-26 : 16:12:35
|
| What do you mean by reimage server? Yes you can. |
|
|
|
kerrycorcoran
Starting Member
38 Posts |
Posted - 2008-02-26 : 16:16:40
|
| I am loading a clean base server, Windows Server 2003R2.I will install SQL 2005, creating a unique instance name. I will restore the data to that instance name.Fingers crossed.Kerry |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-26 : 16:19:22
|
| why default doesn't work for you? i mean why you need different name. I think you can change server name to your requirement. Ask your hardware guys , they have more information regarding this? |
|
|
|
kerrycorcoran
Starting Member
38 Posts |
Posted - 2008-02-26 : 16:36:33
|
| I will need to change the Instance name as I am working with utilizing a Many-to-1 backup scenario. On my replication server there will be multiple instances of SQL installed to act as a replication dump for many individual databases. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-26 : 16:40:22
|
| 'I will need to change the Instance name as I am working with utilizing a Many-to-1 backup scenario.'I didn't get what you meant. What is the requirement? |
|
|
|
kerrycorcoran
Starting Member
38 Posts |
Posted - 2008-02-26 : 17:05:29
|
| I will have 4 physical SQL servers that will back up to a single SQL server.I am using Double-Take 5.0 as the replication (byte-level) service. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-26 : 21:42:11
|
| You can stop default instance and install 4 named instances. |
|
|
|
kerrycorcoran
Starting Member
38 Posts |
Posted - 2008-02-26 : 22:01:02
|
| I thought I read you can install up to 16 unique instances? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-26 : 22:26:23
|
| Yes, but does the server have enough horsepower? |
|
|
|
kerrycorcoran
Starting Member
38 Posts |
Posted - 2008-02-26 : 22:34:20
|
| That is not the point. Actually, that wasn't even my question. MY question was answered above if you read the thread.Thanks anyway.KerryPS - Yes, the server has the horse power, although I will not be adding 16 instance, only 4. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-26 : 22:44:16
|
| ??? |
|
|
|
|
Instances