In the long run it might be beneficial to become familiar with what hits that database.  There might be tables that are relatively static and don't need to be hit. ...

The idea known as moral relativism (there are no absolute moral standards, right and wrong are what the individual decides) has brought us to this point in time.  Two jobs...

When you stop learning you're dead.

Consolidating to one large box is fine is if the applications those databases support are relatively stable. 

ON must really be certan that they will 'play well together'.

For what it is worth:

We recently finished merging data from another company into ours.  We are running SQL 2000 SP3 (IA64), 4 CPUs.  Our main db is 125 GB.  After reindexing,...

From Winston Churchill:

"We make a living by what we get, but we make a life by what we give."

Have a great weekend,

John L.

I have had folks come to me in a panic, but on more than one occasion, when I have tried to run a SELECT from sysprocesses in a new QA...

You do all you can do.  You give your best professional recommendation and let it go.

Failed projects are a group effort.  Total commitment to not only the end result but...

I'm sure that you've already considered this, but what about Profiler?

I don't know what limitations you might be under but that is one way to see what is hitting your...

Good points have been made.  However, auditors are in a position to attempt to define SOX however they wish.

Management must be bright enought to realize that that a 'success' criteria...

I confirmed today that the delete was indeed failing.  

You're right on target.  I should have posted the script and will for any future such posts.

Thanks again...

Guess I am missing something.  The BACKUP DATABASE portion of my script does not use either INIT or FORMAT.  The first step is an xp_cmdshell to delete the existing backup.... ...

Sushila,

My backup script, which I have used at a variety of sites, deletes the existing BAK file and then performs the Backup on the database.  My normal BAK size is 100 GB...

Mike,

That is exactly where I am headed...this weekend to be exact.

John Langston

Cimarex Energy Co.