Backup Exec MS SQL Restore

Posted on 2011-04-20
Last Modified: 2012-05-11
I'm trying to restore an MS SQL backup by redirecting it to another database server using Backup Exec 12.5
when ever i start the restore, the byte count shows 8192 and stays there forever. I have 'inventory-ed' and 'cataloged' as required.
any ideas?
Question by:adjaddy
    LVL 9

    Expert Comment

    Backup Exec is not related to SQL Server/MS. Please post only related to SQL Server here.
    Probably it will be answered by SYMANTEC I believe.

    Author Comment

    I don't see SYMANTEC as one of the zones to select
    LVL 2

    Expert Comment

    I have had this issue before when the servers were different versions of SQL with Backup Exec. I think your issue may be caused by a know bug, see
    LVL 25

    Expert Comment

    by:Ron M
    Question ...

    Are you attempting to re-direct to a DB that already exists ?..

    Try redirecting to a DB name that doesn't exist on the server you are restoring to.
    If I remember this should create the db for you.
    LVL 25

    Expert Comment

    by:Ron M
    Don't create a DB..

    Do your DB selection to restore.
    On SQL redirection, put in the server you are redirecting to, and "restore to database" with a NEW name of a db that doesn't exist.

    On SQL settings, check Replace databases and filegroups
    Consistency check - full check including indexes

    ...try that.
    LVL 75

    Expert Comment

    by:Anthony Perkins
    >>I don't see SYMANTEC as one of the zones to select <<

    Accepted Solution

    Sorry guys, none of your responses work
     i need to restore the DB to overwrite an existing one that supports an application we are testing so creating another one won't help me

    SQLSergeant Mike
    the DB i'm restoring is less than 300GB
    LVL 25

    Expert Comment

    by:Ron M
    You could try renaming the current DB to ..."Name Old 04212011",...then restore to the "old name".

    Author Closing Comment

    no other solution worked

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    This is my first ever Article on EE or elsewhere; therefore, please bear with me if I have some discrepancies in my writing. I read many articles and questions related to "how to pass values to SSIS packages at run-time?"  Hence, this common ques…
    Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
    Via a live example, show how to shrink a transaction log file down to a reasonable size.

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now