No announcement yet.

restore DB from same DB on recoverd DB

  • Filter
  • Time
  • Show
Clear All
new posts

  • restore DB from same DB on recoverd DB

    This question is somewhat academic, and I will admit I am by no means a SQL expert. I am running sql 2008 R2. I used backup exec to perform a redirected restore of a database and transaction logs. The DB shows online, but when I go to tasks --> restore from the SQL manager, and try to do a restore "from database", all the databased show up except for the one I restored using Backup exec. Is there a reason for this? I have tried stopping/restarting sql server. The reason I am asking is testing a restore methodology of restoring from the last full rstore + all the transaction logs up to the point of failure using BE, then from inside sql being able to restore to a specific point in time.