Viewing 15 posts - 256 through 270 (of 859 total)
Usually at 2 log backups will truncate the file enough and cycle to allow the shrinking of the file
I second that.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
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...
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
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.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
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...
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
August 16, 2011 at 4:47 am
Sometimes i have seen the restoration happened from lower version to higher version has this problem.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
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...
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
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...
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
August 16, 2011 at 12:41 am
Maximum database size of 4 GB in express.
How much size the BCP data has.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
August 13, 2011 at 3:51 am
What "log_reuse_wait_desc" it shows in sys.databases
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
August 13, 2011 at 1:28 am
How to downgrade a database from higher version to lower version
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
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.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
August 11, 2011 at 2:52 am
rk2150 (8/9/2011)
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
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...
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
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...
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
August 8, 2011 at 11:54 pm
First check the perfmon and let us know what it's shows?
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
August 8, 2011 at 11:49 pm
Viewing 15 posts - 256 through 270 (of 859 total)