Viewing 15 posts - 61 through 75 (of 275 total)
thanks for the suggestions.
the bcp terminator switches didn't seem to help. no matter what the bcp uses to terminate fields and rows, excel still craps out on the...
January 30, 2015 at 3:14 am
phil.doensen (1/15/2015)
I found doing in doing that, the shrink would compress pages putting them in...
January 16, 2015 at 12:54 am
GilaMonster (1/14/2015)
JarJar (1/14/2015)
January 14, 2015 at 5:48 am
normally yes, i personally wouldn't do it like this. but this is SAP and they have their own set of best practices that are obliged to follow. each datafile is...
January 14, 2015 at 3:45 am
sorry for the late reply. it was my turn to have the flu. :sick:
yes, all these files are part of the PRIMARY filegroup.
January 14, 2015 at 3:14 am
thanks! that explains the freespace discrepancy.
any ideas about the irregular dbfile sizes?
January 8, 2015 at 6:30 am
You should enable lock pages in memory for the SQL service account:
https://support.microsoft.com/kb/918483
But 2GB is pathetically low memory for a SQL server. Unless your db is tiny, bump that...
January 8, 2015 at 3:25 am
many thanks! i was about to go crazy with that. :hehe:
December 4, 2014 at 2:37 am
thanks. i need some sanity check here...
i failed over from my principal (SERVER1) to mirror (SERVER2), now the mirror is the principal.
On SERVER2, i ran the stored proc sp_add_log_shipping_primary_database and...
July 30, 2014 at 8:01 am
thanks. i found this shortly after my post, it won't help to speed it up but i an at least get sense of how much work the shrink...
March 31, 2014 at 5:38 am
GilaMonster (12/10/2013)
Have you considered bulk-logged recovery?
you are right this is probably the way to go. less filling, tastes great!
thanks for your advice. i really appreciate it.
December 10, 2013 at 6:59 am
GilaMonster (12/10/2013)
OLDCHAPPY (12/10/2013)
you go to the last good backup. in this case, before the shrink process. c'nest pas?
Correct, you go to the last good backup before the shrink, and...
December 10, 2013 at 6:25 am
GilaMonster (12/10/2013)
OLDCHAPPY (12/10/2013)
am i missing...
December 10, 2013 at 6:12 am
And what happens if the system crashes several hours after that process and the full backup taken after the broken log chain won't restore?
when you refer to the broken log...
December 10, 2013 at 5:11 am
Aham, It's OK. You're correct with ALTER INDEX.
i had just ran a single index rebuild in our dev environment to confirm it. it does retain the page compression option. big...
December 10, 2013 at 4:25 am
Viewing 15 posts - 61 through 75 (of 275 total)