You can also consider Adhoc queries. For basic information visit my blog post http://blog.dbdigger.com/2008/09/accessing-remote-data-source-linked.html

For beginning from basics and having a thorough study http://msdn.microsoft.com/en-us/library/ms159106.aspx

As it is given there without any associated condition that 'delete files older than X days.', so i think older files will be deleted in case of failure. But...

I would suggest to generate script through generate scripts wizard. it is excellent for such migration tasks.

Jeffrey Williams (4/15/2009)

---

If you have the delete task execute before the backup - the files will be deleted and then the backup will run. If the backup then fails,...

Please visit the link http://msdn.microsoft.com/en-us/library/3zwz4dx3.aspx

Please visit http://msdn.microsoft.com/en-us/library/ms189586%28SQL.90%29.aspx

Read-ahead schemes enable applications to minimize the number of database round trips by retrieving a working set prior to use.

I would suggest not to create relations among tables in archival database. Time stamps for archived data will matter and new primary keys will be required other than those of...

As a broad picture you may consider following lines,

figure out the tables required to archive.

After that there may be columns filtration process for the selected tables to include...

Archival database are mostly created to preserve a historical snapshot of production data. Production databases are meant to change rapidly, so organizations mostly develop archival plans where specific data from...

I would just add that delete operation is recorded in transaction log for each row but that is not the case with truncate. So while using delete statement it...

Did you use 64 bit version of SQL Server on your 64 bit OS, or there is some other configuration?

Archived databases have different priorities than production databases. It would not be a good idea to use same database for archival and production. Even you would have to make certain...

Technology related professionals are often with less chances to go to meet some one at home and to regularly meet or call old colleagues and class fellows dispersed at various...