Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bogey
Posting Yak Master
166 Posts |
 Posted - 2006-03-30 : 09:27:06
|
| Has anyone done this upgrade on a production system? Are there any gotchas?thanks |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-03-30 : 09:51:14
|
| Nope. Just make sure you back up every database, including your system DBs (master, model, msdb). The following articles have excellent advice on all the little things you need to watch out for:http://www.sqlteam.com/item.asp?ItemID=9066http://www.sqlteam.com/item.asp?ItemID=9465I'd recommend not restoring the master database after you install the Enterprise edition. If you have added stored procedures and such to master you should script them out and add them manually afterwards. |
 |
|
|
|
|
|
Upgrade 2000 standard to enterprise