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

database migration problem? Expand / Collapse
Author
Message
Posted Tuesday, December 2, 2008 2:18 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, January 22, 2014 3:43 AM
Points: 131, Visits: 558
Hi Dear all,

I doing database migration of my 2000 server to 2005, some what i have done sucessfully. But i stuck when i migrating my database from 2000 server to 2005. I want to migrate all database including dts packages, jobs, and all thats related to my database.
For doing migration i have gone through this steps,
1- Run upgrade advisor
2- Migrated DTS packages (completed)
3- Edit DTS packages in SSIS (completed)
4- Recreated Jobs (completed)
5- Database migration. (problem while doing the migration of database, not connecting to the source server, i also tried to copy database wizard, when it complete its showing one error of analysis services and log file its showing the adress of the databases, when i checked the destination folder there is no databases are present.)

If i wrong in this steps then please help me out. If u know steps how to do please help me. And please dont give me links because here some links are restricted, that will not open. So please send me the steps in this blocks only.

Thanks in advance.
Sorry for my bad english.

Rgrds,
m.i.


________________________________________
M.I.

Learning is a path with no destination...

Post #611888
Posted Tuesday, December 2, 2008 2:49 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 2:25 AM
Points: 42,802, Visits: 35,917
Don't use the database migration wizard. That's a really long way.

Take a backup of the SQL 2000 database and restore it on 2005. Once you're restored, rebuild all indexes and run a checkDB. You'll also have to migrate the logins across. SSIS's transfer logins should do that, just make sure that you copy the SID across or all the users will be orphaned.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #611907
Posted Tuesday, December 2, 2008 9:46 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 4:41 PM
Points: 4,065, Visits: 5,297
And please, please don't post the same question in multiple forums. It might seem like you'll get more responses, but it just wastes peoples time and spreads replies all over the forums.

Greg
Post #612176
Posted Tuesday, December 2, 2008 4:08 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, February 13, 2009 7:40 AM
Points: 1, Visits: 9
Hi - I'm having a similar problem. I'm trying to restore a sql2000 master db to a sql2005 installation on a totally different machine. What is the correct procedure? Both the sql2000 and sql2005 are on MS cluster. I start SQL 2005 in single user mode (sqlservr.exe -c -m) then try to restore the .bak of the sql2000 master db that I have. I get an error message that says "....the backup set holds a backup of a database other than the existing 'master' database." Can you please advise me? Thanks.
Post #612462
Posted Tuesday, December 2, 2008 5:45 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 4:41 PM
Points: 4,065, Visits: 5,297
You can't restore a backup of a system database (master, msdb, model) that was made in SQL 2000. See "Copying Databases with Backup and Restore" in BOL.

Greg
Post #612492
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse