Viewing 15 posts - 41,026 through 41,040 (of 49,571 total)
colin Leversuch-Roberts (2/17/2009)
whether you can pass one index hint i have no idea - never tried that.
You can't. Plan guides are limited to the hints that appear in...
February 17, 2009 at 2:22 pm
When you run ALTER DATABASE ... MOVE ... SQL doesn't actually move any files. If it's a user database that you've done the alteration to, you have to take...
February 17, 2009 at 2:12 pm
Please run the following and post the results.
DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS
Is that database a critical production DB that you're taking log backups of?
Are there...
February 17, 2009 at 2:02 pm
Ninja's_RGR'us (2/17/2009)
That begs this question... assuming you have a corrupt backup of msdb, can you rebuild it then reimport the data back in?
You should, providing you can get the data...
February 17, 2009 at 1:55 pm
<Sigh> Why don't people read the manuals?
February 17, 2009 at 1:54 pm
murthykalyani (2/17/2009)
Once this is done, you can truncate your log.
Um, if this database is in full recovery and log backups are been done, then a log backup can be done,...
February 17, 2009 at 1:53 pm
Look up "ALTER AUTHORIZATION" in Books Online. There is both a detailed explanation and a number of examples
February 17, 2009 at 1:51 pm
cafescott (2/17/2009)
I'm still playing with these settings, trying to avoid the error. thanks.
The error's saying that it's taking too long to grow the file by the required 20 MB....
February 17, 2009 at 1:09 pm
cafescott (2/17/2009)
I click the Autogrowth button...
February 17, 2009 at 1:07 pm
Well, why do you need to fail back? What's wrong with just leaving the former mirror as the principal?
February 17, 2009 at 1:02 pm
Sailor (2/17/2009)
Perhaps as a preventative measure, how often should I run check db?
There's no right answer for that. Run it often enough that if is does find corruption you can...
February 17, 2009 at 12:56 pm
louisevb (2/17/2009)
Oops it is Gail, sorry i am half asleep morning 😀
😀
Either works, I don't mind.
February 17, 2009 at 1:21 am
By updating stats after rebuilding indexes, you've left the statistics less accurate than they would have been. Index rebuild updates all stats with fullscan. If you then do a sampled...
February 17, 2009 at 12:37 am
You've got transactional replication set up and a log reader that's never run. Is that database supposed to be replicated?
February 17, 2009 at 12:29 am
Viewing 15 posts - 41,026 through 41,040 (of 49,571 total)