Sergey,
PMFJI,
If you copy a database, without detaching, will you be able to attach it? Recently I a customer send me a database and I attached it to my SQL server. All worked. But when I asked him what he did, he said "I just copied the database to CD."
>You can detach database, copy it to the destinaton server and attach it.
>
>>
>>I want to move several databases from a NT 4 machine thats running SQL7 databases to Windows 2000 machine running SQL7.
>>
>>Would the easiest way to move the databases be a backup and restore or something like a backup and reattach?
>>
>>Please point me to a link to get these instructions.
>>
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham