InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 04:01:42 GMT20http://www.sqlservercentral.com/Forums/Topic1008245-48-1.aspxthe backups are only taken just in case you need to back the upgrade out.Thu, 21 Oct 2010 09:23:22 GMTgeorge sibbaldhttp://www.sqlservercentral.com/Forums/Topic1008245-48-1.aspx[quote][b]george sibbald (10/21/2010)[/b][hr]backup all of them. (except tempdb - this cannot be backed, it is recreated on each sql restart)there is no need to restore any databases after an upgrade.[/quote]If I need to backup all system databases so is there any case that need to restore old system database after upgrade? Is there any purpose that I need to backup those system databases as well?Thanks and regards,WallaceThu, 21 Oct 2010 07:39:06 GMTChan Wai Yinhttp://www.sqlservercentral.com/Forums/Topic1008245-48-1.aspxbackup all of them. (except tempdb - this cannot be backed, it is recreated on each sql restart)there is no need to restore any databases after an upgrade.Thu, 21 Oct 2010 07:28:24 GMTgeorge sibbaldhttp://www.sqlservercentral.com/Forums/Topic1008245-48-1.aspx[quote][b]george sibbald (10/21/2010)[/b][hr]Only the system databases have to be the exact same release level.[/quote]Do I need to backup and restore those system databases(master, msdb, model, tempdb etc) when I upgrade from RTM to SP3a? or only backup and restore our user database is enough?Thanks and regards,WallaceThu, 21 Oct 2010 07:17:14 GMTChan Wai Yinhttp://www.sqlservercentral.com/Forums/Topic1008245-48-1.aspxthe upgrade process will upgrade your user database as well.You will be able to restore your RTM backup post the upgrade. As long as its the same version of SQL (i.e. SQL2000) it will restore. Only the system databases have to be the exact same release level.By the way, there is a SP4 for SQL2000, any reason you cannot use that?Thu, 21 Oct 2010 06:25:11 GMTgeorge sibbaldhttp://www.sqlservercentral.com/Forums/Topic1008245-48-1.aspxHi,We plan to upgrade existing sql server enterprise 2000 RTM to SP3a(Chinese Traditional). Since we want to keep all the data after upgrading, can we use the original database backup(RTM) and restore to new version(Sp3a) without any error?P.S: The RTM database backup have only basic item such as table, storeproc, index, without any replication items.Thanks and regards,WallaceThu, 21 Oct 2010 02:40:30 GMTChan Wai Yin