Restore SQL 2000 DB in SQL 2005

Question

Restore SQL 2000 DB in SQL 2005

ssa2010

Old Hand

Points: 365
More actions
February 7, 2012 at 4:23 am

#145027

friends,
If any problems when restore sql 2000 db in sql 2005
and
Please explain the issues faced when we upgrade sql 2000 db to sql 2005

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

spaghettidba SSC Guru Points: 105732 More actions · Answer 1

No issues AFAIK.

Keep in mind this is a one-way path: you will not be able to restore the database in SQL 2000 from a backup set taken in SQL 2005.

Hope this helps

Gianluca

-- Gianluca Sartori

Ron McCullough SSC Guru Points: 63877 More actions · Answer 2

I suggest you read the following before upgrading.

http://msdn.microsoft.com/en-us/library/ms144267(v=sql.90).aspx

And understand the effect of the upgraded database by reading about the compatability mode at:

http://msdn.microsoft.com/en-US/library/ms178653(v=sql.90)

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 3

Nope, not a single issue at all. Great way to do the upgrade. I've done... oh, a whole bunch that way.

However, you should run the Upgrade Advisor first because there are things that can create problems for you. Find them out before hand.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Perry Whittle SSC Guru Points: 234013 More actions · Answer 4

ssa2010 (2/7/2012)
friends,
If any problems when restore sql 2000 db in sql 2005
and
Please explain the issues faced when we upgrade sql 2000 db to sql 2005

No issues apart from maybe the compatability level. After the upgrade upgrade has completed, ensure you run

DBCC UPDATEUSAGE

and

DBCC CHECKDB() WITH ALL_ERRORMSGS, NO_INFOMSGS, DATA_PURITY

You'll also want to check the indexes and stats are up to date too.

After this you can then sort out any orphan users

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

"Ya can't make an omelette without breaking just a few eggs" 😉