Viewing 15 posts - 256 through 270 (of 860 total)
Usually at 2 log backups will truncate the file enough and cycle to allow the shrinking of the file
I second that.
August 17, 2011 at 6:37 am
Andrew Theodore (8/16/2011)
Has anyone ran into an issue where a log file for a given database will not clear? I'm running 2008 SP1 and I have a...
August 17, 2011 at 12:28 am
Joy Smith San (8/16/2011)
2) glenn allan berry has great diagnostic collection script
3) brent ozar has a good 'blitz' script
Thanks. Where can I find those scripts .?
From Google.
August 17, 2011 at 12:03 am
prem.budhu (8/15/2011)
ThanksHere is the result from the sys.database
masterSIMPLENOTHING
tempdbSIMPLEACTIVE_TRANSACTION
modelFULLLOG_BACKUP
msdbSIMPLENOTHING
mydbFULLLOG_BACKUP
mydbFULLLOG_BACKUP
The wait telling you to do more log backups.
What’s the frequency of log backup setup in your log shipping?
Yep definitely too many VLF's...
August 16, 2011 at 4:47 am
Sometimes i have seen the restoration happened from lower version to higher version has this problem.
August 16, 2011 at 1:36 am
SELECT
object_id AS objectid,
index_id AS indexid,
partition_number AS partitionnum,
avg_fragmentation_in_percent AS frag
INTO #work_to_do
FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL , NULL, 'LIMITED')
WHERE avg_fragmentation_in_percent > 10.0 AND index_id > 0;
According to Jeff, if the table reside...
August 16, 2011 at 12:59 am
ravisamigo (8/16/2011)
Hi,Is there any issue/effect to Production servers,If we configure database mail for database alerts using Gmail.
Please advise me.
Thanks and Regards,
Ravichandra.
Yep there will be some network latency.First why are you...
August 16, 2011 at 12:41 am
Maximum database size of 4 GB in express.
How much size the BCP data has.
August 13, 2011 at 3:51 am
What "log_reuse_wait_desc" it shows in sys.databases
August 13, 2011 at 1:28 am
August 13, 2011 at 1:20 am
forsqlserver (8/11/2011)
Why bulk logged recovery model supports Logshipping?
Very simple. You can able to take the log backup in this mode.
August 11, 2011 at 2:52 am
rk2150 (8/9/2011)
August 9, 2011 at 2:26 am
AAKR (8/8/2011)
what i have to do this situation please giveme some suggetions...thankyou in advance
Run the following query you can easily find it actually SQL is occupying space or not.
select size/128...
August 9, 2011 at 12:08 am
clarification (8/8/2011)
Im selecting top1000 rows of a table but it takes very long time.can anybody suggest whats going on please
How long will it take to return the result?
top 1000 is...
August 8, 2011 at 11:54 pm
First check the perfmon and let us know what it's shows?
August 8, 2011 at 11:49 pm
Viewing 15 posts - 256 through 270 (of 860 total)