Viewing 15 posts - 41,041 through 41,055 (of 49,571 total)
sunny1_liu (2/16/2009)
But in my opinion, profiler may consume many system resources, so we hardly turn it on unless really necessary.
So don't use profile. You shouldn't be using profiler on a...
February 17, 2009 at 12:28 am
bodhilove (2/16/2009)
Hi when I run a dbcc it seems to take up all my buffer cache.
Hardly surprising. CheckDB is very intensive and it has to read the entire database,...
February 17, 2009 at 12:24 am
Enable traceflag 1222. It will write the deadlock graph into the error log whenever a deadlock occurs. Please post the deadlock graph here and we'll try and help.
A single query...
February 17, 2009 at 12:21 am
Please post in an appropriate forum in the future. The article discussion forums are for article discussions
February 17, 2009 at 12:17 am
louisevb (2/16/2009)
Do you have any advise from your side?
Stop worrying about the certs and concentrate on learning the basics well. Certs are fine later, when you have some experience...
February 17, 2009 at 12:13 am
Jeff Moden (2/16/2009)
How much of this applies to the system's databases (not including TempDB, of course)?
MSDB can be repaired, I believe (haven't tried it). Master I would recommend...
February 17, 2009 at 12:08 am
Ninja's_RGR'us (2/16/2009)
I just saw Gail's post, I guess that's why I can't get this to work >>>
You need to backup the log before the restore, not after. After a restore...
February 17, 2009 at 12:02 am
scottdever (2/16/2009)
The error logs just say that sql cannot access the ldf files.
It should have given a reason (Operating system error.....)
February 16, 2009 at 11:47 pm
Magy (2/16/2009)
Ok, all I see is FULL in the backup_type. How do I turn on transactional logs?
For transaction log backups, see the entry in Books Online "Backup log"
it's not...
February 16, 2009 at 8:40 am
Check the SQL error log. There should be some info in there. Please post any relevant log entries
February 16, 2009 at 8:33 am
louisevb (2/16/2009)
I have decided to change my career from accounting to Database Developer
Why? What is it about databases that interests you?
February 16, 2009 at 8:32 am
Check the sql error log. If the DBs are getting marked suspect, there will be entries in there saying why.
February 16, 2009 at 8:28 am
digitalox (2/14/2009)
GilaMonster (2/14/2009)
Simple recovery has no effect on what's written to a DB's log. Just how long it's retained after it's written.
Good point, not sure why but I've always been...
February 16, 2009 at 8:25 am
eashoori (2/16/2009)
I thought Transact log backup actually help the performance during busy hours, is it not true?
Backups are for recoverability, not performance
February 16, 2009 at 8:21 am
Viewing 15 posts - 41,041 through 41,055 (of 49,571 total)