Restore databases into a new installation of SQL Server

From: Hai-Chu Hsu (seapearl1023_at_ms65.url.com.tw)
Date: 02/28/04 

Date: 28 Feb 2004 15:15:45 -0800

Hi,

I want to restore my databases from the old SQL Server installation
into a new installation of SQL Server. My new installation of SQL
Server has different data path from the old installation. In addition,
the data owners of some databases in the old SQL Server installation
are not dbo. I have backups for all the databases in the old
installation SQL Server.

Can anyone tell me how to restore my databases from the old SQL Server
installation into a new installation of SQL Server for my case? (I
want to use new path for data and log files as well as keep the old
data owners in the restored databases.) Do I need to perform restore
operation against my master database in the new installation of SQL
Server? (The data path for a newly created database has been changed
in the new installation of SQL Server.)

My idea is:
1. Create new databases whose names are the same with the databases of
the old SQL installation. Set the new databases with the new data path
I want.
2. Create new login accounts whose user names and passwords are the
same with the old login accounts. Assign appropriate permissions to
the new login accounts (e.g, the data owner for some database).
3. Use Enterprise Manager to perform restore operation against the
newly created databases using the backups from the old SQL Server
installation.

Please advice.

Hai-Chu

Relevant Pages

  • Re: Please answer my queries for fresh Installation
    ... You can restore MSDB as well as master. ... > SQL Server, It will create Master, MSDB databases. ...
    (microsoft.public.sqlserver.server)
  • Re: Moving SQL Server 2000 from NT4.0 to Windows 2003
    ... Detach your existing user databases, ... user databases (or RESTORE) to the new server. ... > Hey Steve, ... Windows 2003 will not allow SQL Server SP less than 3. ...
    (microsoft.public.sqlserver.server)
  • Re: Not able to Retrieve mails
    ... Installation of Exchange 2000 was a mistake because it will not use E55 ... databases. ... You need to install E55 back, restore the data from tape, ...
    (microsoft.public.exchange.admin)
  • Re: Server Migration...
    ... If you have restored all of your databases, ... Columnist, SQL Server Professional ... Does that mean I need to restore all user databases first and I restore ... Master, MSDB, Model. ...
    (microsoft.public.sqlserver.server)
  • Re: Please answer my queries for fresh Installation
    ... Moving SQL Server Databases ... Using WITH MOVE in a Restore to a New Location with Detach/Attach ... Disaster Recovery Articles for SQL Server ...
    (microsoft.public.sqlserver.server)
Loading