Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pcisse
Starting Member
1 Post |
 Posted - 2002-05-06 : 08:03:18
|
| Hello,I have a problem with my backup. So I have make a database backup on a Server(SQL server) and I want now to restore the database not in the same server but on a other server(SQL Server).Is it possible and how can I do? Thanks for helping me. |
|
|
Kevin Snow
Posting Yak Master
149 Posts |
Posted - 2002-05-06 : 13:32:38
|
| This is not terribly difficult.If you are using SQL 7.0 or 2000, you can do it in the Enterprise manager as follows:1) Move the database backup file to a location accessible to the new server.2)Create a database on the new server with the same name as the database you wish to restore.3) Right Click on the database and select ALL TASKS | Restore Database.4) On the GENERAL Tab, select FROM Device.5) Click Select Device, then ADD a device with the path and filename of the backup file. Hit OK for the new device, and OK for the selected device.6)Now go from the GENERAL Tab to the OPTIONS tab. Under the RESTORE as header, enter the path and file name as you want it to appear on the new server. It will default with the path from the original backup. If your new server is configured the same, you may not need to alter these. CHECK the Force Restore over Existing Database option. 7) IF you will not be applying transaction logs, Select the Leave Database Operational option at the bottom of the tab page8) This should restore the database. Any database permissions for account that are NOT on the new server will be orphaned. NT accounts can simply be added to the server logins list. SQL account, may need to be added, and then synced. To do this, try the sp_change_users_login 'autofix','loginaccounthere' fix. It will find the orphaned permissions and attach them to the new login on the new server. |
 |
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2002-05-06 : 13:41:41
|
| Just wanted to add to Kevin's post:It's not a requirement to create a blank database, before you restore from the backup. If the database isn't already there, SQL Server will create it during the restore process.--HTH,Vyashttp://vyaskn.tripod.com |
|
|
|
|
|
|
|
|
Restore a backup on a other server