RE: moving to a new server

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Sasan Saidi (SasanSaidi_at_discussions.microsoft.com)
Date: 12/14/04 

Date: Tue, 14 Dec 2004 08:07:07 -0800

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: How to upgrade MSDE databases to SQL Server Databases
    ... First however we are going to permute the install sequence on a 'web ... farm' parameter and then permute a server target on the WSS Web Admin ... between Microsoft Access, MSDE, SQL Server Express and SQL Server databases. ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Backup issues after changing administrator name
    ... I set the relevant sql server databases to simple and ... You back up data from a volume that contains a Microsoft SQL Server ... > As creating the volume shadow copy failed, the open files shown in the log ... > CSS (Customer Support Service) for the following hot fix. ...
    (microsoft.public.windows.server.sbs)
  • Re: Restoring sql server database from one server to another from a ba
    ... http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases ... Errors After Restoring Dump ... for SQL Server ...
    (microsoft.public.sqlserver.server)
  • Potential issue with DTS and Log Shipping
    ... My set up involves three SQL Server Databases. ... copy of first via log shipping. ... have a DTS packagage that that copys select ...
    (microsoft.public.sqlserver.dts)
  • Re: web services
    ... SQL Server databases are usually connected to using TCP/IP, ... ..Net Developer ... without web services, or I have to use web services? ...
    (microsoft.public.dotnet.framework.aspnet)