Viewing 15 posts - 31 through 45 (of 147 total)
Yes I"m talking in terms of SQL server 2000 only.
Recently we faced errors with Full text indexes when one of our Cluster server failed over to the other node....
October 25, 2007 at 3:18 am
I'm not sure but I read this somewhere here only on this site
"The Full Text Search service is also known as Microsoft Search if you're looking for it under your...
October 25, 2007 at 12:32 am
Check if there have been any changes in the past few months with respect to application,network or the db server. They will give you the best start for this.
October 24, 2007 at 11:18 pm
Doing it from GUI on a table with 1 million records will definitely take a toll. Well in 2005 also if you alter the table through management studio then it...
October 23, 2007 at 7:25 am
Well my first advice be to have a look at the proc and see why it is making the log grow so much. Also if the proc will require 10...
October 23, 2007 at 7:03 am
What are the steps included in the maintenance plan. Are you doing the reindexing just before the full backup. Does the database size increases after the backup or it reamins...
October 23, 2007 at 4:15 am
This should be helpful.
http://www.sqlservercentral.com/articles/Administering/checkingyourdatabasefragmentationlevel/1373/
October 15, 2007 at 10:33 am
Hi,
This is there in BOL. You can modify this a bit to run for all the databases
This example shows a simple way to defragment all indexes in a database that...
October 14, 2007 at 10:15 pm
Well I would suggesst not to shrink the log as it will grow again when trasactions will happen. Try removing the dbcc shrinkfile portion from the job and simply...
October 12, 2007 at 1:02 pm
Well does the user has access to the database. The error message states very clearly that the user does not have permission to perform this action.
Just check the permissions for...
October 12, 2007 at 12:13 pm
Well while configuring you can also script the portion. Try scripting it out and then run it.
October 12, 2007 at 9:33 am
This article gives a quick view of the enhancements in the 2005 backups
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1134737,00.html
October 12, 2007 at 3:35 am
yes other backups are working fine. The backups for which I get this error also work fine at time but at times this error comes up.
October 12, 2007 at 3:27 am
Viewing 15 posts - 31 through 45 (of 147 total)