Viewing 15 posts - 76 through 90 (of 859 total)
Scott Coleman (5/21/2009)
Krishna Potlakayala (5/21/2009)
Are you sure you can take a differential backup once the tlog has been truncated- (which means you have broken the log chain)- once truncated only...
May 21, 2009 at 11:12 am
Sadequl Hussain (5/20/2009)
Problem:
A database exists in a SQL Server instance with an application regularly posting large volumes of data in it. The database log...
May 21, 2009 at 6:30 am
RPSql (5/20/2009)
1.Database is in full recovery mode and we are using database mirroring on it. We are doing nightly full backup and hourly trans backups.after each trans...
May 21, 2009 at 6:25 am
Sadequl Hussain (5/19/2009)
Krishna Potlakayala (5/19/2009)
I am afraid these ARE options. At least better than stopping SQL Server.
On what basis you say that?
Well, I would be saying this because in my...
May 20, 2009 at 12:09 am
george sibbald (5/19/2009)
Krishna Potlakayala (5/19/2009)
Gaby Abed (5/19/2009)
RPSql (5/16/2009)
-if percent fragmentation value is between...
May 19, 2009 at 4:44 pm
Andy Hogg (5/19/2009)
Should one follow directives from above, even when those directives at best contradict best practice, and at worst endanger data and or system availability?
Nope definitely not. Here Top...
May 19, 2009 at 4:10 pm
Sadequl,
I am afraid these ARE options. At least better than stopping SQL Server.
On what basis you say that?
And I did mention about truncation breaking log chain - read before...
May 19, 2009 at 4:03 pm
Gaby Abed (5/19/2009)
RPSql (5/16/2009)
-if percent fragmentation value is between 5% to 30% then...
May 19, 2009 at 3:38 pm
ip2host (5/19/2009)
I have a very big problem.
Our DBA let suddenly and his part of job is now my concern. I have to mention that I am not DBA nor...
May 19, 2009 at 6:03 am
SQL_Monster (5/18/2009)
Thanks for all the inputs...I Have reconfigured the LS again... Its working fine now...
It's our pleasure 🙂
May 18, 2009 at 11:52 pm
pradyothana (5/18/2009)
If there is no logshpping in place, Better to truncate the log after backup. Log will grow due to heavy DML operations on the tables/objects.
No. Do not truncate the...
May 18, 2009 at 1:42 pm
amina omar (1/23/2004)
My transaction log keeps filling up, even though it's backup nightly and should be getting truncated any time it's backed up. I ran dbcc opentran to see if...
May 18, 2009 at 1:40 pm
I'd agree that you have to do what management says but what if a disaster happens then who would be blamed at the end, it's the DBA? Would you not...
May 18, 2009 at 1:19 pm
Jeremy Brown (5/18/2009)
May 18, 2009 at 12:00 pm
Jeremy Brown (5/18/2009)
I get asked to do stupid things by clients / managers all the...
May 18, 2009 at 11:38 am
Viewing 15 posts - 76 through 90 (of 859 total)