c# - DB backup is not being restored to another DB. It is showing "Specified cast is not valid" error -


i have been experiencing "specified cast not valid" error while restoring backup of db. version of sql server management tool taking backup "microsoft sql server 2008 r2 (sp1) - 10.50.2500.0 (intel x86) jun 17 2011 00:57:23 copyright (c) microsoft corporation express edition advanced services on windows nt 6.1 (build 7601: service pack 1) (wow64) (hypervisor) ". , restoring same version tool.

i have tried suggested solutions mentioned on other posts not work me.

  1. i have tried creating mdf , ldf files , attached them local db.
  2. i have tried generate script this.
  3. i have tried updating sql management tool 2012 r2 doesn't work.

is there other solution issue resolved?

that seems common error when restoring via ssms. assuming did, can work around issue restoring via tsql.

  1. grab backup file details via "restore filelistonly disk = n''"
  2. build restore command proper move option.

final restore command should this:

restore database [mydb] disk = n'c:\backup\mydb.bak'    move n'mydb_data' n'd:\data\mydb.mdf' , move n'mydb_log' n'e:\log\mydb_log.ldf' , replace

Comments

Post a Comment

Popular posts from this blog

IF statement in MySQL trigger -

this query code in mysql trigger. if 1=2 select 'yes'; else select 'no'; end if; but has following error: if '1'='2' select 'yes' error code: 1064. have error in sql syntax; check manual corresponds mysql server version right syntax use near 'if '1'='2' select 'yes'' @ line 1 0.000 sec what solution?
Read more

c++ - What does MSC in "// appease MSC" comments mean? -

i run across // appease msc in c++ comments, e.g. here : const int& array::operator[](int offset) const { int mysize = getitssize(); if (offset >= 0 && offset < getitssize()) return ptype[offset]; throw xboundary(); return ptype[offset]; // appease msc! } what msc stand ? the author means microsoft's compiler, more formally known msvc.
Read more

javascript - Blogger related post gadget image Resize s72-c [ Need Expert Help ] -

i run blogger blog , use follow code javascript code (requires no jquery) show related post labels/categories of post. <script type='text/javascript'> var defaultnoimage=&quot;http://1.bp.blogspot.com/-m72rpguntq0/vuokijudn_i/aaaaaaaaboi/lq18sceunsg/w72/favicon-tik.png&quot;; var maxresults=16; var splittercolor=&quot;#d4eaf2&quot;; var relatedpoststitle=&quot;related posts&quot;; </script> <script type='text/javascript'>//<![cdata[ var relatedtitles = new array(); var relatedtitlesnum = 0; var relatedurls = new array(); var thumburl = new array(); function related_results_labels_thumbs(json) { (var = 0; < json.feed.entry.length; i++) { var entry = json.feed.entry[i]; relatedtitles[relatedtitlesnum] = entry.title.$t; try { thumburl[relatedtitlesnum] = entry.media$thumbnail.url } catch (error) {...
Read more