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
:)