Restore databases into a new installation of SQL Server

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"Hai-Chu Hsu" <seapearl1023@.ms65.url.com.tw> wrote in message
news:e6c8ee4f.0402281517.401bd196@.posting.google.c om...
> 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.

When restoring via Enterprise manager you have the option
of specifying new physical data and logfiles (paths). Also,
there is the option to restore from a physical device that
does not yet exist (eg: one of your data backups).

In EM you can add a device and point at the data file to
restore, and as above, respecify physical paths.

It should work OK.
Good luck,

Pete Brown
Falls Creek
Oz.
www.mountainman.com.au