Viewing 15 posts - 4,381 through 4,395 (of 4,745 total)
steve, thanks. we have a full blown change management system here (RMS) so all documented and approved.
george
June 3, 2008 at 9:12 am
Marios Philippopoulos (6/3/2008)
GilaMonster (6/3/2008)
george sibbald (6/3/2008)
so surely /3Gb switch ok up to 16GB RAM, remove for anything over that.:)
Nope. Even under 16GB you risk starving the kernal of memory.
Personally...
June 3, 2008 at 8:21 am
have you tried sp_helptext. with view definition rights should work
June 3, 2008 at 6:18 am
avipenina (6/3/2008)
so if i understand right if i have 32BIT system with 4GB box mem only enable the /3GB switch?
if i only enable the /3GB switch on 32BIT with 4GB...
June 3, 2008 at 4:33 am
GilaMonster (6/3/2008)
As soon as you enable /3GB, you're restricting the kernal to only 1 GB of memory. That's all it gets to run the core of...
June 3, 2008 at 1:24 am
visit the scripts site on this forum. There are lots of scripts to kill connections based on some criteria such as dbid. amend one of them to suit your needs....
June 1, 2008 at 2:53 pm
If you only have 4GB of memory installed in your server do not enable AWE. AWE is for memory above 4GB. Leave as is with the /3GB switch enabled.
June 1, 2008 at 2:44 pm
I've remembered what happened the last time I hit this error.
the server had been taken out and back into the domain but not cleanly, leaving a rogue entry for the...
June 1, 2008 at 2:38 pm
the enclosed article should help:
http://support.microsoft.com/kb/811889
I am struggling to remember the details but I have had this problem before and it was linked to the server having dropped out of the...
June 1, 2008 at 2:16 pm
your new setup is better.
autoshrink is best left off because the constant growing and shrinking wastes resources and fragments the physical file.
If the tran log is in simple mode set...
June 1, 2008 at 11:23 am
......and if doing this type of process good to do a backup just before just in case..............:)
June 1, 2008 at 5:46 am
will it start in default mode - sqlservr.exe -f -s ?
if so follow http://www.tek-tips.com/viewthread.cfm?qid=798602
else do you by any chance have a copy of the original master .mdf and...
June 1, 2008 at 5:26 am
a shrink of the log file can only shrink down to the last used virtual log file. Use command 'dbcc loginfo(dbname)' to find the last used (they have a status...
May 30, 2008 at 9:00 am
are the databases the same size, containing the same data, Stats up to date, database fragmented? Indexes missing, different? Network bandwidth the same? configuration values all the same? AV?
May 28, 2008 at 4:08 pm
Viewing 15 posts - 4,381 through 4,395 (of 4,745 total)