Viewing 15 posts - 1,651 through 1,665 (of 4,745 total)
amitwadhawan (7/6/2011)
July 6, 2011 at 10:17 am
support for locked pages in memory was supplied in a later CU
for background see
July 6, 2011 at 6:54 am
have you given the SQL service account the 'lock pages in memory' right?
July 5, 2011 at 2:56 pm
you would have to rename the server, which as you say is not a seamless process to do properly. It also means before you start mirroring back the other way...
July 5, 2011 at 2:54 pm
glad to help.
July 1, 2011 at 3:40 pm
wrong thread lowell!
:w00t:
July 1, 2011 at 2:37 pm
the file sizes the backup is trying to restore add up to 438GB.
the files of the source database would need to be shrunk before taking the backup.
This is something you...
June 30, 2011 at 7:19 am
GilaMonster (6/30/2011)
Yup, but currently it doesn't, nor does the page splits/sec, nor does the extended event.
well at least I learnt today there are 3 ways to get information that doesn't...
June 30, 2011 at 6:44 am
GilaMonster (6/30/2011)
george sibbald (6/30/2011)
so is the term page-split a misnomer? Is it in fact including new page allocations not caused by a page split?
Page split = allocation of a...
June 30, 2011 at 6:36 am
I posted a reference to dmv sys.dm_db_index_operational_stats previously (did anyone see that?) this dmv contains a column leaf_allocation_count which has a description of 'For an index, a page allocation corresponds...
June 30, 2011 at 4:26 am
planned would be a DR test, so you can prepare for it and therefore fail over in a controlled manner (you don't want to risk data in a test)
Unplanned is...
June 28, 2011 at 8:37 am
I read it as the backup was too big to fit on a DVD, rather than data files out of space on disk.
June 27, 2011 at 4:57 pm
how about good old winzip, that can hardly be called a third party app.
If the database is not being reindexed, that might be enough to take the backup size back...
June 27, 2011 at 4:53 pm
Craig Farrell (6/27/2011)
george sibbald (6/27/2011)
Craig Farrell (6/27/2011)
george sibbald (6/27/2011)
June 27, 2011 at 4:33 pm
the thread won't die whilst the no. of characters in a 'tweet' is limited.
Or so I believe. I have never 'tweeted' myself and feel silly just using the word.
Being...
June 27, 2011 at 4:08 pm
Viewing 15 posts - 1,651 through 1,665 (of 4,745 total)