Viewing 15 posts - 1 through 15 (of 26 total)
I'm having the very same problem right now.
October 23, 2009 at 9:47 am
Also, I have replication running against this database. Do you see any reason why this should create any problems with online reindexing or make it take a lot longer?
September 1, 2009 at 8:32 am
It may be overkill but I'm also performing an update stats and an sp_recompile on every table that I'm rebuilding indexes on.
I'm just going to have to rebuild only indexes...
September 1, 2009 at 8:26 am
Also, bulk-logged recovery mode still allows for standard transactions from users to be backed up by the periodic trans log backups, correct? It only effects bulk type transactions such as...
August 31, 2009 at 2:22 pm
GilaMonster (8/31/2009)
wjones21 (8/31/2009)
August 31, 2009 at 2:12 pm
Richard M (8/31/2009)
wjones21 (8/31/2009)
My company is obviously concerned about the 10 hour+ exposure without a backup
We also change the T-Log backup to every 5 minutes so it doesn't grow to...
August 31, 2009 at 2:00 pm
My company is obviously concerned about the 10 hour+ exposure without a backup that an online reindexing process will lead to with the DB in SIMPLE recovery mode. The way...
August 31, 2009 at 1:46 pm
OK, I just want to ask my question a little more clearly and to the point:
I have a 500 GB DB. It needs to be reindexed. I want to use...
August 31, 2009 at 1:17 pm
No, not really any I/O bottlenecks.
So, it's perfectly OK to eventually have a 1 TB single data file?
October 13, 2008 at 9:06 am
The whole thing is on a SAN System
System DBs are on their own LUN with dedicated disks
TempDB is on it's own LUN with dedicated w/ 8 files
Log Files are on...
October 13, 2008 at 8:44 am
To answer the first question, the vendor will not allow me to move individual objects across the new files, and yes, those secondary data files would be on the same...
October 13, 2008 at 8:31 am
Can you give me information on performing an Empty File/Shrink File on the existing primary data file in order for it to move those objects equally into the new secondary...
October 13, 2008 at 7:23 am
So, the secondary data files don't necessarily need to be created the same size (i.e. TEMPDB) because it's not going to write to them evenly anyway because they will have...
October 8, 2008 at 8:12 am
That's what I sadly figured. Thank you for your reply.
If anyone else has done anything different, please let me know!
Scarab
October 8, 2008 at 7:35 am
Good info! Thanks!
June 11, 2008 at 7:22 am
Viewing 15 posts - 1 through 15 (of 26 total)