Hi All,
    I took backup of a Database from a remote machine on to a local machine,while am restoring the backup i am getting the following error.using SQL Server Management studio 2005.

Error Message

TITLE: Microsoft SQL Server Management Studio
------------------------------

Restore failed for Server 'localhost'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdN...r&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'AFIN_UADev_2005' database. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdN...0&LinkId=20476
------------------------------
BUTTONS:

OK
------------------------------

Below is the command i executed in the Management studio 2005

use master
go

BACKUP DATABASE [AFIN_UADev_2005] TO DISK = N'\\10.171.74.36\c$\PINI-Db-
Bak\AFIN_UADev_2005.bak'
WITH NOFORMAT, NOINIT, NAME = N'AFIN_UADev_2005-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO


10.171.74.36=Local Machine Ip

PINI-Db-Bak=Location to which the bak file is to be saved.This folder is shared and given full access permissions.

AFIN_UADev_2005=Name of the Db on the remote machine

AFIN_UADev_2005.bak=backup file name in the local machine

Cheers
Sri

:)