 | |
Install Sql2005 Instance on Cluster
microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering
 |
| | Thread Tools | Display Modes |
#51
 
| |||
| |||
|
Re: Install Sql2005 Instance on Cluster -
10-10-2008
, 08:25 AM
|
Thanks a Bunch Geoff Also one more question, by snapshot u mean copy the files correct, i have not room to backup 4tb of database anywhere hence they want to do inplace or something like that.. "Geoff N. Hiten" <SQLCraftsman (AT) gmail (DOT) com> wrote in message news:ukLQlKoKJHA.3496 (AT) TK2MSFTNGP04 (DOT) phx.gbl... 1. Yes. 2. No. The failure rate for in-place upgrades is pretty high. This way you can build and configure the system before adding data. FYI, this technique is called data-in-place. -- Geoff N. Hiten Principal SQL Infrastructure Consultant Microsoft SQL Server MVP "Jason" <bornscorpio30 (AT) yahoo (DOT) com> wrote in message news:uEsT71nKJHA.4908 (AT) TK2MSFTNGP02 (DOT) phx.gbl... thanks Geoff So if i understand correctly 1>i cannot use the same group iwill have to request new ip /n/w name and disk. correct and i will have to install its own group. 2>basically what u are saying is once i upgrade the db to 2k5 threre is no going back, so then there is no point in installing a saperate instnce rather just do inplace upgrade? "Geoff N. Hiten" <SQLCraftsman (AT) gmail (DOT) com> wrote in message news:ui5M9tnKJHA.5448 (AT) TK2MSFTNGP05 (DOT) phx.gbl... 1. No. One instance per group. 2. You can move disks between groups. The data on the disks stays intact. I would create a new instance, synch the logins, Stop both instances, change the groups, fix the dependencies, start the new instance, and attach the databases. If you can, snapshot the data files before moving them to the new instance. Once you attach the data files to the new instance, you cannot put them back on the old one. -- Geoff N. Hiten Principal SQL Infrastructure Consultant Microsoft SQL Server MVP "Jason" <bornscorpio30 (AT) yahoo (DOT) com> wrote in message news:O4pGRqnKJHA.5340 (AT) TK2MSFTNGP03 (DOT) phx.gbl... Hi All SQL Gurus Here is my scenerio I have a Win2003 SQL Server 2000 Cluster server. Now the plan is to upgrade to SQL2005 But they do not want to upgrade the existing instance. what the client wants to do is install another instance of SQL 2005 on the same virtual server. here is my problem. 1>Can i install named instance with different port # in the same cluster group. say group 1. or do i need another sql group with another ip, disk and n/w name. 2> if i move the disk between the groups. let us say i create another group for this new sql 2k5 instance called Group2005, and want to move the disk resources from original group Group2000 to new group2005, will the data on the group be deleted.? Because the size of the database is 5 TB, backup and restore is not an option., so i was thinking of installing sql 2005 as another instance and just attach the databases.. Will this work.. thx |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.