Re: Move System and User database
From: James (anonymous_at_discussions.microsoft.com)
Date: 02/07/05
- Next message: Andrew J. Kelly: "Re: Cannot associates files with different databases - Please Help .... Boss is getting pi$$ed!!"
- Previous message: Johnny Wright: "Cannot associates files with different databases - Please Help .... Boss is getting pi$$ed!!"
- In reply to: Kenneth: "Re: Move System and User database"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 6 Feb 2005 18:23:19 -0800
Hi Ken
well there are times when one just has to move their
entire SQL server install to a new box - such as a server
upgrade
the article below may shed some light on the principles
and procedures involved to accomplish what you are trying
to do
http://vyaskn.tripod.com/moving_sql_server.htm
cheers
James
>-----Original Message-----
>Andrew, Thanks for your reply!
>
>I've already read through these documents.
>However, I wonder what will I miss if I move all data
including SYSTEM
>database to new server.
>any problem with that?
>
>besides, will the sa password be moved to the new server
if system database
>moved? if not where the sa password stored?
>
>Thanks for any advice
>
>"Andrew J. Kelly" wrote:
>
>> That is never a good idea. Check these out:
>>
>> 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
>>
>>
>> --
>> Andrew J. Kelly SQL MVP
>>
>>
>> "Kenneth" <Kenneth@discussions.microsoft.com> wrote in
message
>> news:D1EB32EB-A2F6-465D-978E-
58F96DB228F9@microsoft.com...
>> > Dear All,
>> >
>> > Is it possible to move system(master, model, msdb and
so on...) and user
>> > database to another sql server by just copying all
ldf and mdf files in
>> > data
>> > directory while the sql on the source server is down?
>> >
>> > Any problem using this method instead of backup and
restore?
>> > as I don't want to detach the database from source
server.
>> >
>> > Thanks for any advices
>> > K
>>
>>
>>
>.
>
- Next message: Andrew J. Kelly: "Re: Cannot associates files with different databases - Please Help .... Boss is getting pi$$ed!!"
- Previous message: Johnny Wright: "Cannot associates files with different databases - Please Help .... Boss is getting pi$$ed!!"
- In reply to: Kenneth: "Re: Move System and User database"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
