Re: Move System and User database

From: Kenneth (Kenneth_at_discussions.microsoft.com)
Date: 02/06/05 

Date: Sun, 6 Feb 2005 06:55:02 -0800

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
>
>
>

Relevant Pages

  • Re: Error running Copy Database Wizard (CDW)
    ... I am not sure why the error but why not simply do a restore or an attach ... Issues When a Database Is Moved Between SQL Servers ... > I am using the Copy Database Wizard to copy a database from one SQL ...
    (microsoft.public.sqlserver.tools)
  • Re: DBCC SHRINKFILE + SHRINKDATABASE
    ... Andrew, ... brains behind the operation and the budget decided on one massive disk, ... > Issues When a Database Is Moved Between SQL Servers ...
    (microsoft.public.sqlserver.server)
  • Re: tried dts copy of tables stored procedures etc and it fails exery time
    ... all its objects I would just either restore a full backup or use ... Issues When a Database Is Moved Between SQL Servers ... >, i don't have much expierience with sql 7 data base minuplation, can ...
    (microsoft.public.sqlserver.security)
  • Re: Error 15022: The specified user name is already aliased.
    ... The number of orphaned users fixed by updating users was 0. ... Is it because the ID is already aliased in the database? ... > Issues When a Database Is Moved Between SQL Servers ...
    (microsoft.public.sqlserver.security)
  • Re: question -- copy database?
    ... > Passwords Between SQL Servers ... > Issues When a Database Is Moved Between SQL Servers ... and have SS recognize the database? ...
    (microsoft.public.sqlserver.dts)