|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Move 2000 to 2005
I have a database in 2000 that I want to move to a 2005 server. What is
best way to do that? Backup and Restore doesn't work. Thanks. David "David" <dlch***@lifetimeinc.com> wrote in message It did for me. What were you trying to do?news:ebDzJ1RSGHA.792@TK2MSFTNGP10.phx.gbl... >I have a database in 2000 that I want to move to a 2005 server. What is >best way to do that? Backup and Restore doesn't work. Thanks. __Stephen I ran a full backup of the 2000 database, went to the 2005 server and tried
a restore entering the new database name. It gave me error 3219 which says "The file or filegroup 'LifeSQL_Log' cannot be selected for this operation." David Show quoteHide quote "_Stephen" <sruss***@electracash.com> wrote in message news:OAs6v9RSGHA.2300@TK2MSFTNGP11.phx.gbl... > > "David" <dlch***@lifetimeinc.com> wrote in message > news:ebDzJ1RSGHA.792@TK2MSFTNGP10.phx.gbl... >>I have a database in 2000 that I want to move to a 2005 server. What is >>best way to do that? Backup and Restore doesn't work. Thanks. > > It did for me. What were you trying to do? > > __Stephen > David wrote:
Show quoteHide quote > I ran a full backup of the 2000 database, went to the 2005 server and tried How did you do the restore? There are no problems in restoring a SQL > a restore entering the new database name. It gave me error 3219 which says > "The file or filegroup 'LifeSQL_Log' cannot be selected for this operation." > > David > > "_Stephen" <sruss***@electracash.com> wrote in message > news:OAs6v9RSGHA.2300@TK2MSFTNGP11.phx.gbl... > >>"David" <dlch***@lifetimeinc.com> wrote in message >>news:ebDzJ1RSGHA.792@TK2MSFTNGP10.phx.gbl... >> >>>I have a database in 2000 that I want to move to a 2005 server. What is >>>best way to do that? Backup and Restore doesn't work. Thanks. >> >>It did for me. What were you trying to do? >> >>__Stephen >> > > > 2000 database on SQL 2005 server. You can try to open a query window and then use RESTORE DATABASE specifying the MOVE option. That might do the trick for you. You can look up the exact RESTORE syntax in Books On Line. Regards Steen "David" <dlch***@lifetimeinc.com> wrote in message Was that drive available on the new machine? I had to go to the options of news:%23zL9BMSSGHA.5884@TK2MSFTNGP14.phx.gbl... >I ran a full backup of the 2000 database, went to the 2005 server and tried >a restore entering the new database name. It gave me error 3219 which says >"The file or filegroup 'LifeSQL_Log' cannot be selected for this >operation." the restore in 2005 and change drive letters and paths there that fit the newer server. HTH __Stephen That may be it. I never thought of that as the drives are different on the
2 servers. Also, can I do a sp_detach and sp_attach? Thanks. David Show quoteHide quote "_Stephen" <sruss***@electracash.com> wrote in message news:%23RPD5yTSGHA.4168@tk2msftngp13.phx.gbl... > > "David" <dlch***@lifetimeinc.com> wrote in message > news:%23zL9BMSSGHA.5884@TK2MSFTNGP14.phx.gbl... >>I ran a full backup of the 2000 database, went to the 2005 server and >>tried a restore entering the new database name. It gave me error 3219 >>which says "The file or filegroup 'LifeSQL_Log' cannot be selected for >>this operation." > > Was that drive available on the new machine? I had to go to the options > of the restore in 2005 and change drive letters and paths there that fit > the newer server. > > HTH > > __Stephen > > Also, can I do a sp_detach and sp_attach? Yes.-- Show quoteHide quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ Blog: http://solidqualitylearning.com/blogs/tibor/ "David" <dlch***@lifetimeinc.com> wrote in message news:uMfKzheSGHA.196@TK2MSFTNGP10.phx.gbl... > That may be it. I never thought of that as the drives are different on the > 2 servers. Also, can I do a sp_detach and sp_attach? Thanks. > > David > > "_Stephen" <sruss***@electracash.com> wrote in message > news:%23RPD5yTSGHA.4168@tk2msftngp13.phx.gbl... >> >> "David" <dlch***@lifetimeinc.com> wrote in message >> news:%23zL9BMSSGHA.5884@TK2MSFTNGP14.phx.gbl... >>>I ran a full backup of the 2000 database, went to the 2005 server and >>>tried a restore entering the new database name. It gave me error 3219 >>>which says "The file or filegroup 'LifeSQL_Log' cannot be selected for >>>this operation." >> >> Was that drive available on the new machine? I had to go to the options >> of the restore in 2005 and change drive letters and paths there that fit >> the newer server. >> >> HTH >> >> __Stephen >> > >  
Other interesting topics
expectations for SUM query on 50+ million rows
Deadlocks "again" IN clause with comma seperated values in select query Internal SQL Server error Page coruption Management Studio Question.... what kind of index to use in this situation. Add User to Log-Shipped Database Stored procedures in master database SQL Server 200/2005 deadlocked on lock |
|||||||||||||||||||||||
