Viewing 15 posts - 91 through 105 (of 109 total)
As i know, we can configrue servcie recovery then response when the servcie failed. You could try to restart the servcie or run a progam. It seems could run a...
February 25, 2011 at 1:46 am
I think the DBA could access these folder if the SQL Server servcie account has the permission.
February 24, 2011 at 2:26 am
Could you check the registry key entry to see if the providers are listed?
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Providers
Also you could try to create a .UDL file to check whether you could...
February 24, 2011 at 2:16 am
It is not recommended to run SQL Server from Local System Account. The best way is to create simple user account for SQL Server in AD and configure SQL Server...
February 24, 2011 at 1:19 am
Please refer to this articles:
How to rebuild the performance counters of a SQL Server 2005 or 2008 instance
http://blogs.msdn.com/b/john_daskalakis/archive/2009/05/07/9593110.aspx
This can help you re-load the performance counter.
February 24, 2011 at 1:17 am
It seems the back compression only aviliable in enterprize edition. The best pratice is backup to local and then copy it to remote.
I saw your log file is so huge,...
February 24, 2011 at 1:05 am
It seems the back file is corrupt. In fact, CONTINUE_AFTER_ERROR is intended to allow to restore after an incorrect page restore - not to allow restore from invalid data.
By...
February 24, 2011 at 12:59 am
This error occurs when a Microsoft SQL Server finds a problem with a statement issued by the current process. This could be because of many reasons like :
•File level...
February 24, 2011 at 12:48 am
I am afrid you may not able to do this with Management studio.
There is a "view T-SQL" button could let you view the T-SQL for each component, but these...
February 23, 2011 at 12:31 am
If a SQL Server user is logged in using Windows Authentication, the user can read only the files accessible to the user account, independent of the security profile of the...
February 21, 2011 at 11:55 pm
Did you move your tempdb to another lcoation and keep the old file in default data folder? If so, please delete the old tempdb file in default folder and try...
December 10, 2010 at 2:36 am
Just like Lowell said, delete the file,all instance disappear.
I did not realized the file contains these instance name are related with user account, i thought these information are...
September 20, 2010 at 3:24 am
This has been solved, thanks guys
September 19, 2010 at 1:46 am
Yes, after disable disable highlighting New Programs in Windows 7,the color disappeared. Thanks!
September 17, 2010 at 3:27 am
Viewing 15 posts - 91 through 105 (of 109 total)