Re: moving to a new server

From: ChrisR (bla_at_noemail.com)
Date: 12/14/04


Date: Tue, 14 Dec 2004 09:34:36 -0800

Perfect! Thanks.

"Sasan Saidi" <SasanSaidi@discussions.microsoft.com> wrote in message
news:B400D908-0407-4925-BAD1-3493A1E6A8DB@microsoft.com...
> I hope this will help as a reference (from Andrew J. Kelly):
>
> 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
>
> http://www.support.microsoft.com/?id=274463 ; Copy DB Wizard
issues
>
> Sasan Saidi
> MSc. CS, MCSE 4, Certified IBM MQ Administrator
> Senior DBA
> Brascan Business Services
>
>
> "ChrisR" wrote:
>
> > I need to move my Production SQL box to a new box, in a new domain, with
a
> > new name for the box itself. Can someone point me to a white paper for
this?
> > I've done alot of stuff similar to this, but theres enough differences
here
> > make me nervous.
> >
> > --
> > SQL2K SP3
> >
> > TIA, ChrisR
> >
> >
> >



Relevant Pages

  • Re: Error running Copy Database Wizard (CDW)
    ... I am not sure why the error but why not simply do a restore or an attach ... Issues When a Database Is Moved Between SQL Servers ... > I am using the Copy Database Wizard to copy a database from one SQL ...
    (microsoft.public.sqlserver.tools)
  • Re: Move logins with passwords
    ... > Passwords Between SQL Servers ... > Issues When a Database Is Moved Between SQL Servers ... >> Regards Magnus ...
    (microsoft.public.sqlserver.security)
  • Re: Setting up Test of database using backup/restore
    ... Thanks Andrew...I have seen the references in your other posts but I just ... will the two be in production at one time, ... > I would go for the restore of the latest FULL backups as the least ... > Issues When a Database Is Moved Between SQL Servers ...
    (microsoft.public.sqlserver.server)
  • Re: How to cpy logins from one Server to another
    ... > to a New Location with Detach/Attach ... > Passwords Between SQL Servers ... > Issues When a Database Is Moved Between SQL Servers ...
    (microsoft.public.sqlserver.security)
  • RE: Moving databases to new server
    ... Restore http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to ... When a Database Is Moved Between SQL Servers ...
    (microsoft.public.sqlserver.server)

Loading