Viewing 15 posts - 36,946 through 36,960 (of 49,566 total)
Either the files for that database were moved or the permissions on those files were changed.
August 20, 2009 at 7:03 am
System database can never be detached.
There are specific ways to restore backups of system databases, and it's different for the different system databases. Consult books online for full details.
August 20, 2009 at 5:46 am
Whizkid (8/20/2009)
Is there any way to find what was happened before this db suspect?
From the error messages it shows that when SQL restarted the data and log files for the...
August 20, 2009 at 4:42 am
Paul Randal (8/19/2009)
Why did you CHECKDB model?
I asked him to just to be sure that there wasn't some corruption in model that was coming across when TempDb's recreated. Purely precaution.
August 20, 2009 at 1:51 am
GSquared (8/19/2009)
Or video it, and review the video yourself. It's amazing what you'll note when you watch yourself in action. Sounds narcisistic, but it's really useful.
Do that and...
August 19, 2009 at 3:39 pm
Irfan (8/14/2009)
select * from dbo.sysobjects ( not sys.tables)
sysobjects is deprecated in SQL 2005 and will be removed in a future version of the product. Rather use sys.objects, if you...
August 19, 2009 at 3:37 pm
You can query sys.databases to see why the log space is not been reused. Check the log_reuse_wait_descr column.
August 19, 2009 at 2:04 pm
Grant Fritchey (8/19/2009)
Did you get any constructive criticism? That's the stuff I live for, when someone actually has useful insights, not just "You did great" or "You stink."
Nothing really useful....
August 19, 2009 at 2:04 pm
espanolanthony (8/19/2009)
so deleting indexes that have reads 0 is a good idea?
Not without doing some additional investigation to confirm that the index is not used anywhere. You need data over...
August 19, 2009 at 2:01 pm
Whizkid (8/19/2009)
I don't have DB back up but I 've MDF & LDF file and using those files I was re-attached the database.
So do you still have a problem or...
August 19, 2009 at 2:00 pm
Roy Ernest (8/19/2009)
GilaMonster (8/19/2009)
*Woot* Just got TechEd evaluation scores. Bar one comment, very nice!Congrats Gail... Party Time.. 🙂
Party time next time I see my Lead (probably next week), I'll make...
August 19, 2009 at 10:13 am
Profiler with an SP:Completed event should do the trick. That'll show the total duration, reads, writes and CPU that the procedure did.
The sp:completed event is not one of the default...
August 19, 2009 at 10:11 am
Kit G (8/19/2009)
Can you direct me to the reference that explains what you did?
Reference? I'm sure there's one somewhere but I wouldn't know where.
Ok, when there are multiple queries combined...
August 19, 2009 at 10:09 am
Jack Corbett (8/19/2009)
GilaMonster (8/19/2009)
*Woot* Just got TechEd evaluation scores. Bar one comment, very nice!Congrats, but of course exactly what I'd have expected for you, barring the one negative comment.;-)
Comment essentially...
August 19, 2009 at 10:03 am
Kit G (8/19/2009)
August 19, 2009 at 9:18 am
Viewing 15 posts - 36,946 through 36,960 (of 49,566 total)