Re: Migrating an SQL server to another machine
From: Paul (microsoftnews_at_knipsel.nl)
Date: 09/22/04
- Next message: Ian: "Transaction Deadlock Problem with Triggers. I have no idea???"
- Previous message: mat: "RE: Mystery Proccess"
- In reply to: Tibor Karaszi: "Re: Migrating an SQL server to another machine"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 22 Sep 2004 12:35:47 +0200
Thanks Tibor!
This will cetainly help!
Regards,
Paul
"Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote in
message news:OXnhJvIoEHA.3324@TK2MSFTNGP10.phx.gbl...
> One or more of below 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/
>
>
> "Paul" <microsoftnews@knipsel.nl> wrote in message
> news:%23CO5wfIoEHA.800@TK2MSFTNGP14.phx.gbl...
>> Hello,
>>
>> I have to migrate SQL 200o from an NT4 to a 2003 machine. I would like to
>> keep al the settings/users/databases intact.
>>
>> How could this be acomplished?
>>
>> Kind regards,
>>
>>
>> Paul.
>>
>>
>>
>>
>
>
- Next message: Ian: "Transaction Deadlock Problem with Triggers. I have no idea???"
- Previous message: mat: "RE: Mystery Proccess"
- In reply to: Tibor Karaszi: "Re: Migrating an SQL server to another machine"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
