Re: moving databases..

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 07/17/03 

Date: Thu, 17 Jul 2003 14:43:33 -0400

Yes backing up everything is essential but maybe these links will spark some
thoughts:

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://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
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://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a 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 

-- 
Andrew J. Kelly
SQL Server MVP
"KP" <itsme@itsme.net> wrote in message
news:08b801c34c8d$c3a27710$a001280a@phx.gbl...
> Hi Friends,
> I am trying to replace the old hardware & moving existing
> applications to new servers. The old server has sql server
> installed with couple databases which are being used by
> ASP applications with ODBc connections. What are the
> precautions that I need to take care of before I start
> moving the databases & asp application to new hardware.
>
> thanks in advance.
>
> KP

Relevant Pages

  • Re: Backing up my SQL 2000 trial edition
    ... http://www.databasejournal.com/features/mssql/article.php/3379901 Moving ... http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases ... Restore ... for SQL Server ...
    (microsoft.public.sqlserver.setup)
  • Re: Move DB File Locations - SQL 05
    ... there's no particular performance gain in moving system ... The procedure for moving system databases in SQL Server 2005 is documented ...
    (microsoft.public.sqlserver.setup)
  • Re: Created default db onto wrong drive... need to move/create on
    ... like sp's and DTS packages are stored in the databases themselves and will ... >> http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs ... >> for SQL Server ...
    (microsoft.public.sqlserver.setup)
  • Re: moving data in a database to another file on a SAN
    ... Will that work if SQL Server is not moving, ... If I move the data from the D drive to the E drive (on the SAN), will I be able to delete the file on the D drive in database/properties/data files? ... > Moving SQL Server Databases ...
    (microsoft.public.sqlserver.server)
  • Re: Access 97 to a more powerfull platform!?
    ... Moving to SQL Server is common when a database "outgrows" ... Design problems are far and away the usual reason why a database ...
    (microsoft.public.access.gettingstarted)
Loading