Viewing 15 posts - 16 through 30 (of 98 total)
i mean to say ..if a 'truncate' command happened in a database.Will it be logged in a full recovery model
October 13, 2010 at 4:05 am
george sibbald (10/11/2010)
running a log backup should shift those. Find out who is controlling sharepoint administration.Personally I would turn their log backups off and rely on native SQL ones.
what is...
October 11, 2010 at 9:57 am
Just to confirm not an open transaction run dbcc opentran whilst connected to databases and also dbcc loginfo(SharedServices1), check that column status does not have a value of 2...
October 11, 2010 at 9:46 am
select * from msdb..backupset where database_name = 'SharedServices1' and type = 'L'
(check I have correct dbname)
Above query is returning results in such a way that log back up is happening...
October 11, 2010 at 9:21 am
Actually we are taking DPM backup .So backups are not scheduled at all.
sorry! not DPM backup,Instead .MDF & .LDF files are backing up to tape on a daily basis.Here the...
October 11, 2010 at 8:47 am
er people, the statement above does not tally with not taking log backups!
please post the results of that query shanila so we check results. Just maybe you had a very...
October 11, 2010 at 8:41 am
[/quote]
er people, the statement above does not tally with not taking log backups!
please post the results of that query shanila so we check results. Just maybe you had a very...
October 11, 2010 at 8:38 am
Create a maintenance Plan to run Transaction Log backups every 15 minutes or so.
Create a cleanup step that deletes the t-log backups over 'x' days or weeks old.
I read that...
October 11, 2010 at 8:31 am
General Guidelines - (specifc "best" options vary widely based on business needs) :
Create a maintenance Plan to run Transaction Log backups every 15 minutes or so.
Create a cleanup step that...
October 11, 2010 at 8:25 am
If we are taking transaction log backup in Principal database(database mirroring),will it effect the transactions happening to mirror database in any way.
October 11, 2010 at 8:14 am
george sibbald (10/11/2010)
do you have 20Gb of space to do a T-log backup because it is likely to be that size.what is the result of running dbcc sqlperf(logspace)
dbcc sqlperf(logspace) is...
October 11, 2010 at 7:09 am
rjohal-500813 (10/11/2010)
shanila_minnu (10/11/2010)
NO we are not doing T log backup.
...and there lies your problem. I would suggest that you take a read of backup & restore concepts to fix your...
October 11, 2010 at 6:25 am
Thanks for the reply.will be there any performance impact while running sql profiler?Will trc file occupy more space.
October 11, 2010 at 6:09 am
Viewing 15 posts - 16 through 30 (of 98 total)