restoring sql database from backup
Posted on 2011-10-12
I have sql 2005 and im using microsoft sql server managment studio on a windows 2008 server.
i have done test restores before where i restored backups to a different database name.
this time i have to restore foreal.....
so for instance.
i have to restore the current database "medical" back to a week from today. but i need to restore it as medical.
do i delete the current medical or rename it. then restore the back up to medical.
whats the best way to restore a current in use database?
delete or rename active database or something different?