Viewing 15 posts - 676 through 690 (of 1,179 total)
The possibilities of not shrinking the log file is open transactions into the log. Have you checked for any open transactions?
To overcome this problem just delay shrink job by 1...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 8, 2011 at 11:35 pm
Tom,
Yes, easy and that too have 2 points 😉
Cheers!
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 8, 2011 at 11:30 pm
My suggestion is to capture load during peak hours rather than average.
You can use PERFMON to capture required details.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 6, 2011 at 1:37 am
That's what above link says.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 6, 2011 at 1:34 am
Hello William,
Please refer the following two links which might help you to justify to the management.
http://msdn.microsoft.com/en-us/library/aa175395(v=sql.80).aspx
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 6, 2011 at 12:01 am
Got incorrect.
But thank you for nice question. New learning.
SQLSKILLS Link is super and my favourite site too.
Cheer!
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 5, 2011 at 11:41 pm
One more good question 🙂
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 4, 2011 at 11:41 pm
Is there any bulk transactions running on the database? Commit the transactions in small chunk and increase the tlog backup frequency may help.
Try to narrow down when exactly issue happen?...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 4, 2011 at 3:19 am
sqlapprentice (4/28/2011)
free_mascot (4/28/2011)
Does adding additional primary/secondary file too applied on mirror?
Just tested on one of our mirrored pair, yes, the secondary file if added on principal is also added on...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 28, 2011 at 11:19 pm
Does adding additional primary/secondary file too applied on mirror?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 28, 2011 at 6:46 am
dbcc dbreindex will work but it will be removed in the future version of the sql server.
Hence advisable to use Alter index from sql server 2005 onwards as mention...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 28, 2011 at 6:33 am
If SQL cluster is in place you can detach and attach log file on the SAN. If not need to set up the cluster and do the detach and attach...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 27, 2011 at 11:32 pm
Microsoft says "You cannot back up or restore individual tables."
Best option in my openion is restore full + tlog backup to new database and extract the table data.
Else you need...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 27, 2011 at 11:26 pm
In addition to the above dbowner is having full permission on database.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 8, 2011 at 11:00 pm
If you are have decided to go with flushed the proc cache; make sure you flushed the correct and specific cache which is problamatic (as per your investigation). And make...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 8, 2011 at 10:56 pm
Viewing 15 posts - 676 through 690 (of 1,179 total)