Viewing 15 posts - 1 through 15 (of 20 total)
There are a couple of things you can check/try:
- The disk where you are storing the database backup has enough space.
- Try using compression with backup.
June 29, 2011 at 10:32 am
Agents set to run every five min. has been working fine from a long time as we don't have that many transactions. Distributor and publisher are the same server.
January 26, 2010 at 3:42 pm
The problem was disk corruption causing the database to get corrupted frequently. Thanks a lot for all your help.
December 8, 2009 at 3:41 pm
running dbcc checkdb with repair_rebuild took care of the consistency and allocation errors. But I still get "non-recoverable I/O error"
where I try to do a full backup. Get error MS_DOS...
December 4, 2009 at 12:52 pm
Roy Ernest (2/3/2009)
cherie (2/3/2009)
yes, I know it should but we started seeing errors from application.Do you remember what kind of error messages you got?
Login failed message..
February 3, 2009 at 10:50 am
yes, I know it should but we started seeing errors from application.
February 3, 2009 at 8:13 am
Lately I had an issue when I moved one of my windows user to active directory group and gave the same permissions to the group as the user, the user...
February 2, 2009 at 4:31 pm
Freeing up proc cache really helped. Thanks..
February 2, 2009 at 4:19 pm
Chirag: I can't change indexes..:-( I have to go to developers for that, which is a really-really long process.
January 16, 2009 at 9:44 am
I have a job setup which runs the script below on the database:
EXEC sp_MSforeachtable @command1="print '?' DBCC DBREINDEX ('?', ' ', 80)"
GO
EXEC sp_updatestats
GO
January 16, 2009 at 9:40 am
Thanks Mike..I'll do some more diggin' and see what's going on.
Thanks a lot..
January 15, 2009 at 12:48 pm
One more question..why is it then that when I manually rebuild one of the table index, performance gets better and then again after a week with reindexing..it goes down again.
January 15, 2009 at 12:28 pm
Viewing 15 posts - 1 through 15 (of 20 total)