Sql 2008 Error :The backup set holds a backup of a database other than the existing database.

by daz 7/29/2010 11:31:00 PM

An expert is a person who has special skill or knowledge in some particular field; definition from most dictionaries.

Well, i believe an expert is not more than someone who is able to reproduce a solution to a problem or situation given by others.

In other word EXPERT is mmaybe sonmeone who have seen what you haven't yet seen in the programing languages. I alway encourage each programmer have google in his priority friends list.
Well , yesterday a from the State collegue run into a problem (creating) restoring a DB in Viisual studio 2008
He reported the error :The backup set holds a backup of a database other than the existing database and i believe the error number Error 3154;
Well through my year of experience in asp.net and MSSQL i have seen this at least once and as always i log my errors and solution in a my log bloc not.
the solution to this problem is just a line of code

RESTORE  DATABASE  MyNewDB

} }}

FROM 

 

DISK = 'C:\myBackupDB.bak' WITH REPLACE

 

 


That s all you need ..
Hopefully the above code will help you that is reading this..
again
1) Use WITH REPLACE while using the RESTORE command.
2) Delete the older database which is conflicting and restore again using RESTORE command.
those 2 steps is the solution to ya problem..remember , i am not an expert..I have seen it before you

 

 

Poll or Voting Control in Asp.net ajax and C#

by daz 6/20/2010 4:48:00 AM
I have found a very nice poll or survey control from zongoTech This control will help you add a survey in your website. the name is ZTPoll, you may check it out if u are looking for a dll to make a voting in your website. I have tested this control in one of my client site on May and this client was satisfied. I give you the demo link where u can download it Voting Control in DotNet

Tags:

Asp.net, C# | Blog

Open read Email Tracking in C# :the best way

by daz 4/29/2010 6:42:00 PM

Let s talk about open/read email in your application. There are mostly 3 ways on doing it and spammers  or l"azy people" does the easiest way

  1. Request a Confirmation Read Receipt
  2. Append a Query String key to a Beacon Image
  3. Implement a HttpModule to Track Reads

 

Implement a HttpModule to Track Reads  is the best way to avoid getting block with most of the providers like gmail ,yahoo and hotmail.

Full code to come !!!! Comeback2C

 

Tags:

About the author

Name of author
DavidZ
.Net Programmer
E-mail me Send mail

Calendar

<<  August 2010  >>
MoTuWeThFrSaSu
2627282930311
2345678
9101112131415
16171819202122
23242526272829
303112345

View posts in large calendar

Recent comments

Authors

Disclaimer

The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

© Copyright 2010

Sign in