Post reply

Sql server 2005 recover

  • February 9, 2009 at 12:13 am

    #200035

    I am trying to restore the database which is on my hard drive. But it giving an exception.Here is the exception reasied:

    An exception occured while execituing a Tansact-SQL statement or batch(Ms.Sqlserver.Express.ConnectionInfo)

    Additional Info

    the family on device (file location path ).mdf is incorrectlu formed; SQL Server cannot rocess this media family

    RESTORE HEADERONLY is terminating abnormally(MSSQLSERVER, Error: 3241)

    Which click on OK, i'm being directed to select the back device.

    Please help me if anybody knows how to resolve this issue

    Thanks in advance

    Raveens

  • February 9, 2009 at 11:00 am

    #940668

    The file that you're trying to restore (which looks like an mdf file) is not a valid backup.

    Can you explain more what you're trying to do, with what files and why?

    If that's a database data file you have, just attach it. Restore is for backup files (the typical extension been .bak)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 9, 2009 at 9:57 pm

    #940953

    Hi

    thanks for th reply. I could do that yesterday itself. I came know the issue and resolve.

    I imported the db on sql server 7.0 using DTS and took back up of latest db(sql server 7.0) and restored on sql server 2005

    But I could import only tables but not views, indices, stored proc's and triggers. Can I get them

    Is there any way to achieve this goal using these procedures.

    1. Postgre sql 2007(lite or manager) to sql server 7.0 and

    sql server 7.0 to sql server 2005

    OR else

    2. postgre sql 2007(lite or manager) to sql server 2005

    Thanks in advance

  • February 9, 2009 at 10:15 pm

    #940960

    Other objects, views, procedures, etc. aren't automatically transferred. You need to rewrite these in T-SQL from whatever variant of SQL Postgres uses.

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply