Viewing 12 posts - 1 through 12 (of 12 total)
Well, yes, It might have been some Anti-virus that runs in kernel mode and locks the files temporarily.
February 9, 2012 at 12:40 am
You can use Local System Account as Logon Account to start SQL Services
February 3, 2012 at 1:49 am
You can restrict SQL Server to use maximum amount of memory of a server by using sp_configure option.
Memory is allocated to the objects dynamically by the SQL Server therefore...
February 2, 2012 at 2:49 am
As the error below clearly statest that you are trying to perform Online rebuild operation on an index that contains data type text, ntext, image, varchar(max), nvarchar(max), varbinary(max), xml, or...
February 2, 2012 at 2:14 am
You need powershell for XP. Also which edition of SQL Server are you trying to install on Windows XP?
February 2, 2012 at 1:57 am
Check if there are any Anti-virus scan is scheduled to run at the same time...
February 2, 2012 at 1:47 am
You would need to check setup log files located at %SQL Server folder%\setupbootstrap\log folder
April 19, 2011 at 4:37 am
Did you try specifying IP Address while connecting to the server.
Are you trying to connect directly from the Host Server, if yes, try to connect using sqlcmd.
sqlcmd -S<servername> -E
April 19, 2011 at 3:37 am
Not sure of SQL 2008 base version but for For SQL Server 2008 R2 Standard Edition to use locked pages in buffer pool, you need to enable Trace Flag 845...
March 28, 2011 at 8:39 am
If your log file is corrupt then you cannot bring the Database online, unless you rebuild the log file. As far as the DBCC CHECKDB is concerned, here is what...
March 28, 2011 at 8:30 am
you can also use LogParser2.2 tool to view differnt log files, store the results into SQL Server tables. You can download it freely from microsoft website
HTH
RK
March 28, 2011 at 8:09 am
Try "Lock Pages in Memory" 🙂
HTH
RK
March 28, 2011 at 8:04 am
Viewing 12 posts - 1 through 12 (of 12 total)