Please consider the following scenario
I have sql 7 NT server the application is on the C:\
and the databases are stored on a external drive array
i.e D:\
What i want to do is migrate the external drive array
from the above server to a new sql7 NT server of higher
spec.
Has anyone attempted this before or any ideas on how to
do this. I believe that i will have to start sql in
single user mode after the arrray is attached and run a
attach comand within query analyzer.
Any help would be much appreciated.You won't have to start the server in single-user mode... But you will have
to put the database in single-user mode to detach it (if that's how you
choose to get it over to the new server.) Your options are to detach it
from the old server, copy it, and re-attach it, or back it up and restore it
on the new server... Pretty much equivalent options except that backup will
double the disc space required (as you will have the database files as well
as the backup file to deal with); detach/attach, on the other hand, will
require you to A) put the database into single-user mode, and B) take it
offline while you copy the files, which you will not have to do with a
backup. So weigh your options carefully...
"Jonathan Gray" <jonathan.gray@.exel.com> wrote in message
news:0dbc01c3adda$7e102950$a101280a@.phx.gbl...
> Please consider the following scenario
> I have sql 7 NT server the application is on the C:\
> and the databases are stored on a external drive array
> i.e D:\
> What i want to do is migrate the external drive array
> from the above server to a new sql7 NT server of higher
> spec.
> Has anyone attempted this before or any ideas on how to
> do this. I believe that i will have to start sql in
> single user mode after the arrray is attached and run a
> attach comand within query analyzer.
>
> Any help would be much appreciated.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment