|
Posted by Arnie Rowland on December 15, 2006, 2:39 pm
If you were Registered and logged in, you could reply and use other advanced thread options
Absolutely! 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/columnists/cBunch/movingyouruserswiththeirdatabases.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/scripts/scriptdetails.asp?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/scripts/contributions/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
>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
| 
XML site map