Sounds OK. Couple questions

Where do backups go?

How much RAM to SQL Server?

Does the ERP system make heavy use of tempdb? Might need a R1 array for it and an R1...

As George mentioned, please post the code to let us see what is happening and then we can help.

Why would you set the recovery model to simple?

The above advice is correct. Log shipping requires logs to send to the destination server. If you move away from full...

Thanks. It was an interesting point that I hadn't seen made. And when I was in Redmond talking with the LINQ developers, I felt like they'd given up on that...

Thanks, must have cut and pasted the wrong query in there.

Corrected to be all.

Or CLR procedures. you can spawn threads inside one of those.

However why do you want to? You complicate things and if you have issues with your code, you could create...

You could use the data export wizard to create the files and then the data import wizard as well. It will create SSIS packages in the wizard that you can...

Vidhya has a good procedure. You can also detach the files, copy them with new names, and attach them to the new instance.

Note this doesn't move logins, so you might...

Log backups have nothing to do with full backups. that is why you need to take log backups in addition to full backups.

If you are in simple mode, there's nothing...

Is this VB6? Are you stepping through the code? Is this the same workstation that ran them from EM?

That message usually indicates a network level error, the server address is...

I think this is generally the case, though I do see some database developer positions at times and there are plenty of DBAs that do database development work and don't...

Haven't seen that. Is that the case with every maintenance plan you create?

Gail is correct. You need enough space to reindex, and if you shrink, you might undo all the efforts you've done in reindexing as a shrink might move things around.

Leave...

Please post the script. I understand you're a new DBA, but you're not giving us enough of a picture.

Can you log in as SA and try the job?

Anything that is...

It's not clear what you want. Please explain what you want to do, and break your sentences so we can understand the process you want to consider.

If you want to...