Viewing 15 posts - 676 through 690 (of 994 total)
oh - just realized you said 2005 - this is a 7.0 and 2000 specific forum - there's another 2005 specific forum.
June 5, 2008 at 1:25 pm
ok - could be transient problems in the IO subsystem? Can you post the output from CHECKDB when it does find errors? Is this the same for all DBs or...
June 5, 2008 at 1:24 pm
Sounds like it's not actually running in your maintenance plan properly if you can manually run it and it takes longer. How do you have your maintenance plan setup? Custom...
June 5, 2008 at 11:28 am
Did you try killing the spid manually with 'kill '?
June 5, 2008 at 11:05 am
Have you tried setting the database to single-user mode?
ALTER DATABASE yourdb SET SINGLE_USER WITH ROLLBACK IMMEDIATE or WITH NOWAIT
June 4, 2008 at 3:05 pm
That only works if the database was cleanly shut down - i.e. the transaction log doesn't have any transactions that need to be rolled back. In this case the database...
June 4, 2008 at 11:39 am
My bet is there's a ton of transaction log being recovered. Can you check the disk IOs on the log drive?
Beware of trusting the estimated completion times in the dm_exec_requests...
May 30, 2008 at 2:10 pm
ok - that acronym still doesn't mean anything as far as SQL Server is concerned. MDF, NDF, LDF are the acronyms people use for the primary file, secondary files, and...
May 24, 2008 at 10:58 am
Regular database files (mdfs, ndfs, ldfs) are never sparse. Period.
The only files that SQL Server creates that are sparse are those used by database snapshots - either explicitly created or...
May 23, 2008 at 4:32 pm
Can you post the CHECKDB output I requested so I can see how the record is corrupted? Then I might be able to help you.
May 22, 2008 at 10:10 am
ok - a few misconceptions need to be corrected here.
"Since backups are just from committed transactions"
"A restore restores the data, not the log. It sets the log file size, but...
May 21, 2008 at 9:52 am
What is a DBF database?
May 20, 2008 at 10:57 pm
Are these the only errors in the output from CHECKDB? If not, please post the entire output.
Thanks!
May 20, 2008 at 4:51 pm
fyz (5/16/2008)
If necessary, I think you can try a utility called Advanced Access Repair[/url] to repair your Access file. It works rather well for my corrupt Access files....
May 17, 2008 at 5:08 pm
Viewing 15 posts - 676 through 690 (of 994 total)