If I didn't use table partitioning, and a disk went down, wouldn't the data in that data file just be unavailable -- can someone set me straight. thanks..What this feature actually relates to is using more than one filegroup.
In SQl Server 2000, if any filegroup went offline, the entire database was offline.
With SQL Server 2005, as long as the primary filegroup is online, you can still have access to the database. Obviously, you cannot access data in the filegroup which is offline, but you can access data in other, online filegroups.
没有评论:
发表评论