Thanks, just to add

below is the SQL error i am getting

BackupMedium::ReportIoError: write failure on backup device 'VDI_C4D30BA6-0EB3-47AA-AC2C-72030AA92979_1'. Operating system error 1(Incorrect function.).

may be you have any idea looking at this

thanks alot for your kind guidence champions.

thanks for your reply but do you have any idea why my DB went to suspect mode?

I just copy paste the file, so to avoid any delay while i found a solution

i change it back to the old location.

Thanks All for your reply, will let you know the result after completing this task.

Tell me the best you think going to help. stopping replication and reinitilizing or just deleting in small chunk and keep replication to do it job?

Thanks Guys for your reply this will really going to help.

@getoffmyfoot: below is the detail of one of my biggest table.

Total number of rows in table:831762784

Rows that get...

ok so here's the complete Scenario,

Client provide us 11 different link for 11 different files (different contries) having ID's (numeric) in it. we match these id's with our Panel of...

Alvin,

I am bit aware of SSIS, and think that i have sound knowledge.

I am able to loop around all files(Source) using for each loop container but facing issue to create...

Thanks For your reply,

Task is completed.

thanks for your reply, but i am not looking it for free. i have no issue paying the cost but that should be the good one.

thanks Tim, it worked.

Yes, i have tried it few days back. it worked fine for me.

I just found that all of my Replication Cleanup Jobs(Agent History Cleanup, Distribution cleanup etc) were not running.

Does it impact the performance of Server?

Hey,

I checked OS Log and found:

The file system structure on the disk FreeAgent Drive is corrupt and unusable.

FreeAgent Drive is the drive i copied the Backup file, so may be...