Re: Moving SQL to a new server.
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 03/31/04
- Next message: Hugo Kornelis: "Re: Create a index on two tables?"
- Previous message: Ollie2308: "dynamic sp build"
- In reply to: Tom Furness: "Moving SQL to a new server."
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 31 Mar 2004 21:14:11 +0200
A few links...
Moving SQL Server Databases
http://www.support.microsoft.com/?id=224071
Moving Databases between Servers
http://www.support.microsoft.com/?id=314546
Using WITH MOVE in a Restore to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465
How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=246133
Mapping Logins & SIDs after a Restore
http://www.support.microsoft.com/?id=298897
Utility to map users to the correct login
http://www.dbmaint.com/SyncSqlLogins.asp
How to Resolve Permission Issues When a Database Is Moved Between SQL Servers
http://www.support.microsoft.com/?id=240872
User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
Disaster Recovery Articles for SQL Server
http://www.support.microsoft.com/?id=307775
-- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp "Tom Furness" <TFurness@simon.com> wrote in message news:exrki%230FEHA.692@TK2MSFTNGP09.phx.gbl... > Hi, > I was reading another thread about copying SQL server databases and logins > to a new server. I too am going to have to move a sql instalation to a new > server. My question(s) is > What about Jobs, DTS packages, Linked Servers, etc? > > Is this not a common thing that people do? Move everything to a new box? > (would Norton ghost be an option?) > Is there a single solution?(CDW or somthing) or do you have to address each > item(databases,jobs,dts,etc.) individually? How about a place to read about > this kind of activity? > > I would think that sooner or later everyone moves an installation to a new > box? > > Thanks for any advice you can give me! > > Tom > > >
- Next message: Hugo Kornelis: "Re: Create a index on two tables?"
- Previous message: Ollie2308: "dynamic sp build"
- In reply to: Tom Furness: "Moving SQL to a new server."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
