THANKS much !!! (Yes, it isn't that large a database when you think about, compared to the others we have
on this system it is one of the largest).
Obviously I need to do a couple of practice restores on dummy databases to get this down.
My big concern was after 3 hours, and having no gauge as to how long it should take, trying to figure out how long restores really take on SQL Server. I know it depends on lots of variables, but my only previous experience is with Teradata, and those databases are HUGE, but it you have enough AMPs processing large DBs on those systems isn't a big deal.
Regards
randyv
Certified Teradata Master
and terrified SQL Server user