Viewing 15 posts - 8,191 through 8,205 (of 9,253 total)
try manually installing the SQL native client and .NET 2 framework first
August 21, 2009 at 1:48 pm
yeah, in my experience McAfee software has some nasty memory leak issues. Get your AV version and go to the McAfee site and check for any fixes. Also stop the...
August 21, 2009 at 11:40 am
Krav
seriously, if you are not comfortable moving files at the OS level you should leave well alone and seek extra help first. Beware also, that whatever path and filename you...
August 21, 2009 at 11:37 am
what antivirus software do you have installed?
August 20, 2009 at 4:06 pm
do you have any info about the machine the client is installed on?
August 20, 2009 at 3:08 pm
antivirus client installed scanning the SQL server folders by any chance?
August 20, 2009 at 3:04 pm
the Technet article is incorrect (it wouldnt be the first time would it 😉 )
see the following Microsoft KB
http://support.microsoft.com/kb/918483
i always use lock pages on 64 bit systems, its even more...
August 20, 2009 at 3:02 pm
i would set the lock pages in memory policy for the sql server service accounts and configure the min and max memory setting values
August 20, 2009 at 2:44 pm
on 64 bit sql server systems you only need to apply the lock pages in memory policy to the sql server service account, dont touch the AWE check box it...
August 20, 2009 at 2:39 pm
Krasavita
use the following to generate a modify file command for each database
declare @sql nvarchar(max)
set @sql = ''
select 'alter database [' +db.name + '] modify file (name = ' + al.name...
August 20, 2009 at 2:31 pm
i remember playing around with this before, being nosey. If you stack multiple IP's on the NIC and in SQL Server config manager you basically stop each instance from listening...
August 18, 2009 at 12:08 pm
these are separate domains in separate forests is that correct?
also clarify the group scopes you have used.
August 17, 2009 at 3:52 pm
just pick the files up and move them with the master.mdf
July 22, 2009 at 9:27 am
are you using any replication?
July 21, 2009 at 10:22 am
always keep dist and resource database in the same location as master.mdf
July 21, 2009 at 4:57 am
Viewing 15 posts - 8,191 through 8,205 (of 9,253 total)