Please also see attached vasset and cellgroupcell table structure in two worksheets. Below is the view vasset.

vasset:

SELECT assetId AS cellAssetId, assetName AS assetId, assetName, sequence, standardRate,...

PLease see the attchments:

Downtime.sqlplan and the structure of the view.

Just to add to my previous point.. Can creating a partition work in this scenario..There's about 16 million rows in one table. i am just worried that it...

The database has got one Primary Filegroup. I have created another filegroup called 'Filegroup_1'. I have put .ndf on Filegroup_1.

Which do you think will be more efficient to transfer...

Thank you guys for your responses

I have only got one day of downtime. Some of the tables have got more than a million rows. This might take a lot of...

yes it is for reporting purpose, i am using this as an xml document which is being called by CGML.

CGML is limited as far as formatting data is concerned, so...

Thank you guys for your responses, I have resolved it by amending the cursor..

Drew you are rite the eventmeasure table should not be there at all. This will be taken...

Eventmeasure table gets eventid from event table and...

This is the cursor that i used:

Please note: this is based on real data, data in the above post is just an example of how i would like the result:

declare...

The files are in the Backup Directory. The backup...

I have done that, Still the files exist. I don't get any error message.

EXECUTE master.dbo.xp_delete_file 0,N'E:\DATA\MSSQL.1\MSSQL\Backup\ ',N'bak',N'2009-08-03T11:09:59',1

I don't get an error message. It says command completed successfully.

I agree transaction log should be set up more often which i am looking into, but that should not stop the other maintenance plan to delete the old backup files....

There are two maintenance cleanup task. One with extension BAK and the other with TRN for deleting files older...

I do apologise i posted it in the wrong forum.. It should have been SQL 2005.