Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

sql 2000 Enterprise RTM upgrade to 3a Expand / Collapse
Author
Message
Posted Thursday, October 21, 2010 2:40 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, January 21, 2011 7:26 PM
Points: 65, Visits: 450
Hi,

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,

Wallace

Post #1008245
Posted Thursday, October 21, 2010 6:25 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 3:19 PM
Points: 5,974, Visits: 12,874
the 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?



---------------------------------------------------------------------

Post #1008384
Posted Thursday, October 21, 2010 7:17 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, January 21, 2011 7:26 PM
Points: 65, Visits: 450
george sibbald (10/21/2010)

Only the system databases have to be the exact same release level.



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,
Wallace
Post #1008449
Posted Thursday, October 21, 2010 7:28 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 3:19 PM
Points: 5,974, Visits: 12,874
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.


---------------------------------------------------------------------

Post #1008461
Posted Thursday, October 21, 2010 7:39 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, January 21, 2011 7:26 PM
Points: 65, Visits: 450
george sibbald (10/21/2010)
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.


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,
Wallace
Post #1008473
Posted Thursday, October 21, 2010 9:23 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 3:19 PM
Points: 5,974, Visits: 12,874
the backups are only taken just in case you need to back the upgrade out.

---------------------------------------------------------------------

Post #1008584
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse