>>I knew this would happen; that some day I will mess up my test SQL database and will need to replace it with the backup. Fortunately, I do make routine backups. What I have is the .bak version of the DB. For example, MyTestDatabase.bak; which is on the external drive. And I have the actual database, MyTestDatabase in the SQL Server 2008.
>>What steps should I take to replace the damaged one with the .bak from the external drive?
>
>You may create a temporary database first. Then, simply adjust your restore script to restore on that temporary database. You can then test accordingly. If that works, you can remove the damaged one and rename the one you just restored to the required name.
Thank you.
But I don't even know how to create a temporary database.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
