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 «««1234

Upgrading a Database SQL 2000 to SQL 2005 Expand / Collapse
Author
Message
Posted Wednesday, August 26, 2009 5:49 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 26, 2009 5:48 PM
Points: 2, Visits: 24
How do I determine if I have full-text search on SQL 2000 instance? I am getting this message with the upgrade advisor
"Upgrading will cause Full-Text Search to use instance-level, not global, word breakers and filters by default."
Post #777975
Posted Thursday, October 8, 2009 7:59 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, March 27, 2012 11:05 AM
Points: 3, Visits: 38
Hi SQL,

We'll be upgrading from 2000 to SQL 2005 (in place) in a couple weeks and I have two questions.
1) We have ~240 db's totalling 530 GB of data, Any idea what kind of timeline we'll be looking at once the upgrade begins? Is there a rough GB/Min upgrade rate?
2) Second question, I figure updating the statistics after the upgrade completes could be quite lenghty, again any idea on whether we could be looking at 1 hour 10 hours?

Thanks,
Sp
Post #800024
Posted Monday, January 25, 2010 8:41 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 13, 2014 6:32 AM
Points: 155, Visits: 184
http://msdn.microsoft.com/en-us/library/ms188414.aspx

One thing to keep in mind, after upgrade from SQL 2000 to SQL 2005 or SQL 2008, it is best to run the following:

DBCC UPDATEUSAGE (0);
GO


this will prevent certain system functions and procedures (i.e. sys.spaceused or sysindexes) from returning an error.

example: A user runs select * from sysindexes (which I know is legacy, but some of us still reference these as we are too lazy to update our code). The following error is returned...

Attempting to reference database fragment 1 in database 'foo' which does not exist. Contact Technical Support.

Now run the following against the database:

1. dbcc checkdb to make sure you don't have a consistancy issue
2. If dbcc checkdb returns an error indicating an allocation unit ID error, run dbcc updateusage(0)

You may also find you get this same error on a database snapshot. I haven't found that there is anything you can really do since the DB Snapshot is read only. your best bet is to simply drop the database snapshot when you are done with it.
Post #853051
Posted Wednesday, July 21, 2010 3:28 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, October 24, 2013 9:26 AM
Points: 13, Visits: 122
Yes, I agree with sachin
Post #956800
Posted Monday, September 13, 2010 10:26 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, June 4, 2014 8:21 AM
Points: 10, Visits: 65
hi,

can u plz give me the script for deleting full text indexes while upgrading 2000 to 2005

Regards,
Jayapal
Post #985222
Posted Wednesday, November 3, 2010 1:21 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 21, 2011 8:04 AM
Points: 4, Visits: 36
Hi,


how to do side-by-side upgrade from sql server 2000 to sql server 2008 R2.

Asking for username and password while doing it, which username and password should be used?
Post #1015526
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse