Viewing 15 posts - 8,506 through 8,520 (of 9,253 total)
regular log backups would stop the transaction log getting huge if in full recovery mode. They also provide point in time restore capability. If all you need is a backup...
January 22, 2009 at 6:07 am
regular log backups would stop the transaction log getting huge if in full recovery mode. They also provide point in time restore capability. If all you need is a backup...
January 22, 2009 at 6:07 am
you cannot shrink past the active portion of the log. if the log has an active portion near the end of the file it will not shrink beyond that no...
January 21, 2009 at 3:39 pm
george sibbald (1/21/2009)
January 21, 2009 at 1:44 pm
Colin, i have never encountered changing the max degree of parallelism either.
george sibbald (1/21/2009)
January 21, 2009 at 10:44 am
we use SQL2005 std edition! What version ArcGIS are you using?
January 20, 2009 at 5:19 pm
that would be the path i would recommend 😉
January 20, 2009 at 2:09 am
yeah i already checked with him. He wasnt trying to upgrade the SBS instances just one of the 2 new instances
January 19, 2009 at 3:28 pm
Matt, it would seem he has a mixture of sql2000 instances, 2 of the instances are the MSDE which SBS installs. The other 2 seem to be developer edition
January 19, 2009 at 2:35 pm
malcolmwatt (1/18/2009)
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) ...
January 19, 2009 at 10:07 am
how did you get on?
January 18, 2009 at 11:22 am
he was probably looking for something along the lines of
sql server stores data on disk in pages which are 8Kb in size. 8 pages make up one extent and these...
January 18, 2009 at 10:51 am
as well as the version get the following
select @@servername, serverproperty('servername')
January 18, 2009 at 10:45 am
it seems you have 2 instances referencing COW0, my guess is you upgraded the wrong one hence why you see the sql2000 version number. Are the 2 extra instances MSDE...
January 18, 2009 at 10:31 am
yes just seen the COW0 instance in the registry too. Scroll across to the right on the right hand pane, what are the installed instances?
what instance name are you typing...
January 18, 2009 at 10:28 am
Viewing 15 posts - 8,506 through 8,520 (of 9,253 total)