Link to home
Start Free TrialLog in
Avatar of adjaddy
adjaddy

asked on

Backup Exec MS SQL Restore

Hi
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?
Avatar of radcaesar
radcaesar
Flag of India image

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.
Avatar of adjaddy
adjaddy

ASKER

Radcaesar
I don't see SYMANTEC as one of the zones to select
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 http://www.symantec.com/business/support/index?page=content&id=TECH75125
Avatar of Ron Malmstead
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 correctly...it should create the db for you.
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.
>>I don't see SYMANTEC as one of the zones to select <<
https://www.experts-exchange.com/Storage/Backup_Restore/Backup_Exec/
ASKER CERTIFIED SOLUTION
Avatar of adjaddy
adjaddy

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
You could try renaming the current DB to ..."Name Old 04212011",...then restore to the "old name".
http://www.mssqltips.com/tip.asp?tip=1122
Avatar of adjaddy

ASKER

no other solution worked