Table_Namerowsreserved_KBdata_KBindex_size_KBunused_KB

table 1 725757 352368 KB264088 KB75248 KB13032 KB

table 242157 ...

NameOfFileTotalSizeInMBSpacesUsedInMBAvailableSpaceInMB

cs_Dot11330.1875008325.4375003004.750000

cs_Dot_log672.250000119.398437552.851563

I found a table which takes the most spave in my db:

rowsreserved_KBdata_KBindex_size_KBunused_KB

821656 361200 KB264088 KB84472 KB12640 KB

I am deleting data unused, would this eliminate size of...

Why are you shrinking your databases? And then, right after shrinking the database and log file you are performing an index rebuild/reorganize which is just going to grow the database?...

You were right I found other job:

which breaks a log chain which contains: BACKUP LOG @dbName WITH truncate_only, I am commenting this code out and I think that would...

Two questions:

1) Why do you think you have to restore the database to re-establish the log chain? To re-establish the log chain you have to perform a full or diff...

How can I check who ran the back up?

Here is errror:

Executing the query "BACKUP LOG [Jul_reports] TO DISK = N'F:\\TransactionJobs\\Jul_Reports\\jul_Reports_backup_201004251500.trn' WITH RETAINDAYS = 1, NOFORMAT, NOINIT, NAME = N'Jul_Reports_backup_20100425150007', SKIP, REWIND, NOUNLOAD, STATS =...

Operator Paged

Retries Attempted0

Message

Executed as user: \sqlservices. ...042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 3:00:00 PM Progress: 2010-04-25 15:00:04.16 ...

I have for my database 10,303 MB, I want to know what includes in this data for each table.

thank you

thank you

in Maintanse plan there is an option when to expire for back up and I sat up in 1 day.

I did test mail and I got it,so it smptp could be blocked

No error messages in sysmail_log