Monday, March 19, 2012

moving sql server

Is there a tool awailable that can help me move databases, DTS packages and
logins from server A to server B?.
best regards
Trond
Not one tool that does all for you, at least not the best way. AFAIK. However,below links should get
you started:
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
http://www.solidqualitylearning.com/
"Trond Hoiberg" <hoeiber@.online.no> wrote in message news:%23Z3XodunEHA.2900@.TK2MSFTNGP09.phx.gbl...
> Is there a tool awailable that can help me move databases, DTS packages and
> logins from server A to server B?.
> best regards
> Trond
>

No comments:

Post a Comment