Fix/Solution:
Use WITH REPLACE while using the RESTORE command.
RESTORE DATABASE abc FROM DISK = 'C:\backup.bak' WITH REPLACE
In this example abc is one database,backup.bak is backup of abc.
skip to main |
skip to sidebar
About Iyen
- Iyen
- I am Iyen from coimbatore, India.There's nothing much to boast about me. As the name of the blog "Dynamic-Coding" suggests the blog carries about the stuff(Coding/Script) which we generally search in Internet.
Labels
- .NET (13)
- .NET 3.5 (1)
- ADO.NET (2)
- ASP.NET (8)
- Blogspot (1)
- C# (28)
- Crystal Report (1)
- Culture (1)
- Database Manipulation (1)
- Database Recovery (2)
- DataType (2)
- Email (1)
- Excel (2)
- Explorer (1)
- Fix/Solution (3)
- HTML (3)
- JavaScript (4)
- JavaScript-getElementById (2)
- LINQ to Objects (1)
- Macro (2)
- Memory Management (3)
- Multilingual (1)
- OOPS (9)
- PL/SQL (1)
- Satellite Assembly (1)
- Serilization (4)
- SMPT Client (1)
- SQL SERVER (12)
- SQL SERVER 2005 (7)
- Threading (1)
- VB.NET (1)
- VBA (2)
Blog Archive
-
▼
2009
(52)
-
▼
April
(12)
- How to change from Windows Authentication to SQL S...
- Email through SMTP Client (ASP.NET/C#)
- Connection Pooling in .NET
- Memory Usage Reduces On Application Minimize
- Delete Vs Truncate(SQL Server)
- Update Statement Between Two Tables
- SQL Server - Insert multilingual data in table
- How to fix SQL Server Error 3154: The backup set h...
- How to Recover Suspected Database in SQL Server 2000
- Localize Date and Time through Specific Culture
- Disable browser "Back" button
- Script use to Scrolling title in browser.
-
▼
April
(12)
3 comments:
u can easily fix sql server error 3154 by following this blog www.sqlrecoverysoftware.net/blog/sql-server-error-3154.html and let me know is this blog solved your query or not.
I too faced the same error but following the blog http://en.mssqldatabaserepair.org/ I was able to resolve the issue in easy manner. You too must visit the blog.
Post a Comment