Patrick -

See http://www.emcinsignia.com, it sounds like you're running the SQL Server add on (http://www.emcinsignia.com/products/smb/retroforwin/addons/) and something is wrong with the agent.

Joe

Bhavin -

Can you give us a little more information about your "critical" database? 

How big is it?

What is your tolerance for data loss (e.g. 1 day, 1 hour, 15 minutes)?

Where...

Jai -

FTP is inherently insecure and has been replaced by SFTP (secure FTP) where security of the transmitted files is important.

There are a variety of SFTP clients and SFTP servers available. ...

One thing to check would be the settings for default database location... if someone has changed those that might explain why your database got created where it did - if...

Check your stored procedure for required vs. optional parameters.  Any parameter that does not have a default value assigned requires that the parameter be "filled in"

For example:

create procedure uspSampleProc

I get the impression that your 2x8 machines have been running for some time with no problems until now?  If yes the first question would have to be "what has...

Check out http://www.red-gate.com/products/SQL_Backup/index.htm.  The lite version of the product may be what you're looking for.  Idera also has a nice product if a little more pricey than Red Gate's.

Oh geez, here comes trouble.  Do not walk, run(!) to engage a virtualization/consolidation partner.  There are so many landmines along the path of consolidation/virtualization that I can't even begin to...

Before choosing litespeed take a look at Idera and Red Gate's products as well.  The litespeed product is priced per processor (unless they've changed recently) where the others are priced...

Not sure if it's relevant but have you looked at the underlying storage subsystems?  "SEMAPHORE WAIT" could very well indicate that you've got an disk I/O problem or other hardware...

Rob -

Your BCP command should look something like bcp sourcedatabase..sourcetable (or query) out targetfilename -S hostname...

Try using various options for the hostname.  Assuming you're running on the same machine as SQL...

If I'm reading the question correctly your complaint is that it's taking BCP 1 minute and 20 seconds to run regardless of the number of records?

A couple of things I...

It's probably not the Domain Controller reboot that's killing you, it's the Exchange Server.  If the DC and Exchange Server are one and the same, that's your "why".

You'll see this...

Bryan -

With the assumption that this is an internet hosting provider, not a corporate or other environment where restrictions might be mandated by SOX or other mandate, you have every...

Take a look at the datediff() function.

Joe