another method is to detach the database, copy the .mdf and .ldf files to their new location and then attach them.
THANK YOU SUSHILA!!!
>>Rats - I just spent the last half an hour typing out the various steps - only to have the whole text "vanish" - ctrl z isn't bringing it back to life either <<
I have had this happen several times and have yet to figure out why. I've taken to saving my reply in Notepad before clicking "Post Reply" or "Preview." This is an irritation, but not as bad as losing several minutes of work (and carefully crafted brilliance ).
I thank you for confirming the event. I thought I was just experiencing premature 'old timers' disease and losing my way around the form. This is an inconsistent, irritating, recurring problem. I would love to take the time to figure out what is going on, but as we all know, time is in short supply in our field these days. Hence the long diatribe and the continued popularity of this forum!
I love your refreshing use of 'apparitional.' Proficiency in and appreciation of grammar, syntax, and non-technical vocabulary is somewhat rare in IT.