copying

how do I copy databases from mssql2000 to mssql2005? they're both on the
samr subnet.
thanks,
Raul Rego
NJPIESdetaching the database will be difficult as we run a medical hotline which
is all 24hr/day.
How can I migrate the data?
Thanks,
Raul Rego
"FrancoisViljoen" <francoisv at dev dot barloworldoptimus dot com> wrote in
message news:8D882740-10C5-474F-B42F-2CA3DBAAE116@.microsoft.com...
> detach database from 2000 server or stop 2000 server, copy to the new
> server
> and attach to 2005.
> You could also migrate the data, but it will take longer.
> "Raul" wrote:
>> how do I copy databases from mssql2000 to mssql2005? they're both on the
>> samr subnet.
>> thanks,
>> Raul Rego
>> NJPIES
>>|||Hello,
DO the below steps:-
1. Backup the SQL 2000 database using (Backup Database)
2. Copy the Backup file to destination server
3. Restore the database using Restore database command.
This will automaticaklly upgrade the SQL 2000 database to SQL 2005.
Thanks
Hari
"Raul" <jjkgr@.hotmail.com> wrote in message
news:u36M5UMMHHA.2236@.TK2MSFTNGP02.phx.gbl...
> detaching the database will be difficult as we run a medical hotline which
> is all 24hr/day.
> How can I migrate the data?
> Thanks,
> Raul Rego
> "FrancoisViljoen" <francoisv at dev dot barloworldoptimus dot com> wrote
> in message news:8D882740-10C5-474F-B42F-2CA3DBAAE116@.microsoft.com...
>> detach database from 2000 server or stop 2000 server, copy to the new
>> server
>> and attach to 2005.
>> You could also migrate the data, but it will take longer.
>> "Raul" wrote:
>> how do I copy databases from mssql2000 to mssql2005? they're both on
>> the
>> samr subnet.
>> thanks,
>> Raul Rego
>> NJPIES
>>
>
)|||Raul wrote:
> how do I copy databases from mssql2000 to mssql2005? they're both on the
> samr subnet.
> thanks,
> Raul Rego
> NJPIES
>
Fastest and simplest way is to BACKUP the database on the 2000 server,
then RESTORE it to the 2005 server. Note that this doesn't work in
reverse - you can't restore a 2005 database back to 2000.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||If you have real time data synchronization needs I would look at
replication.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Raul" <jjkgr@.hotmail.com> wrote in message
news:utSV75LMHHA.4244@.TK2MSFTNGP04.phx.gbl...
> how do I copy databases from mssql2000 to mssql2005? they're both on the
> samr subnet.
> thanks,
> Raul Rego
> NJPIES
>|||"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:459E538F.9040408@.realsqlguy.com...
> Raul wrote:
>> how do I copy databases from mssql2000 to mssql2005? they're both on the
>> samr subnet.
>> thanks,
>> Raul Rego
>> NJPIES
> Fastest and simplest way is to BACKUP the database on the 2000 server,
> then RESTORE it to the 2005 server. Note that this doesn't work in
> reverse - you can't restore a 2005 database back to 2000.
To add to this, you may have to do something like the following:
Backup 2000 copy
Restore to 2005 box WITH NORECOVERY
Backup 2000 Transaction LOG
Restore to 2005 box WITH NORECOVERY
Depending on how long the full and log backup/restores take you may want to
repeat the cycle of log backup/restores until you're down to a minimal
amount of time.
Then finally kick everyone off of the 2000 box.
One last 2000 log backup
Stop 2000 Server
restore to 2005 box with NORECOVERY
Make sure you haven't missed anything or skipped anything
Restore 2005 box WITH RECOVERY.
You can do the "switch over" in under a minute in some cases, especially if
you script it all.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com