Viewing 15 posts - 46 through 60 (of 110 total)
I didn't set up to save txt file logs.
I have deleted backup Database Maintainence Plan and can't reproduce it.
But I have another example. When I disabled backup job, I also...
March 2, 2010 at 9:36 am
I don't know. I just viewed the maintainence history and found that maintainance plan still backed up database.
March 2, 2010 at 7:19 am
george sibbald (2/22/2010)
use with standby option
Thank you. That works.
February 22, 2010 at 7:29 am
george sibbald (2/12/2010)
run a reindex, backup again, see what happens
Thank you. It works.
After I reindex one table "backupfile". the size for this table is "18094K".
backup size is 2G.
You are really...
February 12, 2010 at 1:30 pm
george sibbald (2/12/2010)
just to confirm, even after the delete, the backup is the same size?
Yes. backup size : 3.9G
February 12, 2010 at 1:19 pm
GT-897544 (2/12/2010)
Did you run log back up after deleting records? Did you shrink data\log file? Check MDF and LDF file size before and after log back up.EnjoY!
MSDB is in...
February 12, 2010 at 1:11 pm
rafael_si (2/12/2010)
Hi,You should use: DBCC UPDATEUSAGE
but pay attention:
Thank you for reply.
After I did "DBCC UPDATEUSAGE(msdb)", the result is same.
February 12, 2010 at 12:58 pm
GSquared (11/5/2009)
Run a DML trace on the database. Check out sp_trace_create in BOL.
Can you let me know which trace event I should add to trace Truncate table?
November 5, 2009 at 9:44 am
Thanks For your reply.
Server has been set up /3GB /PAE. AWE enabled.
One system process takes 25% CPU constantly. When I checked System process details using ProcessExploer, it is...
June 22, 2009 at 12:10 pm
george sibbald (6/22/2009)
what does the perfmon counter show? I would trust that value
In one of my server:
Serverserver: Memory Manger Total Server memory (KB): 6287360.
June 22, 2009 at 9:39 am
george sibbald (6/19/2009)
June 22, 2009 at 7:07 am
CrazyMan (5/26/2009)
Hi JudyAre this separate jobs, or its on a job that runs after the first once have completed
They...
May 26, 2009 at 10:15 am
***111057.295.001720
You log space used % is 95%.
try truncate first then shrink log file.
Finding log logical name:
Sp_helpfile 'DBNAME'
May 26, 2009 at 10:05 am
Steve Jones - Editor (5/26/2009)
May 26, 2009 at 9:55 am
You need to shrink log file.
DBCC shrinkfile('log_logicalname',10000). this commang will shrink log file to 10G, give the size you want to.
if it is not working, Try
backup log DBNAME...
May 26, 2009 at 9:25 am
Viewing 15 posts - 46 through 60 (of 110 total)