By the way, check to see any Database Backups are running?

If not SQL Server Agent, may be any other scheduler (Windows Task Scheduler) is calling a Job which does...

Follow Jason's Suggestion that should work.

Implementing backups depends on what is the least amount of Data that you are ready to loose in case of a failure occurs. Once that is defined by you or...

If you choose transactional replication, my guess is you have no choice of controlling the replication after backups in the Nights etc.

The better way is to go with...

Those Files and Directories must be existing on the Server where SSIS Packages are deployed, check and you should find them.

I may give it a try if you can give the text file as attachment here, truncate the large portion of the data, so it can be a sample.

If the SourceType is a...

Transactional Replication is an option, there is no doubt about it.

Before configuring you need to figure out who is the distributor, since configuring local distributor would have some performance...

if i take a look at the properties the IsStoredProcedure property is set to false..

How can i find the execute Sql Tasks scripts?

Is there a place where i can...

The maintenance plan does a complete backup nightly and a transaction log nightly right after the complete backup (that's what I see in properties of my maint plan)

The optimization options(reorg...

I havent seen anything about create filegroups, files, partition function for "future storage".

I mean. I would like to know if I can create filegroups, files and partition function from now...

It looks like the SSIS Package was create without using the DataFlow task, the entire Data transfer must have been implemented in the Execute SQL tasks only, for which you...

Interesting question that I would try at my SQL Lab @ Home and update here, cannot test it in my work location.

PASS Summit

These are my inputs and am glad...