Mas Didit,
Coba Restorenya pake WITH Replace.
Misal :
RESTORE DATABASE VoucherIndoDW
FROM DISK = 'C:\VoucherIndoDW_Backup.bak'
WITH REPLACE
Regards,
Suherman
Profile : https://mvp.support.microsoft.com/profile/Suherman
Blog : http://mugi.or.id/blogs/suherman
________________________________
From: didit harsono <[email protected]>
To: "[email protected]" <[email protected]>
Sent: Tuesday, March 19, 2013 11:05 PM
Subject: [Mugi] Restore Database Sql server 2008
saat restore terjadi error dengan pesan..
==================================
Restore failed for Server 'PPIP-07'.
(Microsoft.SqlServer.SmoExtended)
------------------------------
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22+((SQL_PreRelease).080709-1414+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476
------------------------------
Program Location:
at Microsoft.SqlServer.Management.Smo.Restore.SqlRestore(Server srv)
at
Microsoft.SqlServer.Management.SqlManagerUI.SqlRestoreDatabaseOptions.RunRestore()
===================================
System.Data.SqlClient.SqlError: The backup set holds a backup of a database
other than the existing 'VoucherIndoDW' database. (Microsoft.SqlServer.Smo)
------------------------------
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22+((SQL_PreRelease).080709-1414+)&LinkId=20476
------------------------------
Program Location:
at
Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQueryWithMessage(StringCollection
queries, ServerMessageEventHandler dbccMessageHandler, Boolean
errorsAsMessages)
at Microsoft.SqlServer.Management.Smo.BackupRestoreBase.ExecuteSql(Server
server, StringCollection queries)
at Microsoft.SqlServer.Management.Smo.Restore.SqlRestore(Server srv)
sudah saya ublek2 di google namun belum dapat pencerahan, mohon bantuannya
untuk master2..
terimakasih
_______________________________________________
Mugi mailing list
[email protected]
http://lists.mugi.org/mailman/listinfo/mugi
_______________________________________________
Mugi mailing list
[email protected]
http://lists.mugi.org/mailman/listinfo/mugi
