Viewing 15 posts - 8,191 through 8,205 (of 9,248 total)
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
reefshark (7/8/2009)
I kept getting an error. (why do I keep getting errors with everything I do?!?)
as Lynn says, you need to restore the database full backup with NORECOVERYas...
July 11, 2009 at 5:37 am
what about databases that have open connections what do you want to do about these
June 30, 2009 at 4:58 am
shiv (6/13/2009)
"Device error or device off-line"Restore db is terminating abnormally.
have you checked the tape drive
June 14, 2009 at 9:18 am
yes simon, the path you provide is relative to the server not your machine.
June 14, 2009 at 5:40 am
Viewing 15 posts - 8,191 through 8,205 (of 9,248 total)