I would be more worried about the potential for blocking and locking that these intraday deletes may cause. My preference would always be to run the deletes during maintenance windows...

you should be able to restore it no problem and its collation will be maintained. The problems arise when you start querying or joining to other databases on the server...

do you put a cap on the amount of memory allowed for SQL in order to leave a fair wack for the OS? I recall seeing these errors not...

The way you list will work but there are few things you need to know before you commence:

* will the new hardware be renamed to the old server name?

* do...

Some db 'crashes' will generate dumps in SQL error log directory. All db crashes should be reported in the SQL event log.

A DBCC will pick up some formms of database...

How does the performance compare to native BCP OUT? should it be the same.

cheers

I would go with partitioned views. They are very effective for partition elimination in queries and are also great for data management. You'll need to plan your tables carefully...

FYI, BULK INSERT worked just fine:

BULK INSERT xxxx.dbo.xxxxxxxxfrom 'g:\mssql\backup\xxxxx.BCP'

WITH (DATAFILETYPE = 'native')

:w00t:

I tried that - still same error. There is no quotes in my data anyway. I had to resort to DTS which was much slower as I couldn't compress data...

in the Exchange business we have the concept of a Trading Calendar. All trading days are listed in this table going 10 years into the future with a coresponding incrementing...

Well done! Still the best SQL site by far........ Keep up the good work.

Alan Cranfield | DBA | Technology | NYSE Euronext

Agreed. We've now migrated the DB from that old DL740/6400 to a new DL580 G5 with P800 controllers.

cheers

Alan

actually, rebooting the server and disk shelves brought the database back.. Ha!

--cranfield

I spent years working with batch files, osql and server lists to retrieve info and execute code on multiple databases simultaneously.

Now I use Red-Gates Multi script. Its the most useful...

Thanks, Gail and Paul

I will prepare for the long and arduous rebuild of the database..

I think we've learned our lesson now with spanned volumes i.e. dont use them.

cheers

Alan Cranfield