No announcements
Found 1313609 threads
-
0 VotesMoving partitioned file to another drive
Otherwise, I suggest backing up the current database and restore it to another database with moving the database files to correct location.Answered | 2 Replies | 2170 Views | Created by dsagar - Tuesday, October 9, 2012 7:50 PM | Last reply by Allen Li - MSFT - Wednesday, October 10, 2012 7:59 AM
-
0 Votes
mispelled partition filegroup when addindg next used
It looks like partition #9 (the 2014 boundary) is correctly mapped to the fgrp_Scanner_Mensual_2014 filegroup as desired.Answered | 3 Replies | 399 Views | Created by Gilberto H_ - Wednesday, December 4, 2013 10:25 PM | Last reply by Dan Guzman - Friday, December 6, 2013 3:47 AM -
1 Votes
Filegroups
Primary The primary filegroup contains the primary data file and any other files not specifically assigned to another filegroup.Answered | 2 Replies | 5089 Views | Created by Tarcísio Corte - Thursday, January 28, 2010 1:40 PM | Last reply by Lekss - Thursday, January 28, 2010 5:04 PM -
2 Votes
FileGroup And Files
Hey Jaypee Raju replied to you in a really good, I would just add another important point you should know.Answered | 6 Replies | 302 Views | Created by Jayaprakash S - Wednesday, July 2, 2014 9:41 AM | Last reply by Jayaprakash S - Monday, July 7, 2014 10:46 AM -
0 Votes
how to migrate certain filegroups with partitions to another server
Hi guys, I have 3 partition tables on multiple file groups on monthly basis., each month it generates about 1-2TB data on one partition, one ... -
0 Votes
Move or Restore a Filegroup to a different database
I'm sure the SQL Server team could figure out a method of doing it, but it's probably easier to create a seperate database instead of a filegroup.Answered | 4 Replies | 6374 Views | Created by Sams007 - Thursday, January 29, 2009 11:34 PM | Last reply by Jim McLeod - Tuesday, November 17, 2009 11:13 PM -
1 Votes
transfer indexes to another filegroup
http://msdn.microsoft.com/en-us/library/ms175905(SQL.90).aspx This article does discuss how to ...Answered | 1 Replies | 4645 Views | Created by Prakash Nandwana - Monday, September 15, 2008 12:05 PM | Last reply by Jay Bonk - Monday, September 15, 2008 5:56 PM -
0 Votes
Partition Question
How about i create 18 file groups and contain same months of each table in each file group and thus each file?Answered | 4 Replies | 4189 Views | Created by SQLUser1979 - Friday, July 30, 2010 2:05 PM | Last reply by Erland Sommarskog - Saturday, July 31, 2010 8:38 PM -
0 Votes
Filegroup
Hi, There are two how to topics on these items.Answered | 2 Replies | 355 Views | Created by Surya.chamala - Monday, December 2, 2013 4:11 PM | Last reply by Shanky_621 - Monday, December 2, 2013 6:50 PM -
0 Votes
Migrate database to new server retaining data folder structure and filegroups?
Or I could say that your question about Migration database and retaining the filegroups are a little strange to me.Answered | 4 Replies | 2109 Views | Created by BGSisson - Sunday, July 8, 2012 12:18 AM | Last reply by BGSisson - Sunday, July 8, 2012 12:19 PM -
1 Votes
partitioning
I just want to add that because the partition function is using RANGE LEFT, when you eliminate a partition using MERGE then the partition rows will be moved to the right.Answered | 8 Replies | 2133 Views | Created by sqlenth - Friday, November 4, 2011 9:40 PM | Last reply by sqlenth - Tuesday, November 8, 2011 6:50 PM -
1 Votes
T- SQl script to allocate certain tables to a new filegroup in SQL server 2012
Hi, I have the table and clusterIndex on that table .I need to move it to newly created secondary filegroupAnswered | 7 Replies | 780 Views | Created by BomaSri - Tuesday, September 3, 2013 1:59 PM | Last reply by Tom Phillips - Tuesday, September 3, 2013 9:58 PM -
0 Votes
Indices on Partitioned Tables
So, I can create another partition scheme on the same partiton range and use one for data and other for indices.Answered | 6 Replies | 4991 Views | Created by ChiranSQL - Monday, May 9, 2011 4:11 PM | Last reply by ChiranSQL - Tuesday, May 10, 2011 3:04 PM -
0 Votes
Sql Server Database Partition (SQL Server 2008r2)
With mirroring you must ensure the same file paths exist for the filegroup on the mirror side.Answered | 1 Replies | 865 Views | Created by MEPSS - Tuesday, August 13, 2013 4:56 PM | Last reply by Hilary Cotter - Tuesday, August 13, 2013 5:44 PM -
1 Votes
Question on Table Partitioning
You can backup files and filegroups individually: http://msdn.microsoft.com/en-us/library/ms189906.aspx http://msdn.microsoft.com/en-us/library/ms179401.aspx Since ...Answered | 4 Replies | 4496 Views | Created by Dave Herrmann - Friday, November 20, 2009 5:32 PM | Last reply by Ewan - Tuesday, November 24, 2009 8:50 AM -
0 Votes
partition scheme
hi Before you creating partition function and partition Scheme, must have Separate file group .Answered | 4 Replies | 1365 Views | Created by sudhanshu mishra - Sunday, June 23, 2013 7:32 AM | Last reply by Selvaons - Tuesday, June 25, 2013 4:13 AM -
1 Votes
How to recreate indexes on a different filegroup
Custered indexes should be on the data filegroup and non-clustered on another if you want to separate data and indexes.Answered | 7 Replies | 4912 Views | Created by ZychoFlow - Sunday, December 12, 2010 4:01 PM | Last reply by Dan Guzman - Tuesday, December 14, 2010 3:14 AM -
1 Votes
Partition table
Some how they don't agree to above approach, I end up writing following query.Answered | 8 Replies | 2752 Views | Created by Navind - Tuesday, May 8, 2012 8:42 AM | Last reply by S Kumar Dubey - Saturday, December 8, 2012 2:06 PM -
0 Votes
Table partitioning - How to add a partition value or boundary
first you have to create your new filegroup if needed for the new range.Answered | 1 Replies | 4902 Views | Created by dedbeat - Tuesday, November 17, 2009 8:40 PM | Last reply by Adam Haines - Tuesday, November 17, 2009 10:01 PM -
0 Votes
Partition
Posting such general questions is not likely to be a particularly useful way to gain good knowledge of any particular subject - perhaps you should consider some formal training or, at ...Answered | 4 Replies | 532 Views | Created by Surya.chamala - Monday, December 2, 2013 4:09 PM | Last reply by Geo223ff4889 - Friday, February 28, 2014 1:41 AM - Items 1 to 20 of 1313609 Next ›
No announcements
