It's a new database. I create the database, assigning the devices to separate spindles. I then try to do the restore using EM. I cancelled the restore when I realized...

That did the trick! Thanks for the quick response! Anywhere else I may have issues similar to this that you can think of?

Terry

Alter table will add/drop single fields. You can also use a temp table (create new table as tmp1, insert into tmp1 by selecting from original table, drop original then rename...

Thanks for your help. I'm so glad I found this site!!

Terry

One thing I failed to add, we're on SQL 7.0 sp2.

Terry

Actually, I'm not refering to transaction logs. I have my production db set to full recovery and dump the transaction logs hourly. I'm refering to the history logs, if you...

You can still use access to report off of "linked" tables. Crystal reports is a decent third party tool as well.

Terry Crosby

Found this little beauty on Swynk, maybe it'll help!

http://www.swynk.com/downloads/findbp.sql

Terry Crosby

What if they do plan on moving the MDF from one server to another???

Terry Crosby