Thursday, February 9, 2012

attach SQL 2000 DB files to 2005?

I have a couple large databases (20 databases, many GB of data in each).
the vendor has told me that their application will work fine with 2005,
but, I've not done the migration yet.
Is it as simple as a backup from 2000 /restore to 2005?
Can I detach the files for each DB and then just reattach them to the
2005 server?
Anyone done this before?
spam999free@.rrohio.com
remove 999 in order to email meAbsolutely! Backup and Restore is an excellent way to migrate the databases.
If you are using SQL Logins, you will also have to migrate the SQL Logins to
the new server.
These articles should help:
Moving Server/Database/Logins
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://msdn2.microsoft.com/en-us/library/ms345408(en-US,SQL.90).aspx Moving
system dbs 2005
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases to a
New Location with Detach/Attach
http://www.support.microsoft.com/?id=221465 Using WITH MOVE in a Restore
http://www.sqlservercentral.com/col...se
s.asp
Moving Users
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://support.microsoft.com/kb/274188 Troubleshooting Orphan Logins
http://www.support.microsoft.com/?id=240872 Resolve Permission
Issues -Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scr...sp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles for
SQL Server
http://www.support.microsoft.com/?id=320125 Moving a Diagram
http://www.sqlservercentral.com/scr...utions/1598.asp Script Roles
and Permissions
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Leythos" <void@.nowhere.lan> wrote in message
news:4582dde5$0$22165$4c368faf@.roadrunne
r.com...
>I have a couple large databases (20 databases, many GB of data in each).
> the vendor has told me that their application will work fine with 2005,
> but, I've not done the migration yet.
> Is it as simple as a backup from 2000 /restore to 2005?
> Can I detach the files for each DB and then just reattach them to the
> 2005 server?
> Anyone done this before?
>
> --
> spam999free@.rrohio.com
> remove 999 in order to email me|||In article <e5EkGDIIHHA.1240@.TK2MSFTNGP03.phx.gbl>, arnie@.1568.com
says...
> Absolutely! Backup and Restore is an excellent way to migrate the database
s.
> If you are using SQL Logins, you will also have to migrate the SQL Logins
to
> the new server.
Thanks, I already have several scripts to built user scripts that assign
and give access/permission to the databases. We manually restore
production to QA every night, but they are both SQL 2000.
Thanks again.
spam999free@.rrohio.com
remove 999 in order to email me

No comments:

Post a Comment