I backed a MSSQL2000 database into a BAK file. Now when I create a
MSSQL2005 system and I goto RESTORE - after creating a database with the
same name- I get
"ERROR the backup set holds a database other than the existing "Toxinet'
database. RESTORE DATABASE is terminating abnormally"
Any ideas? This process has always worked in MSSQL97 & 2000
Thanks,
Raul Rego
NJPIES
rrego@.njpies.orgHi Raul
From your limited information, it sounds like the name in the backup is not
what you think it is.
You don't have to create a database before doing a restore. Why don't you
just try restoring and letting the restore process create the database.
Perhaps there is a spelling issue or you have a case sensitive collation.
BTW, there was no MSSQL97. The version before SQL Server 2000 was SQL Server
7.
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://blog.kalendelaney.com
"Raul" <rrego@.njpies.org> wrote in message
news:BCE20BE9-3480-43A4-9B44-C6A0F628B38A@.microsoft.com...
>I backed a MSSQL2000 database into a BAK file. Now when I create a
>MSSQL2005 system and I goto RESTORE - after creating a database with the
>same name- I get
> "ERROR the backup set holds a database other than the existing "Toxinet'
> database. RESTORE DATABASE is terminating abnormally"
> Any ideas? This process has always worked in MSSQL97 & 2000
> Thanks,
> Raul Rego
> NJPIES
> rrego@.njpies.org
>|||Use the "with replace" clause.
--
Jason Massie
www: http://statisticsio.com
rss: http://feeds.feedburner.com/statisticsio
"Raul" <rrego@.njpies.org> wrote in message
news:BCE20BE9-3480-43A4-9B44-C6A0F628B38A@.microsoft.com...
>I backed a MSSQL2000 database into a BAK file. Now when I create a
>MSSQL2005 system and I goto RESTORE - after creating a database with the
>same name- I get
> "ERROR the backup set holds a database other than the existing "Toxinet'
> database. RESTORE DATABASE is terminating abnormally"
> Any ideas? This process has always worked in MSSQL97 & 2000
> Thanks,
> Raul Rego
> NJPIES
> rrego@.njpies.org
>
Showing posts with label mssql2005. Show all posts
Showing posts with label mssql2005. Show all posts
Sunday, March 11, 2012
Saturday, February 25, 2012
copying
how do I copy databases from mssql2000 to mssql2005? they're both on the
samr subnet.
thanks,
Raul Rego
NJPIES
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
>
>
|||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...[vbcol=seagreen]
> 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:
|||Right click on the 2005 database and select "Import"...
"Raul" wrote:
> 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...
>
>
|||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...
>
)
|||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:
> 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
samr subnet.
thanks,
Raul Rego
NJPIES
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
>
>
|||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...[vbcol=seagreen]
> 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:
|||Right click on the 2005 database and select "Import"...
"Raul" wrote:
> 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...
>
>
|||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...
>
)
|||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:
> 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
copying
how do I copy databases from mssql2000 to mssql2005? they're both on the
samr subnet.
thanks,
Raul Rego
NJPIESdetach 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
>
>|||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...[vbcol=seagreen]
> 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:
>|||Right click on the 2005 database and select "Import"...
"Raul" wrote:
> 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 i
n
> message news:8D882740-10C5-474F-B42F-2CA3DBAAE116@.microsoft.com...
>
>|||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...
>
)|||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:
> 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
samr subnet.
thanks,
Raul Rego
NJPIESdetach 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
>
>|||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...[vbcol=seagreen]
> 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:
>|||Right click on the 2005 database and select "Import"...
"Raul" wrote:
> 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 i
n
> message news:8D882740-10C5-474F-B42F-2CA3DBAAE116@.microsoft.com...
>
>|||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...
>
)|||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:
> 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
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
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
Subscribe to:
Posts (Atom)