How to Restore a complete Backup to a newer version of SQL Server -- sql server new users

mschultz
6/28/2006 6:05:03 PM

I would like to restore the master database from "Microsoft SQL Server
2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c)
1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.0
(Build 2195: Service Pack 4)" which is running on W2K to "Microsoft SQL
Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright
(c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2
(Build 3790: Service Pack 1) " which is running on W2K3.

Please could anyone advise the procedure to do this.

Mike Hodgson
6/29/2006 12:00:00 AM

I don't think you can since SP4 changes a bunch of stuff in master. So,
if you restore a SP3 master DB to a SP4 instance then you're "undoing"
some of the service pack. The only way I can think of doing this, off
the top of my head, is by restoring the SP3 master DB on another SP3
instance and then applying SP4 to that instance thereby making it an SP4
master DB that essentially has the same make-up as your original SP3
master DB.

--
*mike hodgson*
http://sqlnerd.blogspot.com

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server new users

sql server new users : How to Restore a complete Backup to a newer version of SQL Server