My database server (Sql server2005)is having disk space problem and it contains some data which is not very important but it is huge in terms of size.The server have some extra space on D: drive .
To solve space issues, a job needs to be created that will move unused data from the data drives to D:
Please any body tell me how to move data using job to another drive (D: drive in my case )