Please provide screen shots of the maintenance plan and the maintenance plan tasks.

Is SR_NO used as a foreign key to any other tables? Either through physical foreign keys or via application inserting into table and getting the SR_NO at insertion time?

What would...

Are you appending to the same file in the maintenance plan, or are you creating a new file on each run of the plan?

Hopefully this will do it based on the max record date for a particular day then linking back to itself to get that row for that particular database.

SELECT

T1.RECORD_DATE,

T1.DATABASE_NAME,

T1.FILE_SIZE,

T1.FILE_SIZE_USED,

T1.DATA_SIZE,

T1.DATA_SIZE_USED,

T1.LOG_SIZE,

T1.LOG_SIZE_USED

FROM

sometable T1

INNER JOIN

(

SELECT

MAX(RECORD_DATE)...

You would want the MAX recorded date, then you will need to group by the remaining columns

SELECT

MAX(RECORD_DATE)

DATABASE_NAME,

FILE_SIZE,

FILE_SIZE_USED,

DATA_SIZE,

DATA_SIZE_USED,

LOG_SIZE,

LOG_SIZE_USED

FROM

sometable

GROUP BY

DATABASE_NAME,

FILE_SIZE,

FILE_SIZE_USED,

DATA_SIZE,

DATA_SIZE_USED,

LOG_SIZE,

LOG_SIZE_USED

That will only give the last recorded value, not on a daily basis.

Will...

Looks like you might want SSIS for this.

Plenty on the topic in the stairways section.

Use it to load the file into the table, then you can use T-SQL to modify...

If the database is important, why wasn't the database stored on a server and not a desktop and why didnt you have a proper backup routine in place for the...

Good blog Wayne will bookmark that.

Just one thing you have a [/u] IFCode in the URL link, so if you click it you get a 404 error.

Trace the UOW back to the originiating host via sys.dm_exec_requests and terminate the DTC transaction from the source, that should resolve the issue.

The user you have specified in the data source doesnt have access to the SQL server or database in the datasource.

If you have used a SQL login, ensure the users...

The only posibility then that I am aware of is that the account your loging in as isn't sysadmin or a member of the SQL Agent fixed roles.

If your system was corrupted when you took the backup then it is likely that the backup is also corrupted hence why you are getting these errors.

The only way to...

Are you bothered about the alerts during the weekend as well as the weekdays?

If so you will need to set the alert to 62 hours for a backup threshold if...

You dont need an execute SQL task, just a data flow task.

Create connection managers for ServerA,B,C,D,E and then a connection manager for the server where the big table is going...

I would first direct you to these links

Backup

Restore

If you have any issues after that please detail what the issues are.

If your talking about a parallel data warehouse, I would of...