I have:
SQL Server 2008
Database Name: database1
I had taken backup from "database1" nearly one month ago. Now, by someway, "database1" is messed up in some tables.
So I want to recover only those tables from my last backup.
I am trying to make another database named "database2" and restore on it with old backup.
I'm afraid to restore from backup file, which may restore in "database1", I want to re-store in only 'database2' (which is new)