Viewing 15 posts - 1,981 through 1,995 (of 4,745 total)
Did you get a resolution to this?
We have hit the same issue during an upgrade from SQL2000 to SQL2008 on xps used to extract data out of a foxpro database.
January 20, 2011 at 5:55 am
The results on this question will be VLF (Very Low Failure)
Keep 'em coming steve!
January 20, 2011 at 3:32 am
Perry,
maybe it is taken as read but it should be mentioned another drive would be needed to install SQL application files to (i.e. the instance root directory) and this would...
January 19, 2011 at 7:44 am
reuben.anderson (1/19/2011)
January 19, 2011 at 7:43 am
second what gail says, this issue is fixable in a few minutes, no need to cause yourself all that extra work
January 14, 2011 at 3:06 pm
see this on how to move system databases.
the data file should be tempdb.mdf, the log file should be templog.ldf, don't change the default file names on system databases, will come...
January 14, 2011 at 1:26 pm
there is the -m flag for the maximum no of errors before an import is aborted, is that what you want?
January 13, 2011 at 4:28 pm
backup and restore is the normal way.
plus after the restore:
set compatibility level to sql 2008 (level 10)
change database owner to match what it was before
run dbcc updateusage
run sp_updatestats (at least,...
January 13, 2011 at 4:21 pm
what makes you think its SQL, especially as a restart of SQL has no effect, but a server reboot does, that points to the OS or some other app to...
January 13, 2011 at 4:01 pm
Roy Ernest (1/13/2011)
george sibbald (1/12/2011)
If you see...
January 13, 2011 at 8:02 am
have you used sysmon to track memory usage by process? Use private bytes and working set counters for all instances under the process object.
If you see an instance slowly increasing...
January 12, 2011 at 2:31 pm
How much environment specific data is there? Could you script it out as updates and run it after a full restore over database B, or truncate and load the environmental...
January 12, 2011 at 2:18 pm
Steve Jones - SSC Editor (1/12/2011)
george sibbald (1/12/2011)
log created at:
less than 64MB - 4 VLFs
64MB and less than 1GB - 8 VLFs
1GB or greater...
January 12, 2011 at 8:45 am
from QOTD of 7th JAn
log created at:
less than 64MB - 4 VLFs
64MB and less than 1GB - 8 VLFs
1GB or greater - 16VLFs
January 12, 2011 at 7:21 am
Viewing 15 posts - 1,981 through 1,995 (of 4,745 total)