November 15, 2011 at 9:40 am
Can this be done without breaking the cluster? I need to do some maintenance that can't be done directly on production. My idea is to do it on the clustered server and then move the data files over to production.
November 15, 2011 at 9:55 am
Please elaborate.
November 15, 2011 at 9:59 am
Alan Naylor (11/15/2011)
Can this be done without breaking the cluster? I need to do some maintenance that can't be done directly on production. My idea is to do it on the clustered server and then move the data files over to production.
Clusterd Index & SQL Server Failover Clusters are two DIFFERENT things.
November 15, 2011 at 10:01 am
I want to drop and recreate indexes and partition some tables on the clustered server.
November 15, 2011 at 10:02 am
Getting Started with SQL Server 2008 Failover Clustering
http://msdn.microsoft.com/en-us/library/ms189134(v=SQL.100).aspx
Clustered Index Structures
November 15, 2011 at 10:04 am
Alan Naylor (11/15/2011)
I want to drop and recreate indexes and partition some tables on the clustered server.
CREATE [ UNIQUE ] [ CLUSTERED | NONCLUSTERED ] INDEX index_name
ON <object> ( column [ ASC | DESC ] [ ,...n ] )
[ INCLUDE ( column_name [ ,...n ] ) ]
[ WHERE <filter_predicate> ]
[ WITH ( <relational_index_option> [ ,...n ] ) ]
[ ON { partition_scheme_name ( column_name )
| filegroup_name
| default
}
]
[ FILESTREAM_ON { filestream_filegroup_name | partition_scheme_name | "NULL" } ]
[ ; ]
It's independent of regular / cluster server.
November 17, 2011 at 10:14 am
Having the servers clustered should not make a difference to your indexes.
Unless they are partitioned out and you start moving physical files around.
Though your first post is kind of confusing. It sounds like your dev server is on a cluster and your production server is not?
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply