September 1, 2006 at 7:12 am
hi
I want to restore a full bakup file as a new database in a seperate server.
The full backup file is transferred to the server and is there on the disc. Sql Server is installed on the server and the backup file is to be restored as a some new database on the present server.
Harris
September 1, 2006 at 7:24 am
Hello Harris,
On which version you are trying to restore the backup?
SQL2000:
Go to SQL Enterprise Manager -> Your new SQL Server -> Databases -> Right Mouse Click -> Restore
General Tab -> You will be prompted for the database name. Give the desired name and then click on devices and select the location where the backup file has been saved.
If you want to change the location (path) of the database files from the default location, can do so.
On the next tab -> select force restore the database check box and click on OK.
SQL2005:
Same steps but you need to see that as soon as the backup file location is given, you will be shown with the database backup details and you need to click on "Restore" check box and on the next tab select "force restore" and then click ok.
That's it.
If you stuck up anywhere, do reply and will help you.
Thanks
Lucky
September 4, 2006 at 1:38 am
Hi Harry,
You can also use the RESTORE DATABASE command to do this:
RESTORE DATABASE <put-new-database-name-here>
FROM
FILE = '<write-the-complete-physical-path-of-the-backup-file-here>'
WITH
RECOVERY,
MOVE '<logical-mdf-file-name>' TO '<physical-path-of-the-mdf-file-on-new-server>',
MOVE '<logical-ldf-file-name>' TO '<physical-path-of-the-ldf-file-on-new-server>'
After restoring the database, you will have to fix the orphaned users. Make sure that you already transferred the respective Logins to the new server. Then, you can use sp_change_users_login stored proc to fix the orphaned users.
BR
Pankaj
Pankaj Khanna
Database Administrator - SQL Server 2000
Keep hope to keep you intact...
September 7, 2006 at 3:43 pm
My question is. What if i have backup of all my databases( master, msdb, .......) and I want to restore on the new server with fresh installation of sqlserver. What is correct path to do that. I did what book says but does not work ?!?!?
Every database is backed up with BACKUP DATABASE command and in seperate file.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply