Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
moraes
Starting Member
3 Posts |
 Posted - 2007-08-24 : 08:30:04
|
Hi All,I'm a newbie in SQL in my company (I'm helping the DBA) As a part of my new position I'm auditing the SQL servers (including backup and restore)I've been trying to restore a diff backup but I'm receiving an error. First I restore the Full Database with "leave database nonoperational......" and after the full restore the database still in "loading mode". When I've try to restore the differential backup over the full I receive the following error:a0008492 - Database Query Failure (from Veritas)I think I'm doing something wrong  ..Can anyone help me? Best Regards / Mit Besten GrüßenMarcelo MoraesExchange/SQL/E-CommerceDas ist nicht mein bier! |
|
|
moraes
Starting Member
3 Posts |
Posted - 2007-08-28 : 09:37:09
|
| I found the solution......Marcelo MoraesExchange/SQL/E-CommerceDas ist nicht mein bier! |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-09-04 : 16:06:59
|
| can you share the solution? it would be interesting... although i didn't let BE directly backup the files as database files, I have difficulty in restoring them from tape... something about cataloguing and re-inventory... quite frustrating--------------------keeping it simple... |
|
|
|
dewacorp.alliances
452 Posts |
Posted - 2007-09-05 : 09:31:54
|
| My advice will be: use the native SQL backup into a secondary/remote server and leave it depending on how much space you have and then take BackupExec or any other backup utility to take that into a tape.Beside ... you have more control on doing the backup and test backup/restore into a different database on different server. |
|
|
|
|
|
|
Restore Using BackupExec 91