Viewing 15 posts - 151 through 165 (of 188 total)
are you using a domain account?
June 9, 2006 at 1:49 pm
Thanks Brendt. Here is what I found
File containing information regarding any modifications that were made as part of incomplete transactions at the time the backup was performed. A...
June 9, 2006 at 1:20 pm
also if I disable AWE, does SQL Server needs to restarted?
June 9, 2006 at 12:07 pm
I believe SQL Profiler is your best bet. You can narrow down your criteria so that you are not tracing every single activity on the server.
June 9, 2006 at 12:06 pm
However if you truncate your log that would also decrease the size of your backup.
June 9, 2006 at 11:58 am
I am not sure whats your question. If you are wondering that log file is part of the backup, then answer is yes. if you shrink the size of log...
June 9, 2006 at 11:57 am
Scheduled jobs are executed under the same user under which SQLServerAgent service runs.
June 9, 2006 at 11:55 am
Well I am working with the same issue these days. We had a 4GB server however now its 8GB and enabling AWE.
I wont recommend /3GB switch in this case...
June 9, 2006 at 11:54 am
thanks. I am unable to find anything on microsoft site about this. Anyone else wanna take a shot at this?
June 9, 2006 at 11:48 am
in this case i dont have /3gb flag in boot.ini file. only /pae flag.
June 8, 2006 at 9:51 am
I think using SQL Profiler is probably lot better as I can setup my trace with a specific criteria. Works pretty well.
June 8, 2006 at 8:03 am
Lowell
I saw that on web before asking the question. I think I should have phrased my question better. Instead what I wanted to ask is that why SQL Server is...
June 8, 2006 at 6:45 am
is there a way to backout these changes and disable AWE so that SQL Server goes back to 2 GB memory limit and dynamic allocation?
June 6, 2006 at 10:08 am
Viewing 15 posts - 151 through 165 (of 188 total)