469,621 Members | 1,776 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,621 developers. It's quick & easy.

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
Jul 20 '05 #1
1 2935
"Hai-Chu Hsu" <se**********@ms65.url.com.tw> wrote in message
news:e6**************************@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


Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by Dave | last post: by
7 posts views Thread by AHartman | last post: by
3 posts views Thread by David C. Barber | last post: by
1 post views Thread by nikb | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.