Restore failed for Server 'Server_Name'

-
TITLE: Microsoft SQL Server Management Studio
------------------------------
Restore failed for Server 'Server_Name'.  (Microsoft.SqlServer.SmoExtended)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1539+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: File "DataBase_Name" cannot be restored over the existing "D:\MSSQL\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\DataBase_Name.mdf". Reissue the RESTORE statement using WITH REPLACE to overwrite pre-existing files, or WITH MOVE to identify an alternate location. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1539+)&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------

Solution:

RESTORE DATABASE [DataBase_Name] FROM  DISK = N'D:\MSSQL\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\DataBase_Name.bak'
WITH  FILE = 1,  MOVE N'DataBase_Name' TO N'D:\MSSQL\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\DataBase_Name.mdf', 
MOVE N'DataBase_Name_log' TO N'D:\MSSQL\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\DataBase_Name_1.ldf', 
NOUNLOAD,  REPLACE,  STATS = 5
GO

or
1. Go to bellow path
D:\MSSQL\MSSQL10_50.MSSQLSERVER\MSSQL\DATA
2. Delete existing database
3. Restore once again

Comments

Post a Comment

Popular posts from this blog

Announcing – Embed your Power BI organizational apps in Microsoft Teams Channels and Meetings

-
Image
We’re excited to announce that you can now embed entire Power BI organizational apps in Microsoft Teams tabs. Until now, this has been one of the top feature requests for Power BI integration with Microsoft Teams. It helps teams and organization put the full Power BI org app experiences directly where people work every day. By adding Org apps in channels and meetings, you enable everyone to access the data they need. We’ve started to roll out the experience to commercial cloud customers and expect it to be available for everyone in the next week or two. Let’s look at the new experience and its benefits. Picking an entire Power BI organizational app to embed in Microsoft Teams To embed a Power BI organizational app, add a Power BI tab to a channel or meeting. Go to the Apps pivot in the selection you and notice the  new checkbox next to the app name . When you check the box, you’re choosing to embed the entire organizational app in the Power BI tab.  If you don’t see an app in ...
Read more

Failed to execute the package or element. Build errors were encountered

-
Error: TITLE: Microsoft Visual Studio ------------------------------ Failed to execute the package or element.   Build errors were encountered. For more information, see the Output window. ------------------------------ BUTTONS: OK ------------------------------   Solution: We tried to close SSDT and run it again but, we still got the same error while running SSIS package. Then, we need to follow bellow solution: Step 1: Go to Task Manager–> Details Tab. Step 2: Locate the process “ DtsDebugHost.exe “. Kill this process. There might be multiple instances of this process. Kill all of them. Step 3: Rerun SSIS package
Read more

Dataset refresh cancellation is now available in Power BI Premium

-
Image
We are excited to share that cancelling an in-progress dataset refresh in Power BI Premium, Power BI Premium Per User, and Power BI Embedded just got significantly easier. A top-20 idea on Power BI Ideas (we do listen and appreciate your feedback), we acknowledge that this capability couldn’t have come soon enough for our customers. In the past, cancelling an ongoing refresh was an unreliable process that required external tools. Earlier this year, we released the Enhanced refresh with Power BI REST API, that – in addition to XMLA based refreshes – allows refresh cancellation. However, it requires the refresh operation to be triggered by the API. Today, users can cancel an ongoing scheduled or on-demand refresh using a contextual button in the Power BI service. Earlier limitations that constrained cancellation no longer apply. To begin using this feature in your Premium workspace, no actions are required. Please note that for datasets created as part of Datamart...
Read more